Wednesday, August 3, 2011

Mysql : Problems with debian-sys-maint db user.

I recently restored a Mysql full database backup to a new server. As a result I had a problem with the system user (i.e. debian-sys-maint ).

The quickest way to get 'debian-sys-maint' working on the new server is:

1) /etc/mysql/debian.cnf and get the password.
2) Run mysql -u root -p
3) Run GRANT ALL PRIVILEGES ON *.* \
TO 'debian-sys-maint'@'localhost' \
IDENTIFIED BY 'passwordIndebian.cnf' WITH GRANT OPTION;
 
HTH
Brent 

No comments:

Post a Comment