Resolving PHP mysqli_connect() Connection Refused Error: Port Configuration in MAMP Environment

Problem Background and Error Analysis

When using the mysqli extension to connect to MySQL databases in PHP development environments, developers often encounter the mysqli_connect(): (HY000/2002): Connection refused error. This error indicates that PHP cannot establish a TCP connection to the MySQL server, typically due to network connectivity issues or improper server configuration.

Special Configuration in MAMP Environment

MAMP (Macintosh, Apache, MySQL, PHP), as an integrated development environment for macOS, uses port 8889 as the default for MySQL service, while PHP's mysqli extension expects to connect to the standard MySQL port 3306 by default. This port mismatch is the primary cause of connection refusal errors.

Solution 1: Modify MAMP MySQL Port

The most straightforward solution is to modify MAMP's MySQL port to the standard port:

1. Open the MAMP application
2. Navigate to Preferences
3. Select the Ports tab
4. Change MySQL port from 8889 to 3306
5. Restart the MySQL server to apply changes

After modification, standard connection parameters can be used:

<?php
$servername = "localhost";
$username = "root";
$password = "root";

$conn = mysqli_connect($servername, $username, $password);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

Solution 2: Specify Port in Connection Parameters

If you prefer to maintain MAMP's default port configuration, explicitly specify the port in the connection string:

<?php
$servername = "127.0.0.1:8889";
$username = "root";
$password = "root";

$conn = mysqli_connect($servername, $username, $password);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

Understanding Connection Parameters

The mysqli_connect() function supports various connection parameter formats:

• localhost: Uses Unix socket connection
• 127.0.0.1: Uses TCP/IP connection with default port 3306
• 127.0.0.1:8889: Uses TCP/IP connection with specified port 8889

Related Case Analysis and Extensions

The referenced article about similar issues after Ubuntu system upgrades reminds us to maintain consistency in database connection configurations during environment changes. Even on the same server, different virtual hosts or applications may exhibit varying connection behaviors due to network policies, firewall rules, or security mechanisms like fail2ban.

Best Practice Recommendations

To avoid similar connection issues, it's recommended to:

1. Use standard port configurations consistently in development environments
2. Manage database connection parameters using environment variables in production
3. Implement connection retry mechanisms for temporary network issues
4. Regularly check server logs to identify potential network or security policy problems

Troubleshooting Steps

When encountering connection refused errors, follow these troubleshooting steps:

1. Verify that MySQL service is running
2. Check firewall settings for database port blocking
3. Validate connection parameters (hostname, port, username, password)
4. Test direct database connection from command line
5. Examine system logs and database error logs

Through systematic analysis and proper configuration adjustments, PHP mysqli_connect() connection refused issues can be effectively resolved, ensuring normal communication between applications and databases.