如何将phpmyadmin连接到远程数据库

确保远程MySQL服务器启用远程访问，修改bind-address为0.0.0.0，创建允许从phpMyAdmin服务器IP登录的用户并授权，防火墙开放3306端口；2. 在phpMyAdmin服务器编辑config.inc.php文件，添加远程数据库IP和端口配置；3. 推荐通过SSH隧道或SSL/TLS加密连接以保障安全；4. 重启Web服务器并访问phpMyAdmin页面，使用远程MySQL账户登录测试连接，若失败则检查日志、网络连通性和权限设置。完成以上步骤即可安全实现phpMyAdmin连接远程数据库。

Connecting phpMyAdmin to a remote database is a common need when managing MySQL/MariaDB servers hosted on a different machine (like a VPS, cloud server, or another networked device). By default, phpMyAdmin runs locally and connects to a local database, but it can be configured to access a remote MySQL server. Here’s how to do it properly and securely.

✅ 1. Ensure Remote MySQL Access is Enabled

Before phpMyAdmin can connect, the remote MySQL server must allow external connections.

Steps on the remote MySQL server:

• Edit MySQL config file (usually /etc/mysql/mysql.conf.d/mysqld.cnf or /etc/my.cnf):

  

  # Change this line:
  bind-address = 127.0.0.1
  # To:
  bind-address = 0.0.0.0

  ⚠️ This allows MySQL to accept connections from any IP. Use with caution and secure via firewall.

• Restart MySQL:

  

  sudo systemctl restart mysql

• Create a user with remote access:

  CREATE USER 'pma_user'@'your_phpmyadmin_server_ip' IDENTIFIED BY 'strong_password';
  GRANT ALL PRIVILEGES ON *.* TO 'pma_user'@'your_phpmyadmin_server_ip';
  FLUSH PRIVILEGES;

  Replace your_phpmyadmin_server_ip with the actual IP of the server where phpMyAdmin is running. Use % for any host (less secure).

• Open port 3306 in the firewall (if applicable):

  sudo ufw allow from your_phpmyadmin_ip to any port 3306

✅ 2. Configure phpMyAdmin to Connect to Remote Server

Now, tell phpMyAdmin to connect to the remote MySQL host instead of localhost.

Edit phpMyAdmin’s configuration file:

On your phpMyAdmin server, open the config file:

sudo nano /etc/phpmyadmin/config.inc.php

Add the following block before any existing server blocks:

$i = 1;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'remote_mysql_server_ip';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Replace remote_mysql_server_ip with the actual IP or domain of your remote MySQL server.

• auth_type = 'cookie' lets you log in with MySQL credentials.
• You can have multiple server entries if needed.

? If you're using a custom setup (e.g., manual phpMyAdmin install), edit config.inc.php in the phpMyAdmin directory.

✅ 3. Secure the Connection (Highly Recommended)

Connecting over the internet without encryption exposes credentials and data.

Best practices:

• Use SSH tunneling (most secure):

  ssh -L 3307:localhost:3306 user@remote_mysql_server

  Then in phpMyAdmin config:

  $cfg['Servers'][$i]['host'] = '127.0.0.1';
  $cfg['Servers'][$i]['port'] = '3307';

  This routes MySQL traffic through an encrypted SSH tunnel.

• Use SSL/TLS: Configure MySQL to require SSL and set in phpMyAdmin:

  $cfg['Servers'][$i]['ssl'] = true;
  $cfg['Servers'][$i]['ssl_ca'] = '/path/to/ca-cert.pem';

• Avoid exposing port 3306 publicly. Use a firewall or VPN.

✅ 4. Test the Connection

• Restart your web server:

  sudo systemctl restart apache2
  # or
  sudo systemctl restart nginx

• Visit your phpMyAdmin URL (e.g., http://your-server/phpmyadmin)

• Log in with the remote MySQL user credentials you created.

• If login fails, check:

  • MySQL error log: /var/log/mysql/error.log
  • Network connectivity: telnet remote_ip 3306
  • User privileges and host permissions in MySQL

Summary

To connect phpMyAdmin to a remote database:

• ✅ Enable remote access on MySQL (bind-address, user privileges, firewall)
• ✅ Configure config.inc.php with remote host details
• ✅ Secure the connection (SSH tunnel or SSL)
• ✅ Test and troubleshoot as needed

It’s not hard, but security is critical — never leave MySQL open to the public internet without safeguards.

Basically, it’s about telling phpMyAdmin where to connect and making sure the remote database says “yes” to that connection — safely.

以上是如何将phpmyadmin连接到远程数据库的详细内容。更多信息请关注PHP中文网其他相关文章！