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