Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
£¬¸ù¾Ýʵ¼ÊÇé¿ö×öÁ˲¿·ÖÐ޸ġ£


Ïà¹ØÎĵµ£º

¹ØÓÚÖØÐÂapacheºóÎÞ·¨ÔØÈëmysqlÀ©Õ¹½â¾ö°ì·¨

ÍøÉϺܶàдÔÚwindowsÏÂÎÞ·¨ÔØÈëmysqlÀ©Õ¹½â¾ö°ì·¨£¬µ«ÊÇÔÚliunxϵľÍû¼¸¸ö£¬ÒÔÏÂÊÇÔÚliunxϵĽâ¾ö°ì·¨
 ÖØ×°ºóphp²»»á×Ô¶¯°Ñmysql.soÀ©Õ¹¼ÓÉÏÈ¥,Òª
sudo vim /etc/php5/apache2/conf.d/pdo.ini
¼ÓÈëextension=mysql.so¾Í¿ÉÒÔÁË
ÆäʵҲ¿ÉÒÔÔÚ /etc/php5/apache2/php.iniÖмÓÈë
Ò²¿ÉÒÔÔÚ/etc/php5/apache2/conf. ......

ʹÓÃ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ÉÓÃÕâÒ»Êý¾Ý¿â.
¡¡ ......

mysqlÖÐÎÄÂÒÂë

µÚÒ»²½£ºÐÞ¸ÄÊý¾Ý¿âÅäÖÃÎļþmy.ini
¿Í»§¶ËµÄĬÈÏ×Ö·û±àÂ룺
default-character-set=utf8
·þÎñÆ÷¶ËµÄĬÈÏ×Ö·û±àÂë
default-character-set=utf8
µÚ¶þ²½£ºÖØÐÂÆô¶¯mysqlÊý¾Ý¿â
net stop mysql
net start mysql
µÚ¶þ²½£ºÐÞ¸ÄapplicationContent.xml
ÐÞ¸ÄurlÊôÐÔ£¬½«Æä¸ÄΪ£ºjdbc:mysql://localhost:3306/member?useUni ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ