# cd /var/www/html
# tar zxvf phpMyAdmin-3.5.3-all-languages.tar.gz # 将其解压到当前目录下,生成一个名为phpMyAdmin-3.5.3-all-languages的文件夹
# mkdir phpMyAdmin3.5.3
# mv /var/www/html/phpMyAdmin-3.5.3-all-languages /var/www/html/phpMyAdmin3.5.3 # 移动该文件夹到phpMyAdmin3.5.3下
# cp /var/www/html/phpMyAdmin3.5.3/phpMyAdmin-3.5.3-all-languages/libraries/config.default.php /var/www/html/phpMyAdmin3.5.3/phpMyAdmin-3.5.3-all-languages/
# 并将config.default.php文件更名为:config.inc.php
# 用文本编辑器打开config.inc.php或者在shell用vi打开也可以(点击a进入编辑状态,esc退出)
$cfg['PmaAbsoluteUri'] = 'http://192.168.211.133/phpMyAdmin3.5.3';
$cfg['Servers'][$i]['host'] = 'localhost'; # 如果数据库服务器在本地,即设为loaclhost,如果在远程,设为远程的IP地址;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'mysql';
$cfg['Servers'][$i]['password'] = ''; # 如果有密码就添加进去
$cfg['Servers'][$i]['only_db'] = '';
$cfg['DefaultLang'] = 'zh';
在浏览器中输入:http://192.168.211.133/phpMyAdmin3.5.3/,前提是已经开启httpd服务。
数据库允许远程登录,需要执行:> grant all on *.* to 'username'@'%' identified by 'password' with grant option;