The computer cannot log in to the remote phpmyadmin because phpmyadmin has not configured a remote connection. Let's take a look at how to check and change the remote connection configuration.
Check whether mysql has remote access enabled
1. Log in
mysql -h localhost -uroot -p
Enter the password and press Enter
2. Check the system user
> use mysql; > select user, password, host from user; //查看现有用户,密码及允许连接的主机
If mysql only allows local access, use the following command to set it to allow remote access.
> grant all privileges on *.* to 'root'@'210.168.1.100' identified by '' with grant option; //如果接具体的ip,则表示mysql只运行这个ip连接,若想所有的远程服务器都能够访问,则将ip改成%即可。
Check whether phpmyadmin has set remote synchronization parameters
If the remote server item cannot be operated, it means that phpmyadmin has not set remote synchronization parameters. The phpmyadmin synchronization function only has localhost by default and cannot be modified. Here you need to add a parameter in config.inc.php.
Edit/setup/frames/config.inc.php
Add a parameter:
/* allowarbitraryserver */ $cfg['allowarbitraryserver'] = true;
PHP Chinese website, there are a large number of free phpmyadmin introductory tutorials, welcome everyone to learn!
The above is the detailed content of The computer cannot log in to the remote phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!