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

¿ìËÙÖØÖÃMySQLÓû§ÃÜÂë

 
1¡¢Í£Ö¹ÕýÔÚÔËÐеÄMySQL½ø³Ì
    
LinuxÏÂ,ÔËÐÐ killall -TERM mysqld
     WindowsÏ£¬Èç¹ûд³É·þÎñµÄ¿ÉÒÔÔËÐУºnet stop mysql,Èçδ¼ÓÔØÎª·þÎñ£¬¿ÉÖ±½ÓÔÚÈÎÎñ¹Ü  ÀíÆ÷ÖнøÐйرա£
2¡¢ÒÔ°²È«Ä£Ê½Æô¶¯MySQL
    
LinuxÏ£¬ÔËÐÐ mysqld_safe --skip-grant-tables &
     WindowsÏ£¬ÔÚÃüÁîÐÐÏÂÔËÐÐ X:/MySQL/bin/mysqld-nt.exe --skip-grant-tables
3¡¢Íê³ÉÉÏÊöÁ½²½ÒÔºó¾Í¿ÉÒÔ²»ÓÃÃÜÂë½øÈëMySQLÁË
     LinuxÏ£¬ÔËÐÐ mysql -u root
½øÈë
     WindowsÏ£¬ÔËÐÐ X:/MySQL/bin/mysql -u root ½øÈë
4¡¢¸ü¸ÄÃÜÂë
     ʹÓÃÃüÁîÐÞ¸Ä:   
     mysqladmin -u root -p password NewPassword
    
     »òÕßʹÓà sql Ö±½ÓÐÞ¸ÄÓû§ÐÅÏ¢±í:
   
>use mysql;
¡¡ >select host, user, password from user;
    >update user set password=password("NewPassword") where user="root";
    >flush privileges;
×¢£±
: ±¾ÈËÔÚRED HAT LINUX SERVER 5 ÉϲÙ×÷MySQL 5.0.77°æ±¾³É¹¦£¨LINUX¹ÜÀíÔ±rootµÄÃÜÂëûÍü£º£©
±¾ÎÄÒý×Ô£ºhttp://www.macophp.com/?action=index&cid=3&page=2
£¬¸ù¾Ýʵ¼ÊÇé¿ö×öÁ˲¿·ÖÐ޸ġ£


Ïà¹ØÎĵµ£º

ÐÞ¸ÄmysqlÃÜÂëµÄ·½·¨

use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
MYSQLADMIN -u root -p PASSWORD mypasswd
3.¿ÉÒÔÐÞ¸ÄMYSQLÎļþ¼ÐÖеÄMY.INIÎļþ
4.ʹÓÃSET PASSWORDÓï¾ ......

Mysql±àÒë°²×°²ÎÊýÓÅ»¯

 1. -static  13%
   --with-client-ldflags=-all-static
   --with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
2. -pgcc  1%
   CFLAGS="-O3 -mpentiumpro -mstack-align-double" CXX=gcc \
     CXXFLAGS="-O3 -mpentiumpro -mstack-alig ......

PHPÖÐmysql_fetch_array()ºÍmysql_fetch_row()µÄÇø±ð

 ×î½üÔÚ×öPHPÓëÊý¾Ý¿â½»»¥µÄproject£¬¼±ÓÚÇó³É£¬Ä£·ÂÁËÏÂÀý×ӾͿªÊ¼¶¯ÊÖ£¬½á¹ûÎó°Ñmysql_fetch_arrayд³ÉÁËmysql_fetch_row,囧ÊÂÀ´ÁË£¬·¢ÏÖ·µ»ØµÄÊý×é¾ÓÈ»ÊÇindex=>valueµÄÐÎʽ£¬¶øÃ÷Ã÷¼ÇµÃÊÇfield name=>valueµÄ¹þ£¬²éÊÖ²á²ÅÃ÷°×¡£
1. mysql_fetch_arrayµÄº¯ÊýÔ­ÐÍÊÇ
array mysql_fetch_array ( resour ......

ʹÓÃWAMP5´î½¨Apache+MySQL+PHP»·¾³

 Ä¿Ç°Óв»ÉÙAMP£¨Apache\MySQL\PHP£©µÄ¼¯³ÉÈí¼þ£¬¿ÉÒÔÈÃÎÒÃÇÒ»´Î°²×°²¢ÉèÖúá£Õâ¶ÔÓÚ²»ÊìϤAMPµÄÓû§À´Ëµ£¬ºÃ´¦¶à¶à¡£
Ò»¡¢Ê¹ÓÃAMP¼¯³ÉÈí¼þµÄÓŵ㣺
1¡¢¿É±ÜÃâÓÉÓÚȱ·¦AMPµÄ֪ʶ£¬¶øÎÞ·¨ÕýÈ·ÉèÖû·¾³£»
2¡¢¿É¿ìËÙ°²×°²¢ÉèÖúÃAMP»·¾³£¬ÈÃÎÒÃÇÖ±½Ó¿ªÊ¼ÕæÕý¸ÐÐËȤµÄÈí¼þ£¬Èçxoops£»
3¡¢¿É·½±ãµÄ´î½¨²âÊÔ»·¾³£¬¶ÔÓÚ² ......

MySQL 5.1.40ÒѾ­·¢²¼ еÄÐÔÄܹ¤¾ß³öÏÖ

MySQL 5.1.40ÒѾ­·¢²¼£¬ÔÚÕâÀïÓÐһЩеÄÌØÐÔ³öÏÖ£¬°üÀ¨MySQL»ùȺ»ùÓÚ´ÅÅ̵ÄÊý¾ÝÖ§³ÖµÈµÈ¡£¡¡¡¡MySQL 5.1.40ÒѾ­·¢²¼£¬ÕâÒ»°æ±¾µÄMySQLÓкܶàÐµĹ¦ÄÜÌØÐÔ£¬Ï£ÍûÕâЩÐÂÌØÐÔÄÜÈôó¼Ò½ñºóµÄ¹¤×÷¸üÓÐЧÂÊ¡£MySQLÊÇÏÖÔÚ×îÁ÷ÐÐÒ»¸ö¶àÏ̵߳Ä,½á¹¹»¯²éѯÓïÑÔ(SQL)Êý¾Ý¿â·þÎñÆ÷.¾ø´ó¶àÊýPHPÍøÕ¾µÄÊý¾Ý¿âºǫ́¶¼ÊDzÉÓÃÕâÒ»Êý¾Ý¿â.
¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ