Magento Error: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

Magento Error: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

August 18, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Error: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

Solving the “SQLSTATE[HY000] [2002] No connection could be made” Error in Magento

If you’re facing the “No connection could be made because the target machine actively refused it” error after changing your MySQL port, don’t panic! This issue is quite common when modifying database configurations. Let’s step through a systematic approach to resolve this problem.

Understanding the Error Message

The error message is quite descriptive:

SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

This means that Magento is trying to connect to your MySQL server, but the server is not listening on the port 3307 you specified. The “actively refused” part indicates that the server is running and accepting connections, just not on this particular port.

Step-by-Step Solution

Verify Your Changes

First, double-check that you’ve actually updated the database_port value in your Magento configuration file (app/etc/local.xml). It should look something like this:

<db>
  <table_prefix></table_prefix>
  <connection>
    <host><![CDATA[127.0.0.1]]></host>
    <username><![CDATA[root]]></username>
    <password><![CDATA[your_password]]></password>
    <dbname><![CDATA[magento_db]]></dbname>
    <act_as_default>1</act_as_default>
    <port><![CDATA[3307]]></port>
  </connection>
</db>

Check MySQL Port

Open a new terminal and run the following command to see which ports your MySQL server is listening on:

sudo netstat -tuln | grep mysql

Look for an entry similar to tcp6 0 0 :::3307 :::* LISTEN if your server is indeed running on port 3307.

Restart Services

If the port is listed, try restarting both Apache and MySQL:

sudo service apache2 restart
sudo service mysql restart

Sometimes, the services might not have updated their configurations immediately after you changed them.

Flush Magento Cache

Magento has a cache layer that can sometimes cause issues like this. Try flushing the cache to ensure it’s using the correct database configuration:

php -f shell/index.php -- --env=default set:cache:flush

Replace shell/index.php with the actual path if needed.

Best Practices for Database Configuration

As a best practice, always make sure you’re backing up your database before making any changes to the configuration. You can use the command-line client or a GUI tool like phpMyAdmin for this purpose.

Also, consider using environment-specific configurations (app/etc/local.xml.dist for local development and app/etc/production.xml for live environments) to keep your sensitive data secure.

Conclusion

Resolving the “No connection could be made because the target machine actively refused it” error in Magento involves a few simple yet crucial steps. Always ensure that you verify your changes, check if your server is listening on the correct port, restart the relevant services, and flush the cache to clear any stale data.

If you’re still facing issues after following these steps, consider reaching out to Laravel Company, where our expert team can provide personalized assistance.

Database Configuration Errors

Our network