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!