Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forumdisplay.php?f=42)
-   -   Access denied for user (http://www.go4expert.com/showthread.php?t=1292)

MySQLGEEK 29Aug2006 09:03
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:

[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 17Nov2007 21:02
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.:
Code:
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:
Code:
GRANT ALL PRIVILEGES ON *.* TO 'greg'@'localhost' IDENTIFIED BY 'a_passwd';


All times are GMT +5.5. The time now is 04:30.