phpMyAdmin教程

安装

CentOS 6.4安装phpMyAdmin

Ubuntu安装

1
2
3
4
# apache
sudo apt-get install phpmyadmin apache2-utils
## vim /etc/apache2/apache2.conf,添加如下一行
Include /etc/phpmyadmin/apache.conf

连接多个主机的配置

参考文章
配置如下:

  1. 将phpMyAdmin根目录下的config.sample.inc.php,重命名为config.inc.php
  2. 修改config.inc.php文件,添加如下内容:

    $connect_hosts = array(
        1 => array(
            "host"    => "127.0.0.1",
            "port"    => "3307",
            "socket"=> "/tmp/mysql.sock2",
            "user"    => "root",
            "password"    => "mysql",
            "connect_type"    => "socket"
            ),
        2 => array(
            "host"    => "127.0.0.1",
            "port"    => "3309",
            "user"    => "root",
            "password"    => "mysql",
            "connect_type"    => "tcp"
            )
        );
    
    for ($i=1;$i<=count($connect_hosts);$i++){  
        $cfg['Servers'][$i]['auth_type'] = 'cookie';  
        $cfg['Servers'][$i]['host'] = $connect_hosts[$i]['host'];   //修改host  
        $cfg['Servers'][$i]['connect_type'] = $conenct_hosts[$i]['connect_type'];  
        $cfg['Servers'][$i]['port'] = $connect_hosts[$i]['port'];
        if (array_key_exists('socket', $connect_hosts[$i])){
        $cfg['Servers'][$i]['socket'] = $conenct_hosts[$i]['socket'];
        }
        $cfg['Servers'][$i]['compress'] = false;  
        $cfg['Servers'][$i]['extension'] = 'mysql';  
        $cfg['Servers'][$i]['AllowNoPassword'] = true;  
        $cfg['Servers'][$i]['user'] = $connect_hosts[$i]['user'];  //修改用户名  
        $cfg['Servers'][$i]['password'] = $connect_hosts[$i]['password']; //密码  
        $cfg['Servers'][$i]['bs_garbage_threshold'] = 50;  
        $cfg['Servers'][$i]['bs_repository_threshold'] = '32M';  
        $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;  
        $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';  
    }
    
  3. 重启apache

TroubleShooting

  • 如果出现#2002 无法登录 MySQL 服务器错误,可能是地址填写的是localhost而不是127.0.0.1所致
haofly wechat
欢迎您扫一扫上面的微信公众号,订阅我的博客!
坚持原创技术分享,您的支持将鼓励我继续创作!