How to Fix This MySQL Error in PHP?

Troubleshooting "No connection could be made because the target machine actively refused it" Error

When attempting to connect to a remote MySQL database in PHP, you may encounter the following error:

No connection could be made because the target machine actively
refused it.

This issue arises when the MySQL server is configured to only accept connections from localhost or specific IP addresses. To resolve this, you need to modify the MySQL configuration file and adjust the binding address.

Solution:

1. Edit your MySQL configuration file. On Ubuntu, this file is typically located at /etc/mysql/my.cnf.
2. Uncomment and modify the bind-address setting. Change the value of bind-address to 0.0.0.0. This will allow the MySQL server to accept connections from any IP address.
3. Comment out skip-networking. Locate the skip-networking setting and comment it out by adding a # before the line.
4. Restart MySQL. Once you have made these changes, restart the MySQL service to apply them.

Warning:

By opening up the MySQL server to connections from any IP address, it becomes accessible to the public Internet. Ensure that your database is adequately protected with strong passwords and security measures to prevent unauthorized access.

The above is the detailed content of How to Fix This MySQL Error in PHP?. For more information, please follow other related articles on the PHP Chinese website!