mysql windows°²×°£¬Ò»²½²½½ÌÄãÔÚWindows»·¾³Ï°²×°MySQL

Ò»²½²½½ÌÄãÔÚWindows»·¾³Ï°²×°MySQL - Ó¦ÓÃÈí¼þ - µçÄԽ̳ÌÍø

Ò»²½²½½ÌÄãÔÚWindows»·¾³Ï°²×°MySQL

ÈÕÆÚ£º2006-03-28   ¼ö£º

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µÄ³£ÓÃÃüÁî²¢´´½¨×Ô¼ºµÄÊý¾Ý¿âÁË¡£

±êÇ©£º