ERROR1044 (42000): Accessdeniedforuser & #39; axt &

Environment: MySQLSever5.1MySQL command line tool problem: MySQL users encounter this problem after remotely logging on to the database: ERROR1045 (28000): Accessdeniedforuseraxt @ localhost (usingpassword: YES ). Solution: permission issues. Re-authorize, flush and restart the MySQL service. You can also use Navicatfo

Environment: MySQL Sever 5.1 MySQL command line tool problem: MySQL users encounter this problem after remotely logging on to the database: ERROR 1045 (28000 ): access denied for user 'axt' @ 'localhost' (usingpassword: YES ). Solution: permission issues. Re-authorize, flush and restart the MySQL service. You can also use Navicat fo

Environment: MySQL Sever 5.1 + MySQL command line tool

Problem: MySQL users encounter this problem after remotely logging on to the database: ERROR 1045 (28000): Access denied for user 'axt' @ 'localhost' (usingpassword: YES ).

Solution: permission issues. Re-authorize, flush and restart the MySQL service.

You can also use Navicat for MySQL user management solution (Database ------> right-click ------> manage user -------> grant user permissions ).

References:

Access denied for user ''@ 'localhost'

ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'mysql'

ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'db'

Database Connection: ERROR 1045 (28000): Access denied for user (using password: YES)