[MySQLGEEK]

I tried the GRANT syntax, but I too am having this problem.

PLEASE HELP. This is frustrating. I am new to MySQL.

Cannot connect as anything other than root, using shell or PHP pages on localhost.

Here's my error:

[in shell]
ERROR 1045: Access denied for user: 'greg@localhost' (Using password: YES)

[in php page]
Warning: Access denied for user: 'greg@localhost' (Using password: YES) in /[...]/dbtest.php on line 14

(I'm developing under OS X 10.1, but that should not make a difference).

[pete_bisby]

Section 5.9 of the MySQL Manual: User Management

Use the GRANT statement to create new user accounts. e.g.:

GRANT ALL PRIVILEGES ON *.* TO 'user1'@'localhost' IDENTIFIED BY 'a_passwd';

This will create a user account with the username "user1" allowed access to all databases on the server with the password "a_passwd", which will be encrypted.

So with this you will need the following SQL statement:

GRANT ALL PRIVILEGES ON *.* TO 'greg'@'localhost' IDENTIFIED BY 'a_passwd';