Ò»£ºÊ×ÏÈÈ·ÈÏ3306Ô¶³Ì¶Ë¿Ú¿ªÆô¡£
¶þ£ºmysqlĬÈϲ»Ö§³ÖÔ¶Á¬.±ØÐëÉèÖá£
ÈçÏÂ:
rootȨÏÞ½øÈë
mysql -u root -p ÃÜÂë
use mysql;
update db set host = '%' where user = 'Óû§Ãû';
FLUSH PRIVILEGES;
Í˳ö.È»ºóÖØÆômysql. ÉÏÃæµÄÄǸöÓû§¼´¿ÉÔ¶Á¬ÄãµÄmysqlÁË.
¼ÇµÃΪÁ˰²È«Ò»¶¨ÒªÓиöwhereÌõ¼þ¡£
Èý£ºhost:%±íʾÄãµÄÊý¾Ý¿â½ÓÊÜÈκÎÒ»¸öIPµÄ·ÃÎÊ£¬¶øÈç¹ûÃ÷È··ÃÎÊ·½»úÆ÷µÄIP£¬¿ÉÒÔÉèÖÃhost:·ÃÎÊ·½IP£¬ËùÒÔÔÚÍøÂçÎïÀíÁ¬½ÓµÄǰÌáÏ£¬ÏÞÖÆÊÇ·ñÄÜÁ¬½Óµ½ÄãµÄÊý¾Ý¿â¸úÄã×ÔÉíµÄIPµØÖ·Î޹ء£