PHP MySQL LinuxÄ¿Ç°ÒÑÖð½¥³ÉΪСÐÍweb·þÎñÆ÷µÄÒ»ÖÖ¾µä×éºÏ¡£ÔÚindows»·¾³Ï¹¹ÖþºÍµ÷ÊÔMySQLÊý¾Ý¿âÊÇÐí¶àÍøÕ¾¿ª·¢ÕßµÄÒ»ÖÖÊ×Ñ¡¡£±¾ÈËÔÚWindows98»·¾³Ï³õѧMySQL£¬ÏÖ½«Ñ§Ï°¹ý³ÌÓë¾Ñé×ܽá³öÀ´¹©´ó¼Ò²Î¿¼¡£
1¡¢ÏÂÔØmysql-3.23.35-win.zip²¢½âѹ£»
2¡¢ÔËÐÐsetup.exe;Ñ¡Ôñd:\mysql,"tyical install"
3¡¢Æô¶¯mysql£¬ÓÐÈçÏ·½·¨£º
·½·¨Ò»£ºÊ¹ÓÃwinmysqladmin
1)¡¢½øÈëd::\mysql\binĿ¼£¬ÔËÐÐwinmysqladmin.exe£¬ÔÚÆÁÄ»ÓÒϽǵÄÈÎÎñÀ¸ÄÚ»áÓÐÒ»¸ö´øºìÉ«µÄͼ·û
2)¡¢Êó±ê×ó¼üµã»÷¸Ãͼ·û£¬Ñ¡Ôñ¡°show me¡±£¬³öÏÖ¡°WinMySQLAdmin¡±²Ù×÷½çÃ棻Ê×´ÎÔËÐÐʱ»áÖмä»á³öÏÖÒ»¸ö¶Ô»°¿òÒªÇóÊäÈë²¢ÉèÖÃÄãµÄÓû§ÃûºÍ¿ÚÁî
3)¡¢Ñ¡Ôñ¡°My.INI setup¡±
4)¡¢ÔÚ¡°mysqld file¡±ÖÐÑ¡Ôñ¡°mysqld-opt¡±(win9x)»ò¡°mysqld-nt¡±(winNT)
5)¡¢Ñ¡Ôñ¡°Pick-up or Edit my.ini values¡±¿ÉÒÔÔÚÓұߴ°¿ÚÄÚ¶ÔÄãµÄmy.iniÎļþ½øÐбà¼
6)¡¢Ñ¡Ôñ¡°Save Modification¡±±£´æÄãµÄmy.iniÎļþ
7)¡¢Èç¹ûÄãÏë¿ìËÙʹÓÃwinmysqladmin(¿ª»úʱ×Ô¶¯ÔËÐУ©£¬Ñ¡Ôñ¡°Create ShortCut on Start Menu¡±
8)¡¢²âÊÔ£º
½øÈëDOS½çÃ棻
ÔÚd:\mysql\binĿ¼ÏÂÔËÐÐmysql£¬½øÈëmysql½»»¥²Ù×÷½çÃæ
ÊäÈëshow databases²¢»Ø³µ£¬ÆÁÄ»ÏÔʾ³öµ±Ç°ÒÑÓеÄÁ½¸öÊý¾Ý¿âmysqlºÍtest
·½·¨¶þ£º²»Ê¹ÓÃwinmysqladmin
1)¡¢ÔÚDOS´°¿ÚÏ£¬½øÈëd:/mysql/binĿ¼
2)¡¢win9XÏÂ)ÔËÐÐ:
mysqld
ÔÚNTÏÂÔËÐÐ:
mysqld-nt --standalone
3)¡¢´Ëºó£¬mysqlÔÚºǫ́ÔËÐÐ
4)¡¢²âÊÔmysql:£¨ÔÚd:/mysql/binĿ¼Ï£©
a)¡¢mysqlshow
Õý³£Ê±ÏÔʾÒÑÓеÄÁ½¸öÊý¾Ý¿âmysqlºÍtest
b)¡¢mysqlshow -u root mysql
Õý³£Ê±ÏÔʾÊý¾Ý¿âmysqlÀïµÄÎå¸ö±í£º
columns_priv
db
host
tables_priv
user
c)¡¢mysqladmin version status proc
ÏÔʾ°æ±¾ºÅ¡¢×´Ì¬¡¢½ø³ÌÐÅÏ¢µÈ
d)¡¢mysql test
½øÈëmysql²Ù×÷½çÃ棬µ±Ç°Êý¾Ý¿âΪtest
5)¡¢mysql¹Ø±Õ·½·¨£º
mysqladmin -u root shutdown
4¡¢ÖÁ´Ë£¬MySQLÒѳɹ¦°²×°£¬½Ó×Å¿ÉÒÔÊìϤMySQLµÄ³£ÓÃÃüÁî²¢´´½¨×Ô¼ºµÄÊý¾Ý¿âÁË¡£