Home > Database > phpMyAdmin > body text

The computer cannot log in to the remote phpmyadmin

Release: 2019-12-24 16:53:08
Original
2431 people have browsed it

The computer cannot log in to the remote phpmyadmin

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
Copy after login

Enter the password and press Enter

2. Check the system user

> use mysql;
> select user, password, host from user; //查看现有用户,密码及允许连接的主机
Copy after login

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改成%即可。
Copy after login

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;
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template