TurnKey Linux Virtual Appliance Library

phpMyAdmin user logins

I'm trying the MySQL appliance out for the first time and I'm having trouble with phpMyAdmin logins.

I'm able to login OK as root, but I can't figure out how to allow other users login privileges.  I've created an alternate admin user and with full global privileges.  I've also created a database with a user that has full privileges to that database.  I can't login with either user, instead I receive the "Cannot log in to the MySQL server" error.

Alon Swartz's picture

Host must be set to localhost

I just created a test admin user as follows:

- log into phpmyadmin as root
- click privileges -> add a new user
    - specify username
    - specify host as Local
    - specify password
    - grant all privileges on wildcard name (username\_%)
    - global privileges - check all
    - go
- reload privileges
- logout

- log back in as your new user

Thanks

Yes, host as local was what I was missing.  Thanks

did the trick

looking for this solution for an hour. Thanks for posting!

You saved my hours

Thanks very much buddy for sharing this.

Been struggling for hours .. was adding deleting users & finally your post solved the issue.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)