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

PHPÔËÐл·¾³ÔÚWindowsϵÄÅäÖÃ(MySQLÅäÖã©

 Èí¼þÀë²»¿ªÊý¾Ý¿â£¬¶øPHP×î³£ÓõÄÊý¾Ý¿âÊÇMySQL¡£MySQLÊý¾Ý¿â·Ö·þÎñ¶ËºÍ¿Í»§¶Ë¡£
MySQL·þÎñ¶ËµÄ°²×°£º
(1)µã»÷MySQL°²×°°ü£¨´Ë´¦µÄ°²×°³ÌÐòΪmysql-5.0.18-win32.zip)
(2) ĬÈÏÊÇTypical,Èç¹ûÏëÐ޸ݲװ·¾¶µÄ»°Ò²¿ÉÒÔÑ¡Ôñcustom.
×¢Òâ:°²×°mysqlµÄ·¾¶ÖÐ,²»Äܺ¬ÓÐÖÐÎÄ!
(3)µã»÷intall¿ªÊ¼°²×°
(4)Ìø¹ý×¢²á
(5)ÊÇ·ñÏÖÔÚ¾ÍÅäÖà MySQL.Ò²¿ÉÒÔÖ®ºóÔÚ¿ªÊ¼²Ëµ¥µÄconfiguration wizard ½øÐÐÅäÖÃ.ÕâÀïÊÇÏÖÔÚ½øÐÐÅäÖÃ
(6)Ñ¡ÔñDetailed Configuration(ÏêϸÉèÖÃ),µãNext¼ÌÐø
(7)ÏÂÃæÕâ¸öÑ¡ÏîÊÇÑ¡ÔñmysqlÓ¦ÓÃÓÚºÎÖÖÀàÐÍ,µÚÒ»ÖÖÊÇ¿ª·¢·þÎñÆ÷,
½«Ö»Óþ¡Á¿ÉÙµÄÄÚ´æ,µÚ¶þÖÖÊÇÆÕͨWEB·þÎñÆ÷,½«Ê¹ÓÃÖеÈÊýÁ¿ÄÚ´æ,
×îºóÒ»ÖÖÊÇÕą̂·þÎñÆ÷ÉÏÃæÖ»ÔËÐÐMySQLÊý¾Ý¿â,½«Õ¼ÓÃÈ«²¿µÄÄÚ´æ.
Óû§¿É¸ù¾Ý×Ô¼ºµÄÐèÇó,Ñ¡ÔñÑ¡Ïî.ÕâÀïֻѡÔñ¿ª·¢·þÎñÆ÷,µãNext¼ÌÐø
(8)ÏÂÃæÊÇÑ¡ÔñÊý¾Ý¿âÓÃ;,µÚÒ»ÖÖÊǶ๦ÄÜÓÃ;,
½«°ÑÊý¾Ý¿âÓÅ»¯³ÉºÜºÃµÄinnodb(ÊÂÎñ)´æ´¢ÀàÐͺ͸ßЧÂʵÄmyisam(·ÇÊÂÎñ)´æ´¢ÀàÐÍ,
µÚ¶þÖÖÊÇÖ»ÓÃÓÚÊÂÎñ´¦ÀíÀàÐÍ,×îºÃµÄÓÅ»¯innodb,µ«Í¬Ê±Ò²Ö§³Ömyisam,Ö»ÓÐmyisam²ÅÖ§³ÖÈ«ÎÄË÷Òý
×îºóÒ»ÖÖÊǼòµ¥µÄÍøÂ翪·¢,ÊʺÏÓÚ¼òµ¥µÄÓ¦ÓÃ,Ö»Óв»Ö§³ÖÊÂÎñµÄmyisamÀàÐÍÊDZ»Ö§³ÖµÄ.
Ò»°ãÑ¡ÔñµÚÒ»Öֶ๦ÄܵÄ.
(9)ÏÂÃæÊÇÑ¡ÔñInnodDBµÄÊý¾Ý´æ·ÅλÖÃ,Ò»°ãĬÈϺÃÁË,²»ÐèÒª¸Ä¶¯(Èç¹ûÒªÐÞ¸ÄÊý¾Ý±£´æÂ·¾¶,Ò²¿ÉÓÃÔÚ°²×°ºóÐÞ¸Ämy.iniµÄdatadirµÄÖµ)
(10) ÏÂÃæÊÇÑ¡ÔñMySQLÔÊÐíµÄ×î´óÁ¬½ÓÊý,µÚÒ»ÖÖÊÇ×î´ó20¸öÁ¬½Ó²¢·¢Êý,
µÚ¶þÖÖÊÇ×î´ó500¸ö²¢·¢Á¬½ÓÊý,×îºó Ò»ÖÖÊÇ×Ô¶¨Òå,Äã¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄÐèҪѡÔñ.
ÕâÀïÑ¡ÔñµÚÒ»¸ö
(11)ÏÂÃæÊÇÊÇ·ñÔËÐÐÍøÂçÁ´½Ó.ÕâÀïÑ¡Ôñ¸´Ñ¡¿ò.Êý¾Ý¿â¼àÌýµÄ¶Ë¿Ú,Ò»°ãĬÈÏÊÇ3306,
Èç¹û¸Ä³ÉÆäËû¶Ë¿Ú,ÒÔºóÁ¬½ÓÊý¾Ý¿âµÄʱºò¶¼Òª¼ÇסÐ޸ĵĶ˿Ú,·ñÔò²»ÄÜÁ¬½ÓmysqlÊý¾Ý¿â,
±È½ÏÂé·³,ÕâÀï²»×öÐÞ¸Ä,ÓÃmysqµÄĬÈ϶˿ڣº3306
(12)ÕâÒ»²½ÉèÖÃmysqlµÄĬÈϱàÂë,ĬÈÏÊÇlatin1,Ò²ÊDZê×¼µÄ±àÂë.µÚ¶þÖÖÊÇUTF8,µÚÈýÖÖÊÇÊÖ¶¯ÉèÖÃ.
±àÂëÊǰ汾4.1ÒÔÉÏÒýÈëµÄ.Èç¹ûÒªÓÃÔ­À´Êý¾Ý¿âµÄÊý¾Ý,×îºÃÄÜÈ·¶¨Ô­À´Êý¾Ý¿âÓõÄÊÇʲô±àÂë,Èç¹ûÕâÀïÉèÖõıàÂëºÍÔ­À´Êý¾Ý¿âÊý¾ÝµÄ±àÂë²»Ò»ÖÂ,ÔÚʹÓõÄʱºò¿ÉÄÜ»á³öÏÖÂÒÂë.½¨ÒéʹÓÃlatin1±ê×¼±àÂë
µ±È»ÎÒÃÇÓÐÐèÒªµÄ»°,Ò²¿ÉÒÔÐÞ¸ÄËüµÄ±àÂë(²»½¨Òé).
(13) ÕâÒ»²½ÊÇÊÇ·ñÒª°ÑmysqlÉèÖóÉwindowsµÄ·þÎñ,Ò»°ãÑ¡ÔñÉè³É·þÎñ,
ÕâÑùÒÔºó¾Í¿ÉÒÔͨ¹ý·þÎñÖÐÆô¶¯ºÍ¹Ø±ÕmysqlÊý¾Ý¿âÁË.ÍÆ¼ö£ºÏÂÃæµÄ¸´Ñ¡¿òÒ²¹´Ñ¡ÉÏ,
ÕâÑù,ÔÚcmdģʽÏÂ,²»±Ø·Çµ½mysqlµÄbinĿ¼ÏÂÖ´ÐÐÃ


Ïà¹ØÎĵµ£º

ubuntu ÏÂ MYSQL °²×°

°²×°MySQL
sudo apt-get install mysql-server mysql-admin mysql-navigator mysql-query-browser
Õâ¸öÓ¦¸ÃºÜ¼òµ¥ÁË£¬¶øÇÒÎÒ¾õµÃ´ó¼ÒÔÚ°²×°·½ÃæÒ²Ã»Ê²Ã´Ì«´óÎÊÌ⣬ËùÒÔÒ²¾Í²»¶à˵ÁË£¬ÏÂÃæÎÒÃÇÀ´½²½²ÅäÖá£
ÅäÖÃMySQL
×¢Ò⣬ÔÚUbuntuÏÂMySQLȱʡÊÇÖ»ÔÊÐí±¾µØ·ÃÎʵģ¬Èç¹ûÄãÒªÆäËû»úÆ÷Ò²Äܹ»·ÃÎʵϰ£¬ÄÇôÐèÒª¸Ä±ä/etc/m ......

ubuntu Ï ´î½¨ apache+php+mysql


#apt-get install apache2
//°²×°apahce2
#apt-get install php5
//°²×°php5
#apt-get install mysql-server
//°²×°mysql·þÎñ¶Ë
#apt-get install  mysql-myclient
//°²×°mysqlµÄ¿Í»§¶Ë
#apt-get install php-mysql
//°²×°php-mysqlµÄÁ¬½á
apache+php+mysql »·¾³ÒѾ­´î½¨ºÃÁË
½«ÒÔϵķþÎñÖØÆôÒ»ÏÂ
#/et ......

XAMPP 1.7.0ÖÐMySqlÎÞ·¨Æô¶¯½â¾ö·½·¨

ÎÒÔÚ°²×°XAMPP 1.7.0ʱ£¬°²×°³É¹¦ºó£¬´òËãÆô¶¯XAMPP¡£Apache˳ÀûÆô¶¯£¬µ«ÊÇMySqlÔõô¶¼Æô¶¯²»ÁË£¬ÌáʾµÄ´íÎóÊÇ£º
error:mysql service not started [-1]
ÎÒÖØÐÂ×°Á˼¸´Î¶¼²»ÐУ¬ÏÂÔØÁËÆäËûµÄ°æ±¾Ò²²»ÐУ¬ÎÒÕæ¸ã²»Çå³þΪʲô¡£ÎÒGoogleÁ˰ëÌ죬ÆðÏÈʱÖÐÎÄÍøÒ³£¬°´ÕÕ¼¸¸ö½â¾ö·½·¨×öÁ˶¼²»ÐУ¬¿Ï¶¨ÊÇûÓжÔÖ¢ÏÂÒ©°Ñ£¬È»ºóÎÒµ ......

MySQL ALTERÓï·¨

 
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
or ADD INDEX [index_name] (index_col_name,...)
or ADD PRIMARY KEY (index_col_name,...)
or ADD UNIQUE [index_name] (index_col_name,...)
or ALTER [ ......

[ת]mysqlÐÔÄܵļì²éºÍµ÷ÓÅ·½·¨

ÎÒÒ»Ö±ÊÇʹÓÃmysqlÕâ¸öÊý¾Ý¿âÈí¼þ£¬Ëü¹¤×÷±È½ÏÎȶ¨£¬Ð§ÂÊÒ²ºÜ¸ß¡£ÔÚÓöµ½ÑÏÖØÐÔÄÜÎÊÌâʱ£¬Ò»°ã¶¼ÓÐÕâô¼¸ÖÖ¿ÉÄÜ£º
1¡¢Ë÷ÒýûÓн¨ºÃ£»
2¡¢sqlд·¨¹ýÓÚ¸´ÔÓ£»
3¡¢ÅäÖôíÎó£»
4¡¢»úÆ÷ʵÔÚ¸ººÉ²»ÁË£»
1¡¢Ë÷ÒýûÓн¨ºÃ
Èç¹û¿´µ½mysqlÏûºÄµÄcpuºÜ´ó£¬¿ÉÒÔÓÃmysqlµÄclient¹¤¾ßÀ´¼ì²é¡£
ÔÚlinuxÏÂÖ´ÐÐ
/usr/local/mysql/bin/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ