Access denied for user
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:
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).
Re: Access denied for user
Section 5.9 of the MySQL Manual: User Management
Use the GRANT statement to create new user accounts. e.g.:
So with this you will need the following SQL statement:
|All times are GMT +5.5. The time now is 03:51.|