mysql授权后仍连接不上_详解mysql客户端授权后连接失败的问题的解决办法

下面小编就为大家带来一篇完美解决mysql客户端授权后连接失败的问题。小编觉得挺不错的，现在就分享给大家，也给大家做个参考。一起跟随小编过来看看吧

在本地(192.168.1.152)部署好mysql环境，授权远程客户机192.168.1.%连接本机的mysql，在iptables防火墙也已开通3306端口。

如下：mysql>

select host,user,passw

ord

from mysql.user;

+--------------+-----------------+---------------------------------------------------------+

| host | user | password |

+--------------+-----------------+----------------------------------------------------------+

| localhost | root | |

| fdm1 | root | |

| 127.0.0.1 | root | |

| localhost | | |

| fdm1 | | |

| 192.168.1.% | db_hqsb | *DFC9DC16B13651A95ECEC3A26E07D244431B55C9 |

| 192.168.1.% | db_ro_hqsb | *2C0B0DD50595BB40879110437BEEF026D019DFB7 |

| 192.168.1.% | db_jkhwuser | *2C0B0DD50595BB40879110437BEEF026D019DFB7 |

| 192.