各项设置设置正确,就是出现这种原因!
1.config.inc.php解决办法:
- 修改phpMyAdmin的配置文件里的密码设置,进入phpMyAdmin的安装目录,找到config.inc.php配置文件
- 修改$cfg[‘Servers’][$i][‘password’]=’你的密码'.
- 保存退出,重启MYSQL服务,再次找开phpMyAdmin
2.mysql服务器解决方案:
- # cd /usr/local/mysql/bin
- # mysql -uroot -p
- # use mysql
- # update user set host ='%' where user ='root' and host='127.0.0.1';
- # flush privileges;
3.phpmyadmin解决方案:
- 首先你的服务器要先配置phpmyadmin;步骤如下:
- 1:登陆phpmyadmin;
- 2:选择mysql数据库,user表;
- 3.直接执行sql语句;
- update user set host ='%' where user ='root' and host='127.0.0.1';
- flush privileges;
4.重启mysql解决方案: