MySQL grantÊÚȨºóµÄÁ¬½ÓÎÊÌâ

Ô­À´ÎÒÓÃrootÓû§£¬ÃÜÂëÊÇabc,¿Í»§¶Ë¶¼Õý³£Á¬½Ó¡£
ºóÀ´ÎÒÖ´ÐÐÁË grant all  on *.* to root@'192.168.0.%'.Ö´Ðгɹ¦£¬¿Í»§¶ËÁ¬½Ó²»ÓÃÈκÎÃÜÂ붼¿ÉÒԳɹ¦Á¬½Ó£¬
µ«ÊÇÏÖÔÚÎÒÏë»Øµ½Ô­À´µÄÓÃÃÜÂëÁ¬½ÓµÄ·½Ê½£¬Ö´ÐÐ
grant all  on *.* to root@192.168.0.119 identified by '12345678';Ö´Ðб¨´í£º
Access denied for user 'root'@'192.168.0.119' (using password: YES)

ºÜÆæ¹Ö£¬ÇëÎÊË­ÖªµÀΪʲô£¿Ôõô»Ö¸´µ½ÐèÒªÃÜÂëÁ¬½Ó¡£

---

ÐÞ¸ÄÃÜÂëÄãÓÃһϵķ½·¨
update user set password=password('ÐÂÃÜÂë') where user ='root';
flush privileges;

²»¹ýÓÃgrant all¸ÄÃÜÂëÎÒ»¹´ÓÀ´Ã»Óùý£¬²»Ì«Çå³þÊÇʲôԭÀí

---

grant all  on *.* to root@'192.168.0.%'  Õâ¸ö²¢Ã»ÓÐgrant ȨÏÞ ËùÒÔ
grant all  on *.* to root@192.168.0.119 identified by '12345678';Ö´Ðб¨´í£º
Access denied for user 'root'@'192.168.0.119' (using password: YES) »á±¨´í£»

---

show grants ÌùһϽá¹û¿´Ò»Ï¡£

---

mysql> show grants;
+-------------------------------------------------------+
| Grants for root@192.168.0.119                        |
+-------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.119' |
+-------------------------------------------------------+
1 row in set (0.05 sec) <