Menu
▾
▴
#4273 New user cannot log in
Created a new MySQL user account with a password, and "%" for host id. When I try to log in, either remotely or from the LAN the server is on, I get a message that the username or password are incorrect and login failed.
I checked the user account settings in MySQL Workbench and they match what phpMyAdmin shows. Why is the login being rejected? My other account logins still work fine.
Sorry, support for this version (other than security fixes) has ended, see http://www.phpmyadmin.net/home_page/downloads.php.
Please upgrade to 4.1. Alternatively, see for your support options.
I tried to post this yesterday but I guess it didn't work. It turns out that a close reading of the MySQL documentation indicates that if you want to use "%" as the user's host id, you must also create an identical user with "localhost" as the id. The explanation (http://dev.mysql.com/doc/refman/5.5/en/adding-users.html) is rather confusing, but who am I to say it doesn't make sense?
In any case, sorry for the false alarm. However, if phpMyAdmin wanted to be extra user-friendly, it might warn people of this issue when they're creating user accounts.
phpMyAdmin warns about this, since version 4.1.0.
Missed it by THAT MUCH ;-)
(I'm using v. 4.0.9)