phpmyadmin #1045 Cannot log in to the MySQL server

Posted by KsI on July 17, 2012 Leave a comment (0) Go to comments

Our developers really crazy about phpmyadmin 🙂 and ask me to setup one.
I really prefer console…
Setup in ubuntu is easy just use aptitude, Luke…
Only change I did is to add Basic Auth to phpmyadmin url, to prevent ugly internet bots from trying to bruteforce my databases.

htpasswd /etc/phpmyadmin/htpasswd.setup developers

But when I try to login to my DB interface I`v got this damned error.
#1045 Cannot log in to the MySQL server
Very very strange! I can login via console with this username…
I create user with following credentials:

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,CREATE ROUTINE,
CREATE TEMPORARY TABLES,CREATE VIEW,EXECUTE,INDEX,SHOW VIEW, ALTER ROUTINE
on *.* to 'developer'@'%' IDENTIFIED by 'MEGASECUREPASSWORD';

phpmyadmin refuse this user. I turn on mysql debugging.

general_log_file = /var/log/mysql/mysql.log
general_log = 1
log_warnings = 1

and read at logs that user developer@localhost – access deny. Hm. Looks like phpmyadmin send wrong password. I spend a little time for investigation, but didn`t found a clue, so I create the same user, with the same password, but with host=localhost

And now developers gain their access to databases via phpmyadmin.
Damn I still don`t know why developer’@’% cannot login.
BTW: And I still don`t understand, why they don`t use mysql Yog or other gui… 🙂 Strange world… Really strange.