Android Studio登录表单无法连接MySQL数据库，新手求助排查

Hey there! Let's walk through fixing this connection problem together—since you're new to programming, we'll break it down into simple, actionable steps to pinpoint where things are going wrong.

First: Diagnose the PHP Backend (Most Common Culprit) #

The generic error message doesn't tell us much, so let's tweak your PHP code to spit out specific database connection errors. This will immediately show if the issue is wrong credentials, a missing database, or an unreachable host.

Modify Your PHP Connection Code #

Replace your current error handling with something that outputs the actual MySQL error:

<?php
$servername = "localhost"; // If using an Android emulator, use 10.0.2.2 for local servers
$username = "your_db_username";
$password = "your_db_password";
$dbname = "your_db_name";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
    // Print exact error instead of generic message
    die("Connection failed: " . mysqli_connect_error());
}
?>

Then, open this PHP file directly in your browser (or use a tool like Postman). The output will tell you exactly what's broken—like "Access denied for user 'xxx'@'localhost'" or "Unknown database 'xxx'".

Critical Note for Local Testing #

If you're running PHP/MySQL on your computer and testing with an Android emulator:

• Replace localhost in your PHP connection URL with 10.0.2.2 (this is the emulator's way of pointing back to your computer's localhost).

Second: Check Android App Configuration #

Even if your PHP works, Android has a few gotchas that can block connections:

1. Allow Cleartext HTTP (Android 9+)
   If your PHP server uses HTTP (not HTTPS), Android blocks plaintext requests by default. Add this to your AndroidManifest.xml inside the <application> tag:

   android:usesCleartextTraffic="true"
   

2. Verify Your Request URL
   Make sure the URL in your MainActivity points to the correct PHP file. For local testing, it should look like http://10.0.2.2/your_folder/login.php (not localhost).

3. Avoid Network Calls on the Main Thread
   Android won't let you run network requests on the main UI thread—this causes silent failures or exceptions. Ensure you're using AsyncTask, Kotlin Coroutines, or a library like OkHttp to handle requests asynchronously.

Third: Server/MySQL Environment Checks (If Using Remote Hosting) #

If your PHP/MySQL is on a remote server:

• MySQL User Permissions: By default, MySQL users only allow connections from localhost. Grant access to your device's IP (or all IPs for testing) with:

  GRANT ALL PRIVILEGES ON your_db_name.* TO 'your_username'@'%' IDENTIFIED BY 'your_password';
  FLUSH PRIVILEGES;
  

• Firewall Settings: Ensure your server's firewall allows incoming connections on port 3306 (MySQL default) and the port your web server uses (usually 80/443).
• PHP Extensions: Confirm your server has the MySQL extension enabled (either mysqli or PDO_MySQL—most hosts enable this by default, but it's worth checking).

Fourth: Use Your Event Log Screenshot #

Look for specific errors in the log like:

• IOException: Indicates the app can't reach the PHP server (check URL, network permissions, or server availability).
• HTTP 500 Error: Means the PHP script crashed—go back to testing the PHP file directly in your browser for the exact error.
• NetworkOnMainThreadException: You're running the network call on the main thread—fix this with async code.

Pro Tip for Beginners #

Always test your PHP backend first before touching the Android code. If the PHP file works in a browser, you know the issue is in the Android app. If it doesn't, focus on fixing the database connection in PHP.

内容的提问来源于stack exchange，提问作者jerald furigay