下面小編就為大家帶來一篇完美解決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.168.1.25|?slave?|?*EE52B8EACB3CCD13624273AD6B5CDA52B9B53EB7?| |?192.168.1.%?|?tech_db_user?|?*6053E57C7B61043DC2C6B4E3291D5F61CCC23F5C?| |?192.168.1.%?|?game_db_user|?*05EA4D71C9A1273ECF3E24E6323F7175AE45C366?|? |?localhost?|?zabbix?|?*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9?| +---------------+---------------+------------------------------------------------------------+
問題:
在客戶機(比如192.168.1.20)上遠程連接上面192.168.1.152機器的mysql,連接失敗!
[root@huanqiu?~]#?mysql?-udb_ro_hqsb?-h?192.168.1.152?-pmhxzkhl0802xqsjdb ERROR?1130?(HY000):?Host?'192.168.1.20'?is?not?allowed?to?connect?to?this?MySQL?server
解決:
是由于192.168.1.152的mysql里“host為localhost,user和password為空”這條語句導致的,mysql這條即可解決問題!
mysql>? delete ?from?mysql.user?where?host="localhost"?and?user=""; Query?OK,?1?row?affected?(0.00?sec) mysql>? flush ?privileges; Query?OK,?0?rows?affected?(0.00?sec)
這樣,授權連接的客戶機就能成功連接了!
[root@huanqiu?~]#?mysql?-uxqsj_db_ro_user?-h?192.168.1.152?-pmhxzkhl0802xqsjdb Welcome?to?the?MySQL?monitor.?Commands?end?with?;?or?g. Your?MySQL?connection?id?is?28 Server?version:?5.1.73?Source?distribution Copyright?(c)?2000,?2013,?Oracle?and/or?its?affiliates.?All?rights?reserved. Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its affiliates.?Other?names?may?be?trademarks?of?their?respective owners. Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement. mysql>
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END