Access denied for user ‘debian-sys-maint’@'localhost’
Debian have their own way for doing things. Here is a quick fix up if mess with the mysql-maintain user.
If you end up having error like that one when restarting your mysql server:
armed:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld failed! Starting MySQL database server: mysqld already running. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
First you need to find out what is the password for your system:
armed:~# cat /etc/mysql/debian.cnf | grep pass password = x4FStDr29DDshTFqsf
and than add the user:
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;