1ãæ¹è¡¨æ³ã
å¯è½æ¯ä½ çå¸å·ä¸å
许ä»è¿ç¨ç»éï¼åªè½å¨localhostãè¿ä¸ªæ¶ååªè¦å¨localhostçé£å°çµèï¼ç»å
¥mysqlåï¼æ´æ¹ "mysql" æ°æ®åºéç "user" 表éç "host" 项ï¼ä»"localhost"æ¹ç§°"%"
ããmysql -u root -pvmwaremysql>use mysql;
ããmysql>update user set host = '%' where user = 'root';
ããmysql>select host, user from user;
ãã2ãæææ³ãä¾å¦ï¼ä½ æ³myuser使ç¨mypasswordä»ä»»ä½ä¸»æºè¿æ¥å°mysqlæå¡å¨çè¯ã
ããGRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WI
ããTH GRANT OPTION;
ããå¦æä½ æ³å
许ç¨æ·myuserä»ip为192.168.1.6ç主æºè¿æ¥å°mysqlæå¡å¨ï¼å¹¶ä½¿ç¨mypasswordä½ä¸ºå¯ç
ããGRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY
ãã'mypassword' WITH GRANT OPTION;
ããæç¨ç第ä¸ä¸ªæ¹æ³,åå¼å§åç°ä¸è¡,å¨ç½ä¸æ¥äºä¸ä¸,å°æ§è¡ä¸ä¸ªè¯å¥ mysql>FLUSH RIVILEGES
ãã使修æ¹çæï¼å°±å¯ä»¥äº
ããå¦å¤ä¸ç§æ¹æ³ï¼
ããå¨å®è£
mysqlçæºå¨ä¸è¿è¡ï¼
ãã1ãd:\mysql\bin\>mysql -h localhost -u root
ãã//è¿æ ·åºè¯¥å¯ä»¥è¿å
¥MySQLæå¡å¨
ãã2ãmysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION
ãã//èµäºä»»ä½ä¸»æºè®¿é®æ°æ®çæé
ãã3ãmysql>FLUSH PRIVILEGES
ãã//ä¿®æ¹çæ
ãã4ãmysql>EXIT
ãã//éåºMySQLæå¡å¨
ããè¿æ ·å°±å¯ä»¥å¨å
¶å®ä»»ä½ç主æºä¸ä»¥root身份ç»å½å¦ã
温馨提示:答案为网友推荐,仅供参考