MacBook Pro（Big Sur系统）下XAMPP环境PHP连接MySQL失败问题求助

Hey there, let's work through this MySQL connection issue you're facing on your Big Sur MacBook Pro with XAMPP. I've run into similar snags before, so here are actionable steps to get your PHP script connected successfully:

Common Troubleshooting Steps #

• Verify MySQL is Running in XAMPP
  First things first: open your XAMPP Control Panel and make sure the MySQL module shows a Running status. If it's stopped, click the Start button to fire it up. Sometimes the service can crash unexpectedly, so a quick restart might fix it.

• Double-Check Your Root Password
  XAMPP's default MySQL root password is often an empty string ("") rather than "password". Try updating your code's $password variable to "" first. If you set a custom password during XAMPP installation, confirm it by accessing phpMyAdmin (click the Admin button next to MySQL in XAMPP) and checking the root user's credentials under the "User accounts" tab.

• Resolve Port Conflicts
  Big Sur might have other services (like a pre-installed MySQL instance or another database tool) using port 3306. To check:
  Open Terminal and run this command:

  sudo lsof -i :3306
  

  If another process is using the port, you can either stop that process or change XAMPP's MySQL port (in XAMPP Control Panel > MySQL > Config > my.cnf, update the port to 3307, then restart MySQL and adjust your PHP script's $port value to match).

• Use 127.0.0.1 Instead of localhost
  On some macOS setups, localhost can have DNS resolution quirks. Try replacing $host = "localhost" with $host = "127.0.0.1" in your PHP code—this often bypasses local hostname issues.

• Ensure the mysqli Extension is Enabled
  Open your XAMPP php.ini file (go to XAMPP Control Panel > Apache > Config > php.ini), search for extension=mysqli, and make sure the line isn't commented out (remove the leading ; if present). Save the file and restart Apache to apply the change.

Updated PHP Script with Better Error Reporting #

To get clearer error details instead of just "Error", use this modified script—it will show the exact connection issue:

<?php
$username = "root";
$password = ""; // Replace with your actual root password
$host = "127.0.0.1";
$database = "mydb";
$port = "3306";

$conn = new mysqli($host, $username, $password, $database, $port);

// Check for connection errors
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected Successfully";
var_dump($conn);
?>

Give these steps a try, and if you still run into issues, share the specific error message from the updated script—that will help narrow things down further!

内容的提问来源于stack exchange，提问作者Jalana Kannangara