Laravel 9本地连接Strato远程MySQL数据库失败问题排查求助

Let’s work through this issue step by step—first, let’s unpack the error you’re seeing, then tackle the most likely fixes.

First: Fix the Duplicate Port in MySQL Command #

Looking at the failed command:

'mysql' '--host=rdbms.strato.de:3306' '--port=3306'

You’re passing the port both in the host parameter and as a separate port flag, which can confuse the MySQL client. This is probably happening because your .env file or database.php has the host value formatted incorrectly.

Fix:

• In your .env file, make sure DB_HOST is just the hostname (no port):

  DB_HOST=rdbms.strato.de
  DB_PORT=3306
  

• Double-check that database.php isn’t hardcoding the port into the host value (your current config looks okay here, but confirm the .env is overriding it).

Second: Verify Strato’s IP Whitelist #

Strato’s remote MySQL servers block all external IPs by default—only their own servers are allowed to connect unless you explicitly whitelist your local public IP. This is the #1 reason folks hit connection issues with Strato DBs.

Fix:

1. Find your local public IP (search "what's my IP" in your browser).
2. Log into your Strato account, navigate to your database management panel.
3. Look for an option like "Allowed IPs" or "Access Restrictions" and add your public IP to the list.
4. Wait 5-10 minutes for the setting to take effect, then test the connection again.

Third: Correct the DATABASE_URL Configuration #

In your database.php, you have:

'url' => env('DATABASE_URL','rdbms.strato.de'),

The DATABASE_URL needs to follow the full MySQL connection string format if you’re using it—right now it’s just the hostname, which is invalid. Laravel prioritizes this URL over individual host/port/username/password settings, so this could be breaking things even if your other params are correct.

Fix:

• Either:
  1. Remove the default value from database.php and set the full URL in .env:

     DATABASE_URL=mysql://your_username:your_password@rdbms.strato.de:3306/DB4059576
     

  2. Or comment out the 'url' line in database.php entirely to rely on the individual connection parameters.

Fourth: Force SSL Connection (Strato Requires It) #

Strato’s remote MySQL requires SSL for external connections, but your current options array only sets PDO::MYSQL_ATTR_SSL_CA if the extension is loaded. You might need to explicitly enable SSL and disable certificate verification (if you don’t have Strato’s specific CA file handy).

Fix:
Update the options section in your mysql connection:

'options' => extension_loaded('pdo_mysql') ? array_filter([
    PDO::MYSQL_ATTR_SSL_ENABLE => true,
    PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false, // Temporary fix if you don't have the CA cert
    // If you can get Strato's CA cert, uncomment and set the path:
    // PDO::MYSQL_ATTR_SSL_CA => '/path/to/strato-ca.pem',
]) : [],

Fifth: Test Connection Outside Laravel #

Before debugging Laravel further, confirm you can connect directly to the Strato DB using the MySQL client. This will rule out network or credential issues.

Run this command in your terminal:

mysql -h rdbms.strato.de -P 3306 -u your_username -p

• If this fails with an access denied error: Double-check your username/password and IP whitelist.
• If it times out: Your local network might be blocking port 3306, or Strato’s server is unreachable (contact their support if needed).
• If it works: The problem is in your Laravel configuration—go back and recheck the steps above.

Sixth: Double-Check .env File #

Make sure your .env file has no typos, extra spaces, or unescaped special characters in your password. For example, if your password has # or $, you might need to wrap it in quotes:

DB_PASSWORD="your-password-with-special-chars"

内容的提问来源于stack exchange，提问作者Robin Schoenmaker