kung foo man
14th May 2013, 13: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
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