Error Access denied for user MySQL server?

Question

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)

Could you please post more context for the question? as in what is the question and what is that you are trying to do etc — Mahesh Velaga
– Mahesh Velaga, Commented Mar 29, 2010 at 17:36

Alexander Taran · Accepted Answer · 2011-12-12 17:25:39Z

1

Must be the semicolon in the password

answered Dec 12, 2011 at 17:25

Alexander Taran

6,7252 gold badges42 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Art W · Accepted Answer · 2010-03-29 17:42:13Z

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.

dialogik · Accepted Answer · 2014-10-14 19:08:06Z

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>');

a20 · Accepted Answer · 2016-11-21 04:32:27Z

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;

Collectives™ on Stack Overflow

Error Access denied for user MySQL server?

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related