æ¹æ³/æ¥éª¤
é¦å
çæ¥éçªå£ã
ç»æ¥é
ï¼é误åå æ¯ï¼æ¬å°IPï¼xxx.xxx.xxx.xxxï¼æ²¡æ访é®è¿ç¨æ°æ®åºçæéã
äºæ¯ä¸é¢å¼å¯æ¬å°IPï¼xxx.xxx.xxx.xxxï¼å¯¹è¿ç¨mysqlæ°æ®åºç访é®æéã
é¦å
è¿ç¨è¿æ¥è¿å
¥æå¡å¨ï¼å¨cmsä¸è¾å
¥mysql -u root -pï¼ç¶åå车ï¼è¾å
¥å¯ç åå车è¿å
¥mysqlå½ä»¤è¡ã
è¾å
¥use mysql;
è¾å
¥select user,password,host from user;
å¯ä»¥çå°hostä¸åªælocalhost主æºãæ们éè¦å°xxx.xxx.xxx.xxxä¹æ·»å å°è¿éæ对ã
æ·»å æ¹æ³å¦ä¸ï¼
è¾å
¥
grant all privileges on *.* to root@"xxx.xxx.xxx.xxx" identified by "å¯ç ";
è¿ç¸å½äºæ¯ç»IP-xxx.xxx.xxx.xxxèµäºäºææçæéï¼å
æ¬è¿ç¨è®¿é®æéã
ç¶ååè¾å
¥
flush privileges;
è¿ç¸å½äºæ¯éæ°å è½½ä¸ä¸mysqlæéï¼è¿ä¸æ¥å¿
é¡»æã
å次è¾å
¥select user,password,host from user;
å¯ä»¥çå°hostä¸å·²ç»æäºæ°å çIPã
ç°å¨å次ç¨Navicat for MySQl访é®è¿ç¨mysqlæ°æ®åºï¼å·²ç»è½æ£å¸¸æå¼äºã
é®é¢è§£å³ã
ä¸è¿è¿æä¸ä¸ªé®é¢ï¼åç°åå»æå¼æå¼ è¡¨çæ¶åå¾æ
¢ï¼è³å°è¦3ç§ã
åå æ¯ï¼
å½è¿ç¨è®¿é®mysqlæ¶, mysqlä¼è§£æåå, æ以ä¼å¯¼è´è®¿é®é度å¾æ
¢, ä¼æ2,3ç§å»¶æ¶ï¼
解å³åæ³ï¼
ä¿®æ¹mysqlå®è£
ç®å½ä¸çmy.iniï¼å ä¸ä¸é¢è¿ä¸ªé
ç½®å¯è§£å³æ¤é®é¢ãå¨[mysqld]ä¸å å
¥ï¼skip-name-resolve
ä¿åéåºåéå¯mysqlæå¡ã
ç¶å访é®é度就åæ¬å°ä¸æ ·å¿«å¦ã
温馨提示:答案为网友推荐,仅供参考