MySQL user created via command line can't access PHPMyAdmin I'm trying to create a read-only user with access to one database in PHPMyAdmin.  Since I'm a server newbie I followed some instructions line-by-line on setting up my database and PHPMyAdmin.  As such, my root account is not accessible via the GUI; only a full access child account.  This account cannot create users via the GUI, so I did the following via command line:

mysql -u root -p
mysql&gt; create user 'readonly-user'@'localhost' IDENTIFIED BY 'password';
mysql&gt; grant select on mydatabase.* to 'readonly-user'@'localhost';


If I try to log in via PHPMyAdmin as readonly-user, however, I'm not able to get in.

Is there something I need to do to register this account with PHPMyAdmin?
You have to run the FLUSH PRIVILEGES; command.