You might see errors like:

• Access denied for user
• Could not connect to MySQL server
• Connection refused
• MySQL server has gone away

These errors usually happen because of:

❌ Wrong database credentials
❌ MySQL server not running
❌ Incorrect hostname
❌ Firewall issues

---

✅ Step 1: Check Database Credentials

Open your PHP config file (config.php or db.php) and verify:

$host = "localhost";
$user = "root";
$password = "";
$database = "test_db";

✔ Make sure:

• Database name is correct
• Username is correct
• Password is correct

💡 Tip: Check details in phpMyAdmin.

---

✅ Step 2: Make Sure MySQL Server is Running

For XAMPP / WAMP:

✔ Open control panel
✔ Start MySQL service

If MySQL is stopped → PHP will not connect.

---

✅ Step 3: Use Correct Hostname

Most of the time:

👉 Use localhost

But on some hosting servers:

👉 Use server IP or given hostname

Example:

$host = "127.0.0.1";

or

$host = "mysql.yourhost.com";

---

✅ Step 4: Fix “Access Denied” Error

Go to phpMyAdmin → User Accounts

✔ Check username permissions
✔ Allow ALL privileges

Then try again.

---

✅ Step 5: Check Firewall & Port

Default MySQL port:

👉 3306

Make sure it’s not blocked by firewall.

---

🚀 Bonus Tip (Professional Fix)

Use error handling in PHP:

$conn = mysqli_connect($host, $user, $password, $database);

if(!$conn){
    die("Connection Failed: " . mysqli_connect_error());
}

This helps you quickly understand the problem.

---

📌 Common Mistakes to Avoid

❌ Typing wrong database name
❌ Forgetting to start MySQL
❌ Using wrong password
❌ Changing config file accidentally

---

🎯 Final Thoughts

PHP MySQL connection errors are very common — but easy to fix if you follow these steps.

Once fixed properly, you will rarely face this issue again.

If you found this guide helpful, bookmark this page and share with other developers 😊

---

🏷 WordPress Tags (Copy Paste)

php mysql error
php database connection issue
fix mysql connection php
php error solution
xampp mysql error
wordpress database error
php coding tutorial
mysql not connecting php