Slackware 9.1 & mysql

[Kil]

Mam problem z odpaleniem mysql w slaku

otuz robilem juz wszystkimi znanymi mi sposobami i nic

domyslam sie ze chodzi o konfiguracje ale juz sam nie wiem moze

napisze ktos dokladny opis instalacji mysql a prede wszystkim konmfiguracji

 

a dokadniej moze poradzicie

#mysqladmin ping

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySql server through socket '/var/run/mysql/mysql.sock' (2)'

Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!

 

kiedy dam :

#mysqld_safe

Starting mysqld daemon which darabases from /var/lib/mysql

040220 11:33:48 mysql ended

 

POMOCY

[Gość]

Pokaz jego logi... logi, logi, logi... ;]

[bigfan]

Chce bys zalozyla mini a teraz pokaz swoje logi... tralala

[Kil]

040218 17:06:02 mysqld started

InnoDB: The first specified data file ./ibdata1 did not exist:

InnoDB: a new database to be created!

040218 17:06:03 InnoDB: Setting file ./ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

040218 17:06:05 InnoDB: Log file ./ib_logfile0 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

040218 17:06:05 InnoDB: Log file ./ib_logfile1 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

040218 17:06:08 InnoDB: Started

040218 17:06:08 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040218 17:06:08 Aborting

 

040218 17:06:08 InnoDB: Starting shutdown...

040218 17:06:10 InnoDB: Shutdown completed

040218 17:06:10 /usr/libexec/mysqld: Shutdown Complete

 

040218 17:06:10 mysqld ended

 

040218 17:15:20 mysqld started

040218 17:15:22 InnoDB: Started

040218 17:15:23 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040218 17:15:23 Aborting

 

040218 17:15:23 InnoDB: Starting shutdown...

040218 17:15:25 InnoDB: Shutdown completed

040218 17:15:25 /usr/libexec/mysqld: Shutdown Complete

 

040218 17:15:25 mysqld ended

 

040218 17:24:51 mysqld started

040218 17:24:54 InnoDB: Started

040218 17:24:54 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040218 17:24:54 Aborting

 

040218 17:24:54 InnoDB: Starting shutdown...

040218 17:24:57 InnoDB: Shutdown completed

040218 17:24:57 /usr/libexec/mysqld: Shutdown Complete

 

040218 17:24:57 mysqld ended

 

040218 17:29:10 mysqld started

040218 17:29:12 InnoDB: Started

040218 17:29:13 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040218 17:29:13 Aborting

 

040218 17:29:13 InnoDB: Starting shutdown...

040218 17:29:15 InnoDB: Shutdown completed

040218 17:29:15 /usr/libexec/mysqld: Shutdown Complete

 

040218 17:29:15 mysqld ended

 

040218 17:44:06 mysqld started

040218 17:44:08 InnoDB: Started

040218 17:44:08 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040218 17:44:08 Aborting

 

040218 17:44:08 InnoDB: Starting shutdown...

040218 17:44:11 InnoDB: Shutdown completed

040218 17:44:11 /usr/libexec/mysqld: Shutdown Complete

 

040218 17:44:11 mysqld ended

 

040219 11:23:40 mysqld started

040219 11:23:42 InnoDB: Started

040219 11:23:42 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 11:23:42 Aborting

 

040219 11:23:42 InnoDB: Starting shutdown...

040219 11:23:45 InnoDB: Shutdown completed

040219 11:23:45 /usr/libexec/mysqld: Shutdown Complete

 

040219 11:23:45 mysqld ended

 

040219 11:28:08 mysqld started

040219 11:28:08 InnoDB: Started

040219 11:28:08 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 11:28:08 Aborting

 

040219 11:28:08 InnoDB: Starting shutdown...

040219 11:28:11 InnoDB: Shutdown completed

040219 11:28:11 /usr/libexec/mysqld: Shutdown Complete

 

040219 11:28:11 mysqld ended

 

040219 11:57:14 mysqld started

040219 11:57:17 InnoDB: Started

040219 11:57:17 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 11:57:17 Aborting

 

040219 11:57:17 InnoDB: Starting shutdown...

040219 11:57:19 InnoDB: Shutdown completed

040219 11:57:19 /usr/libexec/mysqld: Shutdown Complete

 

040219 11:57:19 mysqld ended

 

040219 13:49:50 mysqld started

040219 13:49:53 InnoDB: Started

040219 13:49:53 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 13:49:53 Aborting

 

040219 13:49:53 InnoDB: Starting shutdown...

040219 13:49:55 InnoDB: Shutdown completed

040219 13:49:55 /usr/libexec/mysqld: Shutdown Complete

 

040219 13:49:55 mysqld ended

 

040219 14:51:29 mysqld started

040219 14:51:32 InnoDB: Started

040219 14:51:32 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 14:51:32 Aborting

 

040219 14:51:32 InnoDB: Starting shutdown...

040219 14:51:34 InnoDB: Shutdown completed

040219 14:51:34 /usr/libexec/mysqld: Shutdown Complete

 

040219 14:51:34 mysqld ended

 

040219 15:09:49 mysqld started

040219 15:09:51 InnoDB: Started

040219 15:09:52 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 15:09:52 Aborting

 

040219 15:09:52 InnoDB: Starting shutdown...

040219 15:09:54 InnoDB: Shutdown completed

040219 15:09:54 /usr/libexec/mysqld: Shutdown Complete

 

040219 15:09:54 mysqld ended

 

040219 15:49:32 mysqld started

040219 15:49:33 InnoDB: Started

040219 15:49:33 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 15:49:33 Aborting

 

040219 15:49:33 InnoDB: Starting shutdown...

040219 15:49:35 InnoDB: Shutdown completed

040219 15:49:35 /usr/libexec/mysqld: Shutdown Complete

 

040219 15:49:35 mysqld ended

 

040219 16:01:48 mysqld started

040219 16:01:49 InnoDB: Started

040219 16:01:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 16:01:49 Aborting

 

040219 16:01:49 InnoDB: Starting shutdown...

040219 16:01:51 InnoDB: Shutdown completed

040219 16:01:51 /usr/libexec/mysqld: Shutdown Complete

 

040219 16:01:51 mysqld ended

 

040219 16:16:07 mysqld started

040219 16:16:09 InnoDB: Started

040219 16:16:09 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 16:16:09 Aborting

 

040219 16:16:09 InnoDB: Starting shutdown...

040219 16:16:12 InnoDB: Shutdown completed

040219 16:16:12 /usr/libexec/mysqld: Shutdown Complete

 

040219 16:16:12 mysqld ended

 

040219 16:28:43 mysqld started

040219 16:28:43 InnoDB: Started

040219 16:28:43 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 16:28:43 Aborting

 

040219 16:28:43 InnoDB: Starting shutdown...

040219 16:28:46 InnoDB: Shutdown completed

040219 16:28:46 /usr/libexec/mysqld: Shutdown Complete

 

040219 16:28:46 mysqld ended

 

040219 16:38:30 mysqld started

040219 16:38:31 InnoDB: Started

040219 16:38:31 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

040219 16:38:31 Aborting

 

040219 16:38:31 InnoDB: Starting shutdown...

040219 16:38:33 InnoDB: Shutdown completed

040219 16:38:33 /usr/libexec/mysqld: Shutdown Complete

 

040219 16:38:33 mysqld ended

 

040219 16:48:08 mysqld started

040219 16:48:09 InnoDB: Started

/usr/libexec/mysqld: ready for connections.

Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306

A mysqld process already exists at Thu Feb 19 16:49:03 CET 2004

 

Status information:

 

Current dir: /var/lib/mysql/

Current locks:

key_cache status:

blocks used: 1

not flushed: 0

w_requests: 0

writes: 0

r_requests: 0

reads: 0

 

handler status:

read_key: 0

read_next: 0

read_rnd 0

read_first: 0

write: 0

delete 0

update: 0

 

Table status:

Opened tables: 0

Open tables: 0

Open files: 0

Open streams: 0

 

Alarm status:

Active alarms: 0

Max used alarms: 1

Next alarm time: 0

040219 17:08:23 /usr/libexec/mysqld: Normal shutdown

 

040219 17:08:23 InnoDB: Starting shutdown...

040219 17:08:23 InnoDB: Shutdown completed

040219 17:08:23 /usr/libexec/mysqld: Shutdown Complete

 

040219 17:08:23 mysqld ended

 

040219 17:12:09 mysqld started

040219 17:12:11 InnoDB: Started

/usr/libexec/mysqld: ready for connections.

Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306

040219 17:47:24 /usr/libexec/mysqld: Normal shutdown

 

040219 17:47:24 InnoDB: Starting shutdown...

040219 17:47:26 InnoDB: Shutdown completed

040219 17:47:26 /usr/libexec/mysqld: Shutdown Complete

 

040219 17:47:26 mysqld ended

 

040219 17:50:14 mysqld started

040219 17:50:16 InnoDB: Started

/usr/libexec/mysqld: ready for connections.

Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306

040219 17:50:32 /usr/libexec/mysqld: Normal shutdown

 

040219 17:50:32 InnoDB: Starting shutdown...

040219 17:50:34 InnoDB: Shutdown completed

040219 17:50:34 /usr/libexec/mysqld: Shutdown Complete

 

040219 17:50:34 mysqld ended

 

040219 18:02:25 mysqld started

040219 18:02:28 InnoDB: Started

/usr/libexec/mysqld: ready for connections.

Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306

040220 11:12:42 mysqld started

040220 11:12:42 Can't start server: Bind on TCP/IP port: Address already in use

040220 11:12:42 Do you already have another mysqld server running on port: 3306 ?

040220 11:12:42 Aborting

 

040220 11:12:42 /usr/libexec/mysqld: Shutdown Complete

 

040220 11:12:42 mysqld ended

 

040220 11:33:48 mysqld started

040220 11:33:48 Can't start server: Bind on TCP/IP port: Address already in use

040220 11:33:48 Do you already have another mysqld server running on port: 3306 ?

040220 11:33:48 Aborting

 

040220 11:33:48 /usr/libexec/mysqld: Shutdown Complete

 

040220 11:33:48 mysqld ended

 

040220 12:15:32 mysqld started

040220 12:15:33 InnoDB: Started

/usr/libexec/mysqld: ready for connections.

Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306

040220 13:29:46 mysqld started

040220 13:29:48 InnoDB: Started

/usr/libexec/mysqld: ready for connections.

Version: '4.0.15a' socket: '/var/run/mysql/mysql.sock' port: 3306

[andriu]

Mam problem z odpaleniem mysql w slaku

otuz robilem juz wszystkimi znanymi mi sposobami i nic

domyslam sie ze chodzi o  konfiguracje ale juz sam nie wiem moze 

napisze ktos dokladny opis instalacji mysql a prede wszystkim konmfiguracji 

 

a dokadniej moze poradzicie

#mysqladmin ping

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySql server through socket '/var/run/mysql/mysql.sock' (2)'

Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!

 

kiedy dam :

#mysqld_safe

Starting mysqld daemon which darabases from /var/lib/mysql

040220 11:33:48 mysql ended

 

POMOCY

echhh, szkoda gadać, proponuje przeczytać sobie pliczek INSTALL-BINARY, tam wszystko jest

 

a odpala sie ./mysqld_safe --user=mysql &

 

 

oczywiscie trzeba miec takiego użytkownika