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

MySQL Ãâ°²×°°æÅäÖÃ

1.ÏÂÔØ MySQL 6.0Ãâ°²×°°æ
http://www.mysql.com/downloads/mirror.php?id=386828
2.½« MySQL6.0 ½âѹµ½´ý°²×°Ä¿Â¼(×Ô¼º¾ö¶¨·Åµ½ÄÄ£©¡£½âѹºóĬÈÏÎļþ¼ÐÃû³ÆÎª£ºmysql£¨µ±È»¿ÉÒÔ×Ô¼º¸ü¸Ä£©£¬È»ºóÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¨ÕâÑù£¬ÒÔºó¿ÉÒÔÓÃ%MYSQL_HOME%ÒýÓð²×°Ä¿Â¼£©¡£È磬ÎÒ·ÅÔÚEÅ̸ùĿ¼Ï£¬ËùÒÔ£¬MYSQL_HOMEÉèÖÃΪ£ºE:\mysql
3.´ò¿ªÎļþmy-huge.iniÁí´æÎªmy.ini£¬ÔÚmy.iniÎļþ×îºó£¨µ±È»Ò²¿ÉÒÔÔÚÆäËûµØ·½£©¼ÓÈëÈçÏÂÅäÖá£(my.ini¼ÇµÃÊDZ£´æÔÚÓëmy-huge.iniͬһ¸öĿ¼Ïµģ©(#±íʾעÊÍ£©
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=E:\mysql
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐëÊÇdata£¬»òÕßÊÇ[url=file://\\xxx-data]\\xxx-data[/url]
datadir=E:\mysql\data
4.°Ñ%MYSQL_HOME%\bin ¼ÓÈëµ½ path»·¾³±äÁ¿ÖС£
5.ÔÚÃüÁîÐУ¨cmd£©Ö´ÐÐÃüÁmysqld -install  ¡£½«mysql°²×°Îªwindows·þÎñ¡££¨Ò»¶¨×¢Ò⣬ִÐдËÃüÁîʱһ¶¨ÒªÔÚ°²×°Ä¿Â¼ÏµÄ\binĿ¼ÏÂÖ´ÐС£·ñÔò»á³öÎÊÌâ¡££©
6.Ö´ÐÐÃüÁ net start mysql »òÔÚwindows¹ÜÀí¹¤¾ß->·þÎñÀïÕÒµ½MySQL·þÎñ£¬Æô¶¯¡£
5.ÔÚÃüÁîÐÐÖÐÔËÐÐ mysql -uroot  £¨¿ÉÔÚÈÎÒâĿ¼Ï£¬ÒòÎªÇ°ÃæÉèÖÃÁËpath±äÁ¿£©¡£¼´¿É½øÈëÊý¾Ý¿â¡£
Ò»°ãÇé¿öÏ£¬ÕâÑù²Ù×÷ºó£¬mysql°²×°Íê³É¡£
×¢£º
Èç¹ûÒÔǰϵͳ´æÔÚmysql¡£Ôò½øÈëÒÔǰϵͳ´æÔÚµÄmysqlĿ¼,Ö´ÐÐ mysqld-nt.exe --remove(ÏÈ´ÓϵͳÖÐÒÆ³ýmysql·þÎñ)ÔÚ¿ªÊ¼Ö´ÐÐÉÏÃæµÚ4²½¡£
¡ïÉèÖÃMySQLÖÐÎÄ×Ö·û¼¯£¨MySQLÕý³£ÏÔʾÖÐÎÄ£©
1).ÅäÖ÷þÎñÆ÷¶Ë£¬ÐÞ¸Ämy.iniÎļþ£¬Ê¹ÓÃÖÐÎÄ×Ö·û¼¯´æ´¢¼Ç¼£¬Í¬Ê±ÓÃÖÐÎÄÅÅÐò±È½Ï·½Ê½¡£
[mysqld]
# set character set,ʹÓÃÖÐÎÄ×Ö·û¼¯´æ´¢¼Ç¼
default-character-set=gbk
# set character collation,ʹÓÃÖÐÎÄÅÅÐò±È½Ï·½Ê½
default-collation=gbk_chinese_ci
2). Èç¹ûÒªÔÚÖÐÎÄ»·¾³µÄ·þÎñÆ÷¶ËʹÓÃmysqlÃüÁîÐУ¬¸Ä±ämy.iniÎļþÖÐmysqlµÄĬÈÏ×Ö·û¼¯¡£
[mysql]
# set character set
default-character-set=gbk
¡ïÐÞ¸ÄrootÃÜÂë
MySQLÅäÖÃºÃºó£¬Æô¶¯³É¹¦£¬Ä¬ÈÏÃÜÂëÊǿգ¬µ«ÊÇΪÁ˰²È«£¬ÉèÖÃÃÜÂ루MySQLÓÐÒ»¸öĬÈÏÓû§ÃûΪroot£¬ÃÜÂë×Ô¼ºÉ趨£º¼ÙÈçÉèΪroot£©¡£
1£©µÇ¼MySQL rootÓû§£º
   ´ò¿ªÃüÁîÐУ¬Ö´ÐУºmysql -uroot
2£©ÐÞ¸ÄrootÃÜÂ룺
       mysql> update mysql.user set password="root" where User=''root'';
       mysql> flush privileg


Ïà¹ØÎĵµ£º

FreeBSDÀûÓÃports°²×°MySQL+Apache+PHP

ʹÓÃPorts·½Ê½ÔÚFreeBSDÏÂÅäÖÃMySQL,Apache,PHP
ÓôÃÆÁ˺ü¸Ìì,ÖÕÓÚÔÚFreeBSDϽ«MySQL,Apache,PHPµÄ»·¾³ÅàÖ²ºÃÁË.ϱ߰ÑÅäÖò½ÖèºÍ×¢ÒâµãÂÞÁÐÔÚϱß,ºÍ´ó¼Ò·ÖÏí.
 
 FreeBSD°æ±¾ÊÇ7.3,MySQL°æ±¾ÊÇ5.0.90,Apache°æ±¾ÊÇ2.2.14£¨1.3.42£©,PHP°æ±¾ÊÇ5.2.12.Îҵݲװ˳ÐòÊÇÏÈMySQL,È»ºó°²×°ApacheºÍPHP,Ò»°ãÊǰ²×°Í ......

Windows Ï Apache Mysql PHP µÄ°²×°

Ò»  Apache µÄ°²×°
 1  Apache µÄ°²×°
2 ͬÒâЭÒé
3 ½Ó×Å "Next "
4  Ìîд ÓòÃû(network domain) ·þÎñÆ÷µÄÃû³Æ (Server Name) ¹ÜÀíÕßÓÊÏä(Administrator's Email)
5 °²×°ÀàÐÍ
6 Ñ¡Ôñ°²×°Â·¾¶
7 µã»÷“install ” ¼ÌÐø
8 ¿ªÊ¼°²×°
9  °²×°½áÊø
¶þ   MySqlµÄ°²×° ......

apacheµÄ¾²Ì¬/¶¯Ì¬±àÒëÔÚapache+php+mysqlµÄÓ¦ÓÃ

apacheµÄ¾²Ì¬/¶¯Ì¬±àÒëÔÚapache+php+mysqlµÄÓ¦ÓÃ
ÎÒÏë´ó¼ÒÓв»ÉÙ¶¼³É¹¦ÊµÏÖapache+php+mysql£¬ÍøÉϵÄÎÄÕÂÒ²Óв»ÉÙ£¬µ«ÎÒ·¢ÏÖ²»ÉÙÎÄÕ¶¼Êdz­À´³­È¥£¬²¢ÇÒ
ûÓÐ˵Ã÷°×±àÒëµÄ·½Ê½£¬ÓеÄË÷ÐÔapache1.3µÄ±àÒë·½·¨Ô­·â²»¶¯µÄ°á¹ýÀ´Ì×ÔÚapache2.0£¬ÏÔÈ»Îóµ¼Ò»Ð©²ËÄñ £¡
ÎÒ½ñÌì¾ÍÒÔapache+mysql+php˵һϾ²Ì¬±àÒëºÍDSO¶¯Ì¬±à ......

VC++ÔÚWindowsƽ̨Á¬½ÓMySqlÊý¾Ý¿â

       ÒÔǰÓùßÁËMSSQL£¬VC++ÓÐÇ¿´óµÄADOÖ§³Ömssql£¬·½±ã°¡£¬²»¹ÜÊÇÁ¬½Ó£¬²Ù×÷µÈ¶¼ÊÇÀÊÀÊÉÏÊÖ°¡¡£µ«ÊÇÏÖÔÚͻȻҪÓÃMySqlÁË£¬¿ªÊ¼Ã»ÓÐmssqlÄÇÑùµÄ²Ù×÷½çÃæ£¬ÎÒÕæÓеãÅų⡣°¥£¬Ã»°ì·¨£¬¹«Ë¾ÒªÇó£¬Ö»ÄÜÑо¿MySqlÔõôÓÃÁË¡£
       ¸Õ¿ªÊ¼¾ÍÓöµ½ÁËÒ»¸ö»ù±¾µÄÎÊ ......

Red Hat ÏÂ °²×° Apache Mysql PHP

×¼±¸
ls  /usr/local/src   //  ÏÔʾÎļþÁбí
ls  | wc -l    //  ²é¿´µ±Ç°ÎļþĿ¼ÏÂÎļþµÄ¸öÊý
gcc -v   // ²é¿´±àÒ빤¾ßÊÇ·ñ´æÔÚ
rpm -qa|grep -i  xxxx  // ²é¿´ÏµÍ³ÖÐÊÇ·ñÒѾ­°²×°ÁËijÈí¼þµÄÏà¹ØÈí¼þ°ü
rpm -e --nodeps xxxx // Ð¶ÔØÈí ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ