°²×°UCenter¹ý³ÌÖС°²»Ö§³ÖMysqlÊý¾Ý¿â¡±µÄ½â¾ö·½·¨
°´ÕÕ¹Ù·½ÌṩµÄ“UCenter 1.5.0 °²×°Í¼ÎĽ̳̔£¬ÎÒ¿ªÊ¼×°ÉÏphp5,mysql5,apache2.2£¬½á¹ûÔÚhttp://127.0.0.1/ucenter/install/index.phpʱÓöµ½ÁËÁîÈËÓôÃÆµÄÒ»¿Ì£¬
²é²é×ÊÁÏÒ»¿´£¬ÓкܶàÅóÓѶ¼Óöµ½ÀàËÆÇé¿ö£¬¶øÇÒÎʵÄÌû×Óµ½ÏÖÔÚ»¹Ã»Óиø»Ø£¬ÐÄÀíÄÉÃÆÑ½£¬ÎªÉ¶UcenterµÄÌṩ¹«Ë¾“¿µÊ¢´´Ï딵Ŀª·¢ÈËÔ±²»³öÀ´¸ø½â´ðÒ»ÏÂÄØ£¬±Ï¾¹´ó¼Ò¶¼ÊÇÓÃÁËÄãµÄ²úÆ·²Å·¢µÄÌû×Óѽ£¬Ã»°ì·¨£¬½áºÏÍøÉϵÄÌû×Ó£¬×îÖÕ»¨ÁË15·ÖÖÓ½â¾öÁËmysqlµÄÎÊÌ⣬ÏÖ½«·½·¨¹«²¼ÈçÏÂ(Õë¶Ôwindows)£º
1¡¢ÕÒµ½phpµÄextĿ¼ÏµÄphp_mysql.dllºÍphp¸ùĿ¼ÏµÄlibmysql.dll£¬½«ÕâÁ½ÎļþcopyÖÁÔÚwindowsϵͳµÄsystem32ÖÐ
2¡¢php¸ùĿ¼ÏµÄphp.iniÎļþÖУ¬Ã»Óн«“;extension=php_mysql.dll”ÖеÄÇ°ÃæÒ»¸ö“;”È¥µô£»
3¡¢ÖØÆôapacheºó£¬¾ÍOKÁË¡£
ÌîÈëÊý¾Ý¿âµÈÏà¹ØÐÅÏ¢ºó£¬¼ÌÐø°²×°£¬ÈçÏÂ
Ïà¹ØÎĵµ£º
MYSQLÖг£ÓõÄÃüÁî´óÈ«
Ò»¡¢ Êý¾Ý¿â²Ù×÷µÄÃüÁî
1. ´´½¨Êý¾Ý¿â
Ø create database Name;
2. Ñ¡ÔñÊý¾Ý¿â
Ø use DatabaseName;
3. Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
Ø drop database Name;
4. ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
Ø drop ......
Ê×ÏÈ£¬´ò¿ªcmd—–net start ²é¿´mysqlÊÇ·ñÆô¶¯¡£Æô¶¯µÄ»°¾ÍÍ£Ö¹net stop mysql.
1¡¢ÔÚdosÏÂÔËÐÐC:\Program Files\MySQL\MySQL Server 5.0\bin
2¡¢mysqld-nt --init-file=c:\mysql\pwdhf.txt ÆäÖÐÔÚc:\mysql½¨Ò»¸öpwdhf.txtÎļþ£¬²¢Ð´ÏÂÄãµÄÐÂÃÜÂë¡£
3¡¢ÔËÐÐЩÃüÁîºó£¬ÔÙÓÃÐÂÃÜÂëµÇ¼£¬¼´¿É³É¹¦ÐÞ¸ÄÃÜÂë¡£ ......
½øÈëcmd
===================
1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......
·/etc/my.cnfÊÇĬÈϵÄMySQLÅäÖÃÎļþ¡£Ó¦¸Ã¶ÔÕâ¸öÎļþÅäÖÃÐ޸ġ£ËüÊÇΪѧϰĿµÄ¶øÉè¼ÆµÄ¡£
·my-small.cnfÊÇΪÁËСÐÍÊý¾Ý¿â¶øÉè¼ÆµÄ¡£²»Ó¦¸Ã°ÑÕâ¸öÄ£ÐÍÓÃÓÚº¬ÓÐһЩ³£ÓÃÏîÄ¿µÄÊý¾Ý¿â¡£
·my-medium.cnfÊÇΪÖеȹæÄ£µÄÊý¾Ý¿â¶øÉè¼ÆµÄ¡£Èç¹ûÄãÕýÔÚÆóÒµÖÐʹÓÃRHEL,¿ÉÄÜ»á±ÈÕâ¸ö²Ù×÷ϵͳµÄ×îСRAMÐèÇó(25 ......