如何用PHP连接MySQL？代码写完后网站完全无法连接MySQL求助

Hey there, sorry to hear you're stuck getting your site connected to MySQL—let's break this down into actionable steps to get you back on track.

1. First, confirm MySQL is running and reachable #

• On Linux systems, check the service status with:

  systemctl status mysql
  

• On Windows, open the Services manager and verify the MySQL service is set to "Running".
• Test if the MySQL port (default 3306) is accessible from your web server:

  # Using telnet
  telnet your-db-host 3306
  # Or netcat (if available)
  nc -zv your-db-host 3306
  

  If this fails, either MySQL isn't listening on that port, a firewall is blocking traffic, or your DB host is incorrect.

2. Double-check your connection parameters in code #

Make sure every detail in your connection string matches exactly what's configured in MySQL:

• Host: Is it localhost, 127.0.0.1, or a remote IP? Note that localhost uses a Unix socket on Linux/macOS, while 127.0.0.1 uses TCP—these can behave differently.
• Port: Default is 3306, but if you changed it, ensure your code uses the right one.
• Username/Password: No typos, and if your password has special characters (like @, &, or !), make sure they're properly escaped in your code (e.g., URL-encoded if using a connection string).
• Database Name: Confirm the database you're trying to connect to actually exists in MySQL.

3. Verify database user permissions #

MySQL users are restricted by both username and the IP they connect from. Even if your credentials are right, the user might not have access from your web server's IP:

• Log into MySQL as an admin user and run this query to check existing permissions:

  SELECT user, host FROM mysql.user WHERE user = 'your-db-user';
  

• If your web server's IP isn't listed, grant access with:

  GRANT ALL PRIVILEGES ON your-database-name.* TO 'your-db-user'@'your-web-server-ip' IDENTIFIED BY 'your-password';
  FLUSH PRIVILEGES;
  

  For local connections, use 'your-db-user'@'localhost' or 'your-db-user'@'127.0.0.1' depending on how your code connects.

4. Dig into error logs for specifics #

Generic "can't connect" messages aren't enough—check the logs to get the real issue:

• Web server/application logs: Look for entries related to database connections (e.g., Apache's error.log, Nginx's error.log, or your app's own log files). These will often include MySQL's exact error message.
• MySQL error log: Located at /var/log/mysql/error.log (Linux) or in your MySQL installation directory (Windows). It might show why connections are being rejected (e.g., invalid credentials, max connections reached).

5. Test connection outside your code #

Rule out code-specific issues by testing a direct connection to MySQL from your web server:

mysql -h your-db-host -u your-db-user -p

If this works, the problem is in your code (e.g., incorrect parameter handling, missing drivers). If it fails, you know the issue is with MySQL configuration, permissions, or network access.

Once you get the specific error message from logs or the command-line test, you'll have a clear path to fix this. Feel free to share that error message if you need help interpreting it!

内容的提问来源于stack exchange，提问作者Jeremy-Aurly Dellsam