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

Windows7×°²»ÉÏMysql½â¾ö·½°¸

³õ´Î°²×°·½·¨£º
1¡¢È¥¹Ù·½ÏÂÔØMYSQL 5.0¡£
¡¡¡¡2¡¢Ð޸ķÀ»ðǽµÄÉèÖã¬ÔÚÔÊÐíÀýÍâÀïÌí¼ÓеĶ˿ڣ¬Ãû×ÖΪmysql£¬¿ª·ÅµÄ¶Ë¿ÚΪTCP 3306¡£
¡¡¡¡Õâ¸ö´ó¼ÒÓ¦¸Ã¶¼»á£¬ÔÚVista¿ØÖÆÃæ°åµÄWindows·À»ðǽÀïÃ棬µã»÷“¸ü¸ÄÉèÖÔ-“ÀýÍ┣¬µã»÷“Ìí¼Ó¶Ë¿Ú”¾Í¿ÉÒÔ¡£¡¡¡¡
    
    3¡¢°²×°MYSQL 5.0£¬¿ÉÒÔ×Ô¼ºÐ޸ݲװ·¾¶ºÍ×é¼þµÈ¡£
¡¾°²×°³É¹¦ºó£¬²»ÄÜÔËÐÐMySQLInstanceConfig.exe£¬Ö±½Ó´ÓÕâ±ß¿´¡¿
¡¡ 4¡¢°²×°Íê³Éºó£¬Mysql server instance config wizardÓ¦¸ÃÊÇÆô¶¯²»Á˵ģ¬ÏÂÃæµÄ¹¤×÷¾ÍÊÇΪÁ˽â¾öÕâ¸öÎÊÌâµÄ£¬ÒòΪÕâÊÇÅäÖÃMysqlµÄΨһ;¾¶¡£
¡¡ 5¡¢ÏÂÔØResource HackerµÃ¼òÌåÖÐÎÄ°æ(Èç¹ûÄã¿´µÄ¶®Ó¢ÎÄ£¬ÄǾÍÖ±½ÓÏÂÔ­°æµÄ)¡£
http://www.programfan.com/showdown.asp?id=132
eXeScopeÒ²¿ÉÒÔ¡£¡£¡£¡£
¡¡ 6¡¢½âѹrh_chinese_big5.zip £¬Ö´ÐÐ ResHacker.exe
¡¡ 7¡¢´ò¿ªMySQLInstanceConfig.exe (ÔÚ°²裝 MySQL µÄbin Ŀ¼ÖÐ) £¬¿ÉÒÔÓÃÊó±êÖ±½Ó°ÑexeµÈ×ÊÔ´ÎļþÍϵ½Resource Hacker´°ÌåÉÏÃæ¡£
¡¡ 8¡¢×ó²àÕ¹¿ª¡¸24¡¹→¡¸1¡¹→¡¸1033¡¹
¡¡ 9¡¢ÓÒ²àÕÒµ½ ÕâÐÐ
¡¡ 10¡¢½« level="asAdministrator" ¸Ä³É level="requireAdministrator"
¡¡ 11¡¢ÖØбàÒë
¡¡ 12¡¢±£´æºó¹Ø±Õ (Èç¹û²»Äܱ£´æ£¬Áí´æÔÚ bin Ŀ¼Í⣬Ȼºó¸²¸Ç»Ø來Ò²¿ÉÒÔ)
¡¡ 13¡¢Õâʱ£¬Äã¾Í»á·¢ÏÖMySQLInstanceConfig.exe¿ÉÒÔÕý³£µÄÅäÖÃÀ²¡£


Ïà¹ØÎĵµ£º

ÓÃMySQL Éú³ÉËæ»úÃÜÂë

ÍíÉÏÓÐÅóÓÑÎÊÆ𣬼òµ¥µÄдÁËÒ»¸ö¡£
DELIMITER $$
CREATE
    FUNCTION `t_girl`
.
`func_rand_string`
(
f_num tinyint
unsigned
,
f_type tinyint
unsigned
)
    RETURNS varchar
(
32)
    BEGIN
       ......

ÉèÖÃmysqlĬÈϱàÂë

°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚwindowsÏÂmysqlµÄdateÎļþ¼Ð
Æô¶¯mysqlºó£¬ÒÔrootµÇ¼mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #Ö´ÐбàÂëÏ ......

MYSQLÍü¼ÇROOTÃÜÂëºó£¿

 
 MYSQLÍü¼ÇROOTÃÜÂëºó£¿
 
ÐÞ¸ÄMySQLµÄµÇ¼ÉèÖãº
1.È¡ÏûȨÏÞ¹ÜÀí
±à¼­ /mysql5.1/my.ini
ÔÚ[mysqld]µÄ¶ÎÖмÓÉÏÒ»¾ä£ºskip-grant-tables
ÀýÈ磺
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
skip-grant-tables
Ä¿µÄÊÇΪÁË£º
Ìø¹ýMySQLµÄ·ÃÎ ......

mysqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö£¨×ܽáƪ£©

 mysqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö£¨×ܽáƪ£©
 
µÚÒ»½â¾ö·½·¨£º
 
      ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
......

Mysql innodb Îóɾ³ýÊý¾Ý¿âÊÇ·ñ¿É»Ö¸´

¿ÉÒÔ£¬µ«ÊÇÍêÈ«»Ö¸´ËùÓÐµÄ±í²»Ò»¶¨¿ÉÒÔ
¹¤¾ß: innodb-recovery
Official Website: http://code.google.com/p/innodb-tools/
This set of tools could be used to check InnoDB
tablespaces and to recover data from damaged tablespaces or from
dropped/truncated InnoDB tables.
Õâ¸ö¹¤¾ßÓÃÀ´¼ì²éInnoDB¿Õ¼ä±íºÍ» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ