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

ÊÖ¶¯´´½¨MYSQLÓû§ÃûºÍÃÜÂë

·¢²¼Ê±¼ä:2007-11-13 00:01:08À´Ô´:ºìÁª×÷Õß:Nesoikps
ÔÚÍøÉϲéÁ˺ܶà×ÊÁÏ£¬»ù±¾ÉÏÃ»Ê²Ã´È«ÃæµÄ£¬ºÇºÇ£¬²ËÄñ¿´µÃÓеãÍ·ÔΣ¬È«ÊÇ´úÂ룬ËùÒÔÏëдһ¸ö×ܽ᣺

µÚÒ»²½£º¿ªÊ¼£¬ÔËÐУ¬ÊäÈëCMDÈ·ÈÏ£¬È»ºóÊäÈëc:\mysql\bin\mysql -uroot -p,ǰÌáÄãµÄMYSQLÊǰ²×°ÔÚCÅÌ·¾¶£¬½øÈ¥ºó»áÌáʾÄãÊäÈëÄãµÄROOTÃÜÂ룬½øÈ¥ºó»áÓл¶Ó­Ìáʾ£¬ÉÏÃæÓÐMYSQL°æ±¾ºÅÏÔʾ

µÚ¶þ²½£º½ÓÉÏÒ»²½£¬ÎÒÃÇÊäÈ룺grant all on *.* to dbuser@"%" identified by '123456';

¾ÙÀý£¬ÎÒÃǵĴ´½¨ÐµÄÓû§ÊÇdbuser£¬ÃÜÂëÉèΪ123456£¬ÔÚÕâÀïÌØ±ð×¢Òâһϣ¬¼ÇµÃÊäºóÃæµÄ·ÖºÅ;ÒÔ¼°¸÷´úÂëÖ®¼ä¿Õ¸ñ£¬Òâ˼ÊÇÌáʾÕâ¸öÓï·¨½áÊø£¬¾ÍºÃ±ÈÎÒÃÇд×÷ÎĵÄʱºòÒª·ÖÐзֶΣ¬Õâµã¶Ô²ËÄñÓû§ºÜÖØÒª£¡³É¹¦´´½¨ºó»áÌáʾ£ºQuery OK, 0 rows affected (0.03 sec)

µÚÈý²½£ºÈ»ºóÊäÈëmysql> exit Í˳ö£¬»áÌáʾ£ºBye

µÚËIJ½£º»¹ÔÚCMD´°¿ÚÕâ¸öʱºòÊäÈëc:\mysql\bin\mysql -h 192.168.0.1 -u dbuser -p123456

×¢Òâ,Ò»¶¨Òª°Ñ192.168.0.1Ìæ»»³ÉÄãµÄ·þÎñÆ÷IP£¬ÉÏÃæ·Ö¸ñÒ²Óн²¾¿£¡²»ÒªÊä´íÁË£¡°´È·ÈϺ󣬻áÏÔʾ»¶Ó­ÐÅÏ¢µÄ£¡

µÚÎå²½£º½ÓÉϲ½£¬ÏÖÔÚÎÒÃÇÊÇ´´½¨Êý¾Ý¿âÃû£¬ÃüÁîÊÇ£ºcreate database dbuser;
±ÈÈçÊý¾Ý¿âÃûΪdbuser£¬¼ÇµÃÊäÈëºóÃæµÄ·ÖºÅ£¬È»ºóÈ·ÈÏ£¬ÕâÑùÎÒÃǵÄÊý¾Ý¿âÃû¾Í´´½¨³É¹¦ÁË£¡

ͨ¹ýÉÏÃæ¼¸²½£¬ÎÒÃǾ͵õ½ÁËÊý¾Ý¿âÓû§ÃûdbuserÃÜÂë123456Êý¾Ý¿âÃûdbuser£¬ÕâÑùÎÒÃÇÔÚ°²×°PHPÂÛ̳µÄʱºòÊäÈëÕâЩÐÅÏ¢¾Í¿ÉÒÔ°²×°³É¹¦ÁË£¡
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ