Solution to MySQL encounters 'Access denied for user' problem

How to solve the MySQL "Access denied for user" error: 1. Check the user's permission to connect to the database; 2. Reset the password; 3. Allow remote connections; 4. Refresh permissions; 5. Check the database server configuration (bind-address, skip-grant-tables); 6. Check the firewall rules; 7. Restart the MySQL service. Tip: Make changes after backing up the database.

How to solve the problem of "Access denied for user" in MySQL

question:

How to solve it when encountering MySQL "Access denied for user" error?

Solution:

1. Check user permissions

• Confirm the name of the database to be connected.
• Check whether the user has permission to connect to the database. You can view it by executing the following query: SHOW GRANTS FOR 'username';

2. Reset password

• If you forget your password, you can reset it using the ALTER USER command. For example: ALTER USER 'username' IDENTIFIED BY 'newPassword';

3. Allow remote connections

• If you are trying to connect from a remote computer, make sure that the user is granted GRANT ... ON *.* TO 'username'@'remote_host' IDENTIFIED BY 'password'; permissions.

4. Refresh permissions

• After making any permission changes, refresh the permissions using the following command: FLUSH PRIVILEGES;

5. Check the database server configuration

• Make sure the MySQL server is correctly configured with the following:

  • bind-address : should be set to 0.0.0.0 to allow remote connections.
  • skip-grant-tables : should be set to OFF to enable permission checking.

6. Check the firewall rules

• Make sure that the firewall is not blocking connections to the MySQL server. Allow connection to the following ports:

  • 3306 (default)
  • 33060 (for SSL connection)

7. Restart MySQL service

• After any changes are made, restart the MySQL service to ensure the changes take effect.

hint:

• Be sure to back up your database before making any changes.
• If you are still experiencing problems, please check the MySQL manual or seek professional help.

The above is the detailed content of Solution to MySQL encounters 'Access denied for user' problem. For more information, please follow other related articles on the PHP Chinese website!