phpMyAdmin是一个简单实用的web图形化数据库管理工具，这里我们在将phpMyAdmin放在nginx上，也可以用apache。
IP地址：193.168.0.40
https://files.phpmyadmin.net/phpMyAdmin/3.4.3.2/phpMyAdmin-3.4.3.2-all-languages.tar.gz
[root@baculeServer ~]# tar xzf /root/phpMyAdmin-5.1.0-all-languages.tar.gz [root@baculeServer ~]# mv phpMyAdmin-5.1.0-all-languages.tar.gz /data/phpMyAdmin
[root@baculeServer ~]# cd /data/web/phpMyAdmin/ [root@baculeServer phpMyAdmin]# cp config.sample.inc.php config.inc.php [root@baculeServer phpMyAdmin]# vim config.inc.php $cfg[‘Servers‘][$i][‘host‘] = ‘localhost‘; #将这一行改成mysql的监听地址 $cfg[‘Servers‘][$i][‘host‘] = ‘193.168.0.40‘;
使用 “netstat -ntpl |grep mysql” 查看mysql监听地址，默认如果是 0.0.0.0:3306 ,上面文件地址就该成 127.0.0.1 。
用MySQL的root用户登录会出现#1045报错，是因为默认不允许root登录，毕竟实际生产中使用root存在安全隐患，这就要在mysql中创建一个管理用户，并授予他权限，当然也可以对root用户做登录放行。
mysql> CREATE DATABASE wordpress; Query OK, 1 row affected (0.00 sec) mysql> CREATE USER ‘wordpress‘@‘%‘ IDENTIFIED BY ‘123456‘; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO ‘wordpress‘@‘%‘; Query OK, 0 rows affected (0.00 sec) mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | | wordpress | +--------------------+ 5 rows in set (0.00 sec) mysql> SHOW GRANTS FOR ‘wordpress‘@‘%‘; +-------------------------------------------------------------------------------------------------------------------+ | Grants for wordpress@% | +-------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO ‘wordpress‘@‘%‘ IDENTIFIED BY PASSWORD ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9‘ | | GRANT ALL PRIVILEGES ON `wordpress`.* TO ‘wordpress‘@‘%‘ | +-------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> FLUSH PRIVILEGES;
Linux之Redhat6.5安装phpMyAdmin连接到后台数据库
原文：https://www.cnblogs.com/daoguanmao/p/mysql-phpmyadmin.html