案例：本机无法访问 mysql，远程可以访问，修改过系统名字；
场景： tomcat 和 mysql 装载在同一台机器上，页面显示数据库连接不到，tomcat不在同一台计算机时候正常
[root@master0 ~]# mysql -ubbs -p
Enter password:
ERROR 1045 (28000): Access denied for user (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 identified by '000000';
//添加授权“localhost”
mysql> GRANT ALL PRIVILEGES on *.* to identified by '000000';
mysql> flush privileges;
mysql> select host, user from user where User = 'bbs';
+-----------+------+
| host | user |
+-----------+------+
| % | bbs |
| localhost | bbs |
| master0 | bbs |
+-----------+------+
//有了上面三个权限，相信不会出现ERROR 1045 这样的授权错误了
|
<TABLE style="BACKGROUND-COLOR: #824a8d" height=384 cellSpacing=0 cellPadding=0 width=760 border=0>
<TBODY>
<TR>
<TD><A href="" target=_blank><img height=122 alt="" src="" width=128></A></TD>
<TD><A href="" target=_blank><img height=122 alt="" src="" width=122></A></TD>
<TD><A href="" target=_blank><img height=122 alt="" src="" width=125></A></TD>
<TD><A href="" target=_blank><img height=122 alt="" src="" width=124></A></TD>
<TD><A href="" target=_blank><img height=122 alt="" src="" width=123></A></TD>
<TD><A href="" target=_blank><img height=122 alt="" src="" width=128></A></TD></TR>
<TR>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=128></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=122></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=125></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=124></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=123></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=128></A></TD></TR>
<TR>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=128></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=122></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=125></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=124></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="http://img03.taobaocdn.com/bao/uploaded/i3/T1Y0VBXg0dXXcuW_QW_024740.jpg_160x160.jpg" width=123></A></TD>
<TD><A href="" target=_blank><img height=121 alt="" src="" width=128></A></TD></TR></TBODY></TABLE>
|
阅读(3828) | 评论(0) | 转发(0) |
