mysql ÈëÃÅ£¬MySQLÈëÃÅѧϰ£¨1£©

MySQLÈëÃÅѧϰ£¨1£© - Ó¦ÓÃÈí¼þ - µçÄԽ̳ÌÍø

MySQLÈëÃÅѧϰ£¨1£©

ÈÕÆÚ£º2007-09-05   ¼ö£º
¡¡¡¡MySQLÈëÃÅѧϰ£¨1£© ¡¤ °²×°Æª 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µÄ³£ÓÃÃüÁî²¢´´½¨×Ô¼ºµÄÊý¾Ý¿âÁË¡£ £¨Î´Íê´ýÐø£©
±êÇ©£º