Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#4273 New user cannot log in

4.0.9
out-of-date
nobody
user login (1)
6
2014-02-06
2014-02-05
Rob Lewis
No

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.

Discussion

  • Marc Delisle
    Marc Delisle
    2014-02-05

    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.

     
  • Marc Delisle
    Marc Delisle
    2014-02-05

    • status: open --> out-of-date
     
  • Rob Lewis
    Rob Lewis
    2014-02-05

    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.

     
  • Marc Delisle
    Marc Delisle
    2014-02-06

    phpMyAdmin warns about this, since version 4.1.0.

     
    • Rob Lewis
      Rob Lewis
      2014-02-06

      Missed it by THAT MUCH ;-)
      (I'm using v. 4.0.9)