How to connect remotely using phpmyadmin

You need to use local PHPMYADMIN to connect to the remote MYSQL database. The following configuration is as follows: Open config.inc.php

1. Change the login verification method

Look for $cfg['Servers'][$i]['auth_type'], and change its value to cookie; (Recommended learning: phpmyadmin tutorial)

2. Change the phpmyadmin program URL, search for $cfg['PmaAbsoluteUri'], and change its value to your phpmyadmin URL similar to

http://www.aaa.com/phpmyadmin。

3. Change the default login For language, search for $cfg['DefaultLang'] and change its value to zh. Others do not need to be configured because cookies are used to log in and the permissions are directly compared with the database. It has nothing to do with these parameters in the configuration file.

Solution to unable to log in remotely

mysql>use mysql;
mysql>update user set host = '%'? where user ='root' and host='localhost';
//如果有两个用户root的话，就应该加上and host='localhost';
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
mysql>quit

The above is the detailed content of How to connect remotely using phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!