← Back to team overview

sslug-teknik team mailing list archive

mysql fejl

 

Hejsa

Jeg har nogle problemer med mysql på en ny server (debian/stable). Enten er der noget som er helt bøffet op eller osse er det fordi jeg har ændret root passwordet på mysql og "glemt" at fortælle det til mysqladmin eller lign. Anyways, her er lidt info:

[root@aalborg root]# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld...failed.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

[root@aalborg root]# tail -n 20  /var/log/syslog
Feb 15 10:44:01 localhost /etc/init.d/mysql[2420]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Feb 15 10:44:01 localhost /etc/init.d/mysql[2420]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Feb 15 10:44:01 localhost /etc/init.d/mysql[2420]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Feb 15 10:44:01 localhost /etc/init.d/mysql[2420]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Feb 15 10:44:01 localhost /etc/init.d/mysql[2420]:
Feb 15 10:45:43 localhost mysqld_safe[2497]: started
Feb 15 10:45:44 localhost mysqld[2501]: 060215 10:45:44  InnoDB: Started
Feb 15 10:45:44 localhost mysqld[2501]: 060215 10:45:44 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
Feb 15 10:45:44 localhost mysqld[2501]: 060215 10:45:44 Aborting
Feb 15 10:45:44 localhost mysqld[2501]:
Feb 15 10:45:44 localhost mysqld[2501]: 060215 10:45:44 InnoDB: Starting shutdown... Feb 15 10:45:47 localhost mysqld[2501]: 060215 10:45:47 InnoDB: Shutdown completed Feb 15 10:45:47 localhost mysqld[2501]: 060215 10:45:47 /usr/sbin/mysqld: Shutdown Complete
Feb 15 10:45:47 localhost mysqld[2501]:
Feb 15 10:45:47 localhost mysqld_safe[2531]: ended
Feb 15 10:45:50 localhost /etc/init.d/mysql[2574]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Feb 15 10:45:50 localhost /etc/init.d/mysql[2574]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Feb 15 10:45:50 localhost /etc/init.d/mysql[2574]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Feb 15 10:45:50 localhost /etc/init.d/mysql[2574]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Feb 15 10:45:50 localhost /etc/init.d/mysql[2574]:

--
peace, love & harmony
Atte

http://www.atte.dk


Follow ups