案例:本机无法访问 mysql,远程可以访问,修改过系统名字;
场景: tomcat 和 mysql 装载在同一台机器上,页面显示数据库连接不到,tomcat不在同一台计算机时候正常
[root@master0 ~]# mysql -ubbs -p
Enter password:
ERROR 1045 (28000): Access denied for user 'bbs'@'localhost' (using password: YES)
数据库查看授权情况:
mysql> use mysql;
mysql> select host, user from user where User = 'bbs';
+---------+------+
| host | user |
+---------+------+
| % | bbs |
+---------+------+
//说明所有ip都可以访问;
//也就忽略了修改系统名字后的授权;
[root@master0 ~]# hostname
master0
//添加授权新"hostname”
mysql> GRANT ALL PRIVILEGES on *.* to 'bbs'@'master0' identified by '000000';
//添加授权“localhost”
mysql> GRANT ALL PRIVILEGES on *.* to 'bbs'@'localhost' identified by '000000';
mysql> flush privileges;
mysql> select host, user from user where User = 'bbs';
+-----------+------+
| host | user |
+-----------+------+
| % | bbs |
| localhost | bbs |
| master0 | bbs |
+-----------+------+
//有了上面三个权限,相信不会出现ERROR 1045 这样的授权错误了
完毕!
希望能给和我一样刚接触linux mysql的朋友一些帮助!!