mysql怎么使用phpadmin客户端,如何使用本地phpMyAdmin客户端访问远程服务器?

Assuming there is a remote server and I have phpMyAdmin client installed localy on my computer. How can I access this server and manage it via phpMyAdmin client? Is that possible?

解决方案

Just add below lines to your /etc/phpmyadmin/config.inc.php file in the bottom:

$i++;

$cfg['Servers'][$i]['host'] = 'HostName:port'; //provide hostname and port if other than default

$cfg['Servers'][$i]['user'] = 'userName'; //user name for your remote server

$cfg['Servers'][$i]['password'] = 'Password'; //password

$cfg['Servers'][$i]['auth_type'] = 'config'; // keep it as config

. You will get “Current Server:” drop down with both “127.0.0.1” and one what you have provided with “$cfg['Servers'][$i]['host']” cam switch between the servers.