ºìÁªLinuxÃÅ»§
Linux°ïÖú

ÈÃmysqlÄܹ»Ô¶³ÌÁ¬½Ó

·¢²¼Ê±¼ä:2007-11-10 00:00:52À´Ô´:ºìÁª×÷Õß:Shader
Ò»£ºÊ×ÏÈÈ·ÈÏ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µØÖ·Î޹ء£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ