如何将Google Data Studio连接至本地MySQL Server？连接报错求助

Hey there! Let's break down the common configuration gaps that often cause this exact problem—since you can access MySQL via Workbench just fine, the issue is almost certainly related to how Data Studio (now rebranded as Looker Studio) interacts with your local database as a cloud-based service. Here are the key checks to run:

• Your MySQL server isn't configured to accept remote connections
  Workbench connects via localhost/127.0.0.1 which uses the local socket, but Data Studio needs to connect over the public network.

  • Open your MySQL config file (my.cnf on Linux/macOS, my.ini on Windows) and look for the bind-address line. Change it from 127.0.0.1 to 0.0.0.0 (to allow connections from any IP) or your specific public IP.
  • Restart the MySQL service to apply the change.
  • Test this by trying to connect to your public IP via a MySQL client from another device/network.

• Firewall or router is blocking port 3306
  Your local firewall (Windows Defender Firewall, iptables, etc.) might only allow local processes like Workbench to access port 3306, while blocking external/cloud requests.

  • Add an inbound rule to your firewall that allows TCP traffic on port 3306. You can temporarily disable the firewall for a quick test (remember to re-enable it afterward).
  • If you're behind a router, you'll need to set up port forwarding: map your router's public port 3306 to your local machine's IP and port 3306.

• Your MySQL user lacks remote access permissions
  The user you're using for Workbench is likely only authorized to connect from localhost or 127.0.0.1. Data Studio's requests come from external IPs, so they get rejected.

  • Run these SQL commands in Workbench to grant remote access:

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

    (Replace your_database_name, your_username, and your_password with your actual details. The % allows connections from any IP—for better security, you can restrict it to Google's IP ranges if you want.)

• You're using localhost/127.0.0.1 in Data Studio's connection settings
  For Data Studio, localhost refers to Google's cloud servers, not your local machine. You need to use your public IP address (or a dynamic DNS service if your IP changes regularly) instead.

  • Grab your public IP by searching "what's my IP" in your browser, then paste that into the "Host" field in Data Studio's connection setup.

• MySQL is running on a non-standard port
  If you changed MySQL's default port from 3306, make sure you explicitly specify that port in Data Studio's connection settings. Workbench might have saved the custom port, but Data Studio won't assume it.

Start with checking user permissions and port forwarding first—those are the most frequent culprits. If you're still stuck, try testing the connection with mysql -h your_public_ip -u your_username -p from a different network to rule out local network issues.

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