Logging in as new user

[seangriscti]

I am new to MySQL. I have created a database using CREATE DATABASE mydb; then created a new user using GRANT ALL ON mydb.* TO myuser IDENNTIFIED BY 'mypwd';

When a try and start mysql logging in as this user by typing mysql -u myuser -p at the LINUX prompt, I am prompted for a password. I type mypwd but I am refused access.

Why is this?

[mikeatrpi]

Every time you work with users, you need to reload mysql.

RELOAD should do it.

Check this page for more:
mySQL Manual