MySQL Privileges Conundrum

[Nephalim]

It seems every time i create a new database or mess with MySQL in any way, I have problems with the GRANT statement. ARGH! So, I formatted my development computer and installed MySQL 4 with mysqld-max-nt. I was using 3.23 with mysqld-nt before. Then, I read in my databases from my backup file and tried to run my applications only to get an error:

Warning: mysql_connect(): Access denied for user: 'php@localhost' (Using password: YES) in C:\blog\main.php on line 5

I tried to do a GRANT ALL ON blog.* but received an error that I had incorrectly used the GRANT command, or, if tried to make the user 'php@localhost' or 'php', it said the user was denied access. As far as I can tell, I did nothing different than before.

!@%#&@#$@#$ This is one area of MySQL I don't like - any help?

[Grizzly]

So this is a new installation of MySQL? I'm assuming you've logged in as root, and are staring at a SQL prompt? I think your only problem is that you don't have the syntax quite right when trying to add the "php" user you're trying to create. The syntax should go something like this:

GRANT ALL PRIVILEGES ON blog.* TO php@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Good luck Neph.