Why Am I Getting an 'Access Denied' Error When Connecting to MySQL Remotely?

Remote MySQL Connection Issue with Access Denied Error

When attempting to establish a remote connection to a MySQL database, you may encounter an "Access denied" error (1045). This issue occurs when the user attempting to connect does not have the necessary privileges or the remote host is not authorized.

Troubleshooting Steps:

1. Check User Privileges: Ensure that the user trying to connect remotely has the appropriate privileges granted. By default, a user created on the local host ('localhost') does not have permission to access the database from a remote location. To grant access, execute the following command as the root user:

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD' with grant option;

Replace USERNAME with the user you intend to use for the connection, IP with the remote host's IP address or '%' to allow access from any IP, and PASSWORD with the password you want to set.

2. Restart MySQL Service: After modifying user privileges, restart the MySQL service to apply the changes.
3. Flush Privileges: Execute the following command to update the grant tables and ensure the changes take effect:

FLUSH PRIVILEGES;

Additional Considerations:

• Make sure the MySQL port (typically 3306) is open on the remote host's firewall.
• Verify that the MySQL configuration file (my.cnf) allows remote connections by setting the 'bind-address' parameter to '0.0.0.0' or the specific IP address of the remote host.

By following these steps, you should be able to successfully establish a remote connection to your MySQL database and resolve the "Access denied" error.

The above is the detailed content of Why Am I Getting an 'Access Denied' Error When Connecting to MySQL Remotely?. For more information, please follow other related articles on the PHP Chinese website!