Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ô¶³ÌÁ¬½Ó MySQL l×ÊÁÏ zz


Ô¶³ÌÁ¬½Ómysql×ÊÁÏ
Ô¶³ÌÁ¬½Óµ½mysqlÐèÒª×öµÄ£º
1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 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²½¡£


Ïà¹ØÎĵµ£º

23±¾mysqlµç×ÓÊé


mastering Phpmyadmin

Beginning Php And Mysql³ÌÐòÉè¼Æ

Beginning PHP and MySQL from Novice to Professional 3rd Edition

Head First PHP MySQL

MySQLÈëÞ­µä

MySQL Stored Procedure Pr ......

Mysql³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......

CentOS LAMP»·¾³´î½¨ºÍ²âÊÔphpÓëmysqlµÄÁ¬½Ó


    * ÕªÒª£ºCentOS LAMP×÷Ϊ·þÎñÆ÷£¬²»°²×°²»ÐèÒªµÄ×é¼þ£¬ËùÒÔÔÚÑ¡Ôñ×é¼þµÄʱºò£¬²»ÒªÑ¡web·þÎñÆ÷£¬ÒòΪÎÒÃǺóÃæÒªÊÖ¶¯±àÒë°²×°¡£CentOS LAMPϵͳԼ¶¨RPM°üºÍÔ´Âë°ü´æ·ÅλÖÃ
    * ±êÇ©£ºCentOS LAMP
    *
      Oracle°ïÄú׼ȷ¶´²ì¸÷¸öÎïÁ÷ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ