Josh's picture

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

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
Josh's picture

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

Add new comment