MySQL Server won't start in Gentoo
I had MySQL and everything working fine and then yesterday ran emerge -u world. This seems to have killed mysql though.
When I try to run /etc/init.d/mysql start, I get: "MySQL NOT started (0)"
When I run /usr/bin/mysqld_safe & mysqladmin -u root password '[passwd here]' , I get:
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!
Well, mysqld is not running (that's what I'm trying to do) and the directory /var/run/mysqld/ is empty, so this socket doesn't seem to exist.
I have no idea what socket I used before since it used to just work.
btw, mysql does seem to start on startup, but doesn't seem to work properly. When I run
/etc/init.d/mysql restart, it gives me:
Stopping mysql...
/etc/init.d/mysql: line 334: /var/run/mysqld/mysqld.pid: No such file or directory
Stopping mysqld (0)
...
Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock"
it will be removed now and re-created by the MySQL server
BUT please make our checks.
Starting mysql (/etc/mysql/my.cnf)
MySQL NOT started (0)
I'm not sure if there are repair utilities I can use or what log files to look into.
Thanks.
- Ryan
Last edited by mclinkor; 09-20-2006 at 10:09 AM.
|