1ï¼sqlyog客æ·ç«¯ï¼ç¨rootç¨æ·è¿ç¨é¾æ¥mysqlæ¶ï¼æ示â访é®è¢«æç»âï¼å¨ç½ä¸æç´¢äºä¸ä¸åå ã
åæ¥æ¯mysql没æææå
¶è¿ç¨é¾æ¥ï¼æä»¥ä½ åªè½å¨å®¢æ·ç«¯éé¢é¾æ¥ã
æä¹è§£å³å¢ï¼
å表æ°æ®
mysql> use mysql
mysql> select Host,User,Password from user ;
+---------------+---------+-------------------------------------------+
| Host | User | Password |
+---------------+---------+-------------------------------------------+
| localhost | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| www | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| 127.0.0.1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| ::1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
å建ä¸ä¸ªæ°ç¨æ·
æ ¼å¼ï¼grant æé on æ°æ®åºå.表å to ç¨æ·@ç»å½ä¸»æº identified by "ç¨æ·å¯ç ";
grant select,update,insert,delete on *.* to
[email protected] identified by "komiles1234";
æ§è¡å®ä¸é¢è¯å¥åï¼åæ§è¡
mysql> select Host,User,Password from user ;
+---------------+---------+-------------------------------------------+
| Host | User | Password |
+---------------+---------+-------------------------------------------+
| localhost | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| www | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| 127.0.0.1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| ::1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| 123.4.56.89 | komiles | *50663F1ECEAB844897BC272EC1AE7E83F442F649 |
+---------------+---------+-------------------------------------------+
æ¤æ¶ï¼å°±å¯ä»¥ç¨ä½ åæå建çç¨æ·è¿è¡è¿ç¨è®¿é®äºã
以ä¸æ¯è½¬è½½
http://www.cnblogs.com/smallstone/archive/2010/04/29/1723838.html2ãå®ç°è¿ç¨è¿æ¥(æææ³)
å°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)
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 192.168.1.12 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| % | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+--------------+------+-------------------------------------------+
3 rows in set (0.00 sec)
è¿æ ·æºå¨å°±å¯ä»¥ä»¥ç¨æ·årootå¯ç rootè¿ç¨è®¿é®è¯¥æºå¨ä¸çMySql.
3ãå®ç°è¿ç¨è¿æ¥ï¼æ¹è¡¨æ³ï¼
use mysql;
update user set host = '%' where user = 'root';
è¿æ ·å¨è¿ç«¯å°±å¯ä»¥éè¿rootç¨æ·è®¿é®Mysql.