Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to check whether phpmyadmin has set remote synchronization parameters. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The computer cannot log on to the remote phpmyadmin because the phpmyadmin is not configured with a remote connection.

Check if remote access is enabled by mysql

1. Log in

Mysql-h localhost-uroot-p

Enter the password and enter enter

2. Check system users

> use mysql; > select user, password, host from user; / / View existing users, passwords and hosts allowed to connect

If mysql only allows local access, set it to allow remote access with the following command.

> grant all privileges on *. * to 'root'@'210.168.1.100' identified by' 'with grant option;// if connected to a specific ip, it means that mysql only runs this ip connection. If you want all remote servers to be accessible, change ip to%.

Check whether remote synchronization parameters are set for phpmyadmin

If the remote server entry is inoperable, phpmyadmin does not set remote synchronization parameters. The phpmyadmin synchronization feature is only localhost by default and cannot be modified. Here, you need to add a parameter to config.inc.php.

Edit / setup/frames/config.inc.php

Add a parameter:

/ * allowarbitraryserver * / $cfg ['allowarbitraryserver'] = true; this is the end of the article on "how to check whether remote synchronization parameters are set in phpmyadmin". I hope the above content can be helpful to you so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.