我正在尝试将PhpMyAdmin的XAMPP安装连接到我的AWS RDS实例。我对config.inc.php进行了以下配置:
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'admin';
$cfg['Servers'][$i]['password'] = '*****';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '*******.us-east-2.rds.amazonaws.com';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;一切都很好,因为PhpMyAdmin从下拉列表中选择了它。但当我选择连接时,它将永远花费时间,并最终给出以下错误(我已经检查了安全grps,它允许所有流量。有没有办法验证我的登录和安全组):
MySQL said: Documentation
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/2002): Connection timed out
Connection for controluser as defined in your configuration failed.
mysqli::real_connect(): (HY000/2002): Connection timed out
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.发布于 2020-05-12 05:08:52
在将我的桌面IP的新规则添加到RDS实例后,这是有效的。本视频将指导您完成故障排除步骤:
youtube.com/watch?v=PxFZt8MG2ss
https://stackoverflow.com/questions/61736751
复制相似问题