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
Code:/etc/init.d/mysql restart [FAIL] Stopping MySQL database server: mysqld failed! [ ok ] Starting MySQL database server: mysqld already running.Now you should be able to restart the server with /etc/init.d/mysql restart, I didn't need "FLUSH PRIVILEGES".Code:GRANT ALL PRIVILEGES ON mysql TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'the maintainer password' WITH GRANT OPTION;
Regards,
kung foo man



					
					
					
						
Reply With Quote