Created new user but can't login

[lone_stranger]

I'm using the Build your own Database Driven Website using PHP & MySQL to help me learn PHP & mySQL (obviously).

I wanted to create a new user that had limited access to MySql server that I could use in my login.inc.php file. I don't want to use root incase anyone manages to get hold of the login details then they can do what they want to my database.

I created a new user with the following rights delete, insert, lock tables, select, update and file on a specific database.

I used the following command to grant the access setting the user up to be able to login from any computer (I think):

grant privilege on db.*
to user@"%"
identified by 'password';

When I exit mysql and try and log back in using the new users details:

mysql -h localhost -u user -p
password

I get the following error:
Access denied for user 'user'@'localhost' (using password: YES)

When I put the details in my login.inc.php file it also doesn't allow access to the database.

Can anyone please help?

[lilleman]

You have to reload the privileges to be able to use the new user. This is done by running the query FLUSH PRIVILEGES.

[lone_stranger]

Thanks for the quick reply, but I just tried FLUSH PRIVILEGES and I still can't login as my new user.

[ses5909]

Kind of like rebooting windows, but try restarting mysql?

[lone_stranger]

Thanks for the advice, but I found the answer on a tutorial for setting up users. I thought

grant all on database.*
to user@"%"
identified by 'password';

would set the privileges for localhost as "%" is said to represent any server. Turns out it doesn't represent localhost.

Once I declared all the privileges I wanted for localhost I was able to use my new user.