本机无法访问 mysql，远程可以访问

案例：本机无法访问 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>