While investigating some mysql stuff at work I imported the whole mysql dump from our production system into my localhost installation. Among the 2000 or so databases was also information_schema, and I ended up with problems like :
root@pluto:~# /etc/init.d/mysql status /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' *
The solution was to reset password fr debian-sys-maint user in mysql.
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
Where ‘password’ is found in /etc/mysql/debian.cnf 🙂
I got this one from ubuntuforums.org.