MySQL 1045: Access Denied Error Explained（mysql1045错误）
MySQL 1045: Access Denied error is an SQL error code that indicates that the database server has been denied access. It happens when a user attempts to log on to the MySQL database but fails to provide the correct credentials, such as username and password.
The error message 1045: Access Denied for user ‘username’@’localhost’ is confusing to many, because the user is not explicit and the localhost being used could be a range of different IP addresses and domains. This error is sometimes caused by user input errors, but can also be from the database itself making an incorrect user-assignment.
To successfully logon, MySQL requires a username, password, and optionally a hostname. The hostname specifies the IP address assiciated with the user account. Users typically receive this error when the database is setup to allow connections only from certain IP addresses. For example:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'192.168.1.100'
The error can be fixed by either changing the user’s credentials or by granting the user permission to access the database via their current credentials.
Changing the user’s password can be done with the following command:
SET PASSWORD FOR 'username'@'localhost' = PASSWORD("new_password");
To grant the user access, the user’s host must be specified in the grant command or use the wildcard character “%” instead of a particular IP address to allow access from any IP address.
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'
The command will grant the user “username” access to the database from any IP address. If a user’s host changes frequently the wildcard is the best option. However, please note that allowing access from any IP address can be a security risk.
MySQL 1045: Access Denied error is a common SQL error encountered by users new to databases. It indicates that the user has not provided the correct credentials or has not been given permission to access the database. The error can be solved by changing the user’s password or granting them access to the database via the correct IP address.
