PDA

View Full Version : [FAIL] Stopping MySQL database server: mysqld failed!



kung foo man
14th May 2013, 14:49
Hey all,

in Debian 7.0 Wheezy they added special permissions for server restarting. Not knowing this, I just overwrite the MySQL-databases with my backed up ones. After that, I couldn't restart the server anymore.

To fix that, you need to grant rights on the database "mysql" for "debian-sys-maint". The password is written in /etc/mysql/debian.cnf



/etc/init.d/mysql restart
[FAIL] Stopping MySQL database server: mysqld failed!
[ ok ] Starting MySQL database server: mysqld already running.




GRANT ALL PRIVILEGES ON mysql TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'the maintainer password' WITH GRANT OPTION;


Now you should be able to restart the server with /etc/init.d/mysql restart, I didn't need "FLUSH PRIVILEGES".

Regards,
kung foo man