mysql Ô¶³ÌÁ¬½Ó£¬Ô¶³ÌÁ¬½Ómysql×ÊÁÏ

Ô¶³ÌÁ¬½Ómysql×ÊÁÏ - Ó¦ÓÃÈí¼þ - µçÄԽ̳ÌÍø

Ô¶³ÌÁ¬½Ómysql×ÊÁÏ

ÈÕÆÚ£º2006-12-30   ¼ö£º

ÂèµÄ¡£¡£½ñÌìÏÂÎçæÁË°ëÌìҲû¸ã¶¨mysqlµÄÔ¶³ÌÁ¬½Ó¡£¡£ÓôÃÆ°¡¡£¡£

×îºó»Øµ½¼ÒÀïÉÏÍøÎÞÒâ¼û¿´µ½ÁËƪ±È½ÏÕýµãµÄ×ÊÁÏ¡£¡£

ºÇºÇ£¬£¬

ÎÊÌâ½â¾öÁË¡£¡£

Ã÷Ìì¸ã¶¨ftp·þÎñÆ÷¡£¡£¹þ¹þ

netstat -an | grep LISTEN ²é¿´¶Ë¿Ú

Ô¶³ÌÁ¬½Óµ½mysqlÐèÒª×öµÄ- -

1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";grant select,update,insert,delete on *.* to [email protected] identified by "xuys1234"; ²é¿´½á¹û£¬Ö´ÐУº use mysql; select host,user,password from user; ¿ÉÒÔ¿´µ½ÔÚuser±íÖÐÒÑÓиղŴ´½¨µÄxuysÓû§¡£host×ֶαíʾµÇ¼µÄÖ÷»ú£¬ÆäÖµ¿ÉÒÔÓÃIP£¬Ò²¿ÉÓÃ

Ö÷»úÃû£¬ ½«host×ֶεÄÖµ¸ÄΪ%¾Í±íʾÔÚÈκοͻ§¶Ë»úÆ÷ÉÏÄÜÒÔxuysÓû§µÇ¼µ½mysql·þÎñÆ÷£¬½¨ÒéÔÚ¿ª·¢Ê±

ÉèΪ%¡£ update user set host = '%' where user = 'xuys';

2¡¢ ./mysqladmin -uroot -ppwd reload./mysqladmin -uroot -ppwd shutdown

3¡¢./mysqld_safe --user=root &¼Çס£º¶ÔÊÚȨ±íµÄÈκÎÐ޸Ķ¼ÐèÒªÖØÐÂreload£¬¼´Ö´ÐеÚ3²½¡£

Èç¹û¾­¹ýÒÔÉÏ3¸ö²½Ö軹ÊÇÎÞ·¨´Ó¿Í»§¶ËÁ¬½Ó£¬ÇëÖ´ÐÐÒÔϲÙ×÷£¬ÔÚmysqlÊý¾Ý¿âµÄdb±íÖвåÈëÒ»Ìõ¼Ç¼

£ºuse mysql;insert into db

values('192.168.88.234','%','xuys','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');update db set host = '%' where user = 'xuys';Öظ´Ö´ÐÐÉÏÃæµÄµÚ2¡¢3²½¡£

±êÇ©£º