MySQLè¿ç¨è®¿é®æéï¼å
许è¿ç¨è¿æ¥çå¼å¯
1ãç»émysqlæ°æ®åº
mysql -u root -p
æ¥çuser表
www.2cto.com mysql> use mysql;
Database changed
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+-------------------------------------------+
| localhost | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
+--------------+------+-------------------------------------------+
2 rows in set (0.00 sec)
å¯ä»¥çå°å¨user表ä¸å·²å建çrootç¨æ·ãhostå段表示ç»å½ç主æºï¼å
¶å¼å¯ä»¥ç¨IPï¼ä¹å¯ç¨ä¸»æºåï¼
(1)ææ¶æ³ç¨æ¬å°IPç»å½ï¼é£ä¹å¯ä»¥å°ä»¥ä¸çHostå¼æ¹ä¸ºèªå·±çIpå³å¯ã
2ãå®ç°è¿ç¨è¿æ¥(æææ³)
å°hostå段çå¼æ¹ä¸º%就表示å¨ä»»ä½å®¢æ·ç«¯æºå¨ä¸è½ä»¥rootç¨æ·ç»å½å°mysqlæå¡å¨ï¼å»ºè®®å¨å¼åæ¶è®¾ä¸º%ã
update user set host = â%â where user = ârootâ;
å°æéæ¹ä¸ºALL PRIVILEGES
mysql> use mysql;
Database changed
mysql> grant all privileges on *.* to root@'%' identified by "root";
Query OK, 0 rows affected (0.00 sec)
www.2cto.com mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+-------------------------------------------+
| localhost | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| % | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
+--------------+------+-------------------------------------------+
3 rows in set (0.00 sec)
è¿æ ·æºå¨å°±å¯ä»¥ä»¥ç¨æ·årootå¯ç rootè¿ç¨è®¿é®è¯¥æºå¨ä¸çMySql.
3ãå®ç°è¿ç¨è¿æ¥ï¼æ¹è¡¨æ³ï¼
use mysql;
update user set host = '%' where user = 'root';
è¿æ ·å¨è¿ç«¯å°±å¯ä»¥éè¿rootç¨æ·è®¿é®Mysql.