²úÆ· °²×°ÖÐµÄ MySql ÂÌ»¯½Ì³Ì
×î½üÊÕµ½·´À¡£¬ºÜ¶à¿Í»§Á¬MySql¶¼ÎÞ·¨ÕýÈ·°²×°¡£ÊÕµ½ÈÎÎñ£¬Òª½«MySql´òµ½²úÆ·ÖУ¬ºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ£¬À¿ª¼Ü
ʽ¸É°É£¬Ã»·¨×Ó¡£
Ñо¿Ò»Õ󣬷¢ÏÖ½«°²×°ºÃµÄMySqlÎļþ¼ÐCopyµ½ÆäËüµçÄÔÉÏ£¬ÔÙ½â¾öºÃÁ½¸öÎÊÌâÓ¦¸Ã¾Í¿ÉÒԺͰ²×°°æÒ»ÑùÕý³£Ê¹Óá£
1.Copyµ½ÁËÆäËüµçÄÔÉϵIJ»Í¬Ä¿Â¼£¬Ó¦¸ü¸ÄMysqlµÄÅäÖÃ.
2.½«MySql×¢²á³ÉwindowsµÄϵͳ·þÎñ.
ÏÂÃæ£¬¾ÍÈÃÎÒ˵һÏÂÎÊÌâµÄ½â¾ö֮·
1.¾Ñо¿ÖªµÀ£¬MysqlµÄ±¾µØÂ·¾¶ÅäÖÃÐÅÏ¢ÊÇ´æÔÚmy.iniÎļþϵġ£ÔÚmy.iniÖеÄ[mysqld]·¢ÏÖbasedir="C:/Program Files/MySQL/MySQL Server 5.0"¼°datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/",È·¶¨Õâ¾ÍÊÇ
°²×°Ö®ºóÒª¸ü¸ÄµÄµØ·½¡£
2.¾¹ý¶à´ÎʵÑ飬ÔÚMySQL/MySQL Server 5.0µÄbinĿ¼ÏÂÖ´ÐÐ,ÏÂÃæÕâDOCÃüÁ
mysqld-nt --install MySQL --defaults-file="bin\my.ini"
¾Í¿ÉÒÔ½«MySQLÕý³£µÄ×¢²áwindowsµÄϵͳ·þÎñ.
Ö´ËmysqlµÄ×Ô°²×°¾Í½²½âÍê±Ï£¬¿´ÆðÀ´ºÜ¼òµ¥£¬²»¹ý¹ý³Ì»¹ÊǺܼèÐÁµÄ¡£ÖÁÓÚÈçºÎºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ,²¢²»ÓëÔÓеÄ
MySqlÓгåÍ»£¬ºóÃæ»á¼ÌÐø½éÉÜ
Ïà¹ØÎĵµ£º
×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸ö˶¼Ã»´í¡£
MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆÎª255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......
¶ÔÓÚÖеȼ¶±ðÒµÎñÁ¿µÄϵͳÀ´Ëµ£¬±¸·Ý²ßÂÔ¿ÉÒÔÕâô¶¨£ºµÚÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿ÌìÒ»´ÎÔöÁ¿±¸·Ý£¬Ã¿ÖÜÔÙ×öÒ»´ÎÈ«Á¿±¸·Ý£¬Èç´ËÒ»Ö±ÖØ¸´¡£¶ø¶ÔÓÚÖØÒªµÄÇÒ·±Ã¦µÄϵͳ À´Ëµ£¬Ôò¿ÉÄÜÐèҪÿÌìÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿Ð¡Ê±Ò»´ÎÔöÁ¿±¸·Ý£¬ÉõÖÁ¸üƵ·±¡£ÎªÁ˲»Ó°ÏìÏßÉÏÒµÎñ£¬ÊµÏÖÔÚÏß±¸·Ý£¬²¢ÇÒÄÜÔöÁ¿±¸·Ý£¬×îºÃµÄ°ì·¨¾ÍÊDzÉÓÃÖ÷´Ó¸´ÖÆ»ú ÖÆ(replica ......
gNBpPFgyOw9Rwt/ozsnjgM7tJNo2 bhaaAThangemMkaz2tQhq3/f7dZ7 Vj29WeGHjuupj/AhYqymjAuokhYi X1T/fG+q1yR22PdcEP39dxU3ovEo lLLzwIZlQr9oJYwUf5eG4x5e1bMP nfIaIl8reszQPHFNbrxBjCVrBEXL TyBLehxzUpVI672t3LjX8q4ytCRC ezcoZQfMAc0DulJzNREbwlcf0Rco N0zW3ojBUxGsplBBZZPrD7/bPhkM rjtS8Bxym+HeV1TJDTXuiL8QLg== ......
MySQLµÄÊý¾Ý±íÀàÐͺܶ࣬MySQLÒ»¹²ÏòÓû§ÌṩÁ˰üÀ¨DBD¡¢HEAP¡¢ISAM¡¢MERGE¡¢MyIAS¡¢InnoDBÒÔ¼°GemeniÕâ7ÖÖ±í¡£ÆäÖÐDBD¡¢InnoDBÊôÓÚÊÂÎñ°²È«Àà±í£¬¶øÆäËûÊôÓÚÊÂÎñ·Ç°²È«Àà±í¡£
DBD
Berkeley DB(DBD)±íÊÇÖ§³ÖÊÂÎñ´¦ÀíµÄ±í£¬ÓÉSleepycatÈí¼þ¹«Ë¾¿ª·¢¡£ËüÌṩMySQLÓû§ÆÚ´ýÒѾõŦÄÜ--ÊÂÎñ¿ØÖÆ¡£ÊÂÎñ¿ØÖÆÔÚÈκÎÊý¾Ý¿âϵͳÖÐ ......
cmdÏÂÇл»µ½ mysql °²×°Ä¿Â¼
Àý
d:/mysql/bin
(Èç¹ûÓÃWAMP°²×°ÔòÊÇD:\wamp\bin\mysql\mysql5.1.30\bin)
ǰÌ᣺mysqlÓû§rootÃÜÂëΪ¿Õ.
Êä
Èë mysql -u root mysql
mysql> ״̬ÏÂÊäÈë
update user set password=password('ÐÂÃÜÂë') where user='root';
ȯ
ÏÔ
Quer ......