安装phpmyadmin
wget https://files.phpmyadmin.net/phpMyAdmin/4.6 .6 /phpMyAdmin-4.6 .6 -all-languages.zip
unzip phpMyAdmin-4.6 .6 -all-languages.zip
sudo cp -R -p phpMyAdmin-4.6 .6 -all-languages /usr/share/phpmyadmin
sudo apt-get install phpmyadmin
查看phpmyadmin安装目录
$ whereis phpmyadmin
phpmyadmin: /etc/phpmyadmin /usr/share/phpmyadmin
方法一
修改/usr/share/phpmyadmin/libraries/config.default.php
$cfg ['AllowArbitraryServer' ] = true ;
方法二
复制/usr/share/phpmyadmin/config.sample.inc.php,命名为config.inc.php
$ cd /usr/share/phpmyadmin
$ sudo cp config.sample.inc.php config.inc.php
修改config.inc.php文件,在第一个Servers配置下加多一个数据库配置
$i ++;
$cfg ['Servers' ][$i ]['verbose' ] = 'tlwlmy' ;
$cfg ['Servers' ][$i ]['host' ] = '192.168.0.1' ;
$cfg ['Servers' ][$i ]['port' ] = '' ;
$cfg ['Servers' ][$i ]['socket' ] = '' ;
$cfg ['Servers' ][$i ]['connect_type' ] = 'tcp' ;
$cfg ['Servers' ][$i ]['extension' ] = 'mysqli' ;
$cfg ['Servers' ][$i ]['auth_type' ] = 'cookie' ;
$cfg ['Servers' ][$i ]['AllowNoPassword' ] = false ;
方法三
修改/etc/phpmyadmin/config.inc.php,在第一个Servers配置下加多一个数据库配置
$i ++;
$cfg ['Servers' ][$i ]['verbose' ] = 'tlwlmy' ;
$cfg ['Servers' ][$i ]['host' ] = '192.168.0.1' ;
$cfg ['Servers' ][$i ]['port' ] = '' ;
$cfg ['Servers' ][$i ]['socket' ] = '' ;
$cfg ['Servers' ][$i ]['connect_type' ] = 'tcp' ;
$cfg ['Servers' ][$i ]['extension' ] = 'mysqli' ;
$cfg ['Servers' ][$i ]['auth_type' ] = 'cookie' ;
$cfg ['Servers' ][$i ]['AllowNoPassword' ] = false ;
总结
使用第一种方法,需要自己填写host,切换数据库比较麻烦 第二种方法要使用官网下载安装包 第三种方法要使用apt-get安装,使用apt-get文件会在/etc/phpmyadmin下
参考