Error Access denied for user MySQL server?
Error ERROR [HY000] [MySQL][ODBC 5.1 Driver]Acces开发者_如何学运维s denied for user (using password: YES) ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user (using password: YES)
Must be the semicolon in the password
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.
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>');
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;
精彩评论