CODEWITHSUNDEEP
c#-2.0
Shiva
Shiva

Reputation: 1

Error Access denied for user MySQL server?

Error ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user (using password: YES) ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user (using password: YES)

Upvotes: 0

Views: 2734

Answers (4)

a20
a20

Reputation: 5641

If nothing else works, it might be something you mistyped in the password etc. To fix, connect as root, and reset the database permissions, password and flush the privileges:

GRANT ALL PRIVILEGES
ON <database>.*
TO <user>@localhost IDENTIFIED BY '<password>';

SET PASSWORD
FOR <user>@localhost = PASSWORD('<password>');

Flush Priviliges;

Upvotes: 0

Dante Souto
Dante Souto

Reputation: 1

Try this: Connect your database using MySQL Workbench and try to run the following SQL statements:

GRANT ALL PRIVILEGES
    ON <database>.*
    TO '<user>'@'localhost' IDENTIFIED BY '<password>';
SET PASSWORD
    FOR <user>@localhost = PASSWORD('<password>');

Upvotes: 0

Alexander Taran
Alexander Taran

Reputation: 6725

Must be the semicolon in the password

Upvotes: 1

Art W
Art W

Reputation: 2038

Make sure that your MySql server allows remote connections. If not you'll have to bind the database and user to the remote IP(s) You also need to check the servers firewall settings to make sure 3306 (or whatever you're using) is allowed and that incoming connections are permitted.

Upvotes: 0

Related Questions