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

¿ªÆôMYSQLÈÕÖ¾ÅäÖÃ

ÔÚ[mysqld] ÏÂÌí¼Ó²ÎÊýÈçÏÂ
 #´íÎóÈÕÖ¾Êä³ö·¾¶(ʹÓÃ/×÷Ϊ·Ö¸î¶ø²»ÊÇ\)
log-error="your error-log path"
log="Your mysql log path"
log-show-queries="Your slowquery path"
#É趨³¬Ê±Ê±¼ä ´Ë´¦ÉèÖÃΪÁ½Ãë
long_query_time=2
Ok save my.ini
next
#Í£Ö¹mysql ·þÎñ
net stop mysql 
#ÖØÐ¿ªÊ¼·þÎñ
net start mysql


Ïà¹ØÎĵµ£º

mysql Êý¾Ý¿âÎļþÀ©Õ¹Ãû


¸ñʽÎļþ .frm ÃèÊö±íµÄ½á¹¹£¨ÁС¢ÁÐÀàÐÍ¡¢Ë÷Òý£¬µÈµÈ£©
Êý¾ÝÎļþ .ISD(ISAM) »ò .MYD (MyISAM) °üº¬±íµÄÊý¾Ý©¤¼´ËüµÄÐÐ

Ë÷ÒýÎļþ ISD(ISAM) »ò .MYI (MyISAM) °üº¬Êý¾ÝÎļþÖÐÈκÎË÷ÒýµÄË÷ÒýÊ÷¡£ÎÞÂ۸ñíÓÐÎÞË÷Òý£¬Ë÷ÒýÎļþ¶¼´æÔÚ
......

mysql 4.1.12


MySQL 4.1.12°²×°Æª
[Ïà¹ØÈí¼þÏÂÔØ£º]
Mysql 4.1.12-win32 -
For Windows ( Mysql 4.1.12-win32.exe ) -- Êý¾Ý¿â·þÎñ
ÏÂÔØµØÖ·£º
http://cdgwbn.downloadsky.com:8080/down/mysql-4.1.12-win32.zip
Connector/ODBC
- MySQL ODBC driver ( MyODBC-3.51.11-1-win.exe ) -- Êý¾ÝÔ´
ÏÂÔØµØÖ·£º
http://down.21sun.ne ......

mysql Ìí¼ÓÓû§µÄÃüÁî

Ò»¡¢´´½¨Óû§µÄÃüÁî
mysql> create user 'username'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.06 sec)
¶þ¡¢¸øÐ¼ÓÓû§ÊÚÓèȨÏÞ
mysql> grant all privileges on test.* to 'username'@'localhost';
Query OK, 0 rows affected (0.00 sec)
˵Ã÷£ºÕâÌõÃüÁîÊÚÓè username ¶ÔÊý¾Ý¿â te ......

MYSQL»ù´¡Ö®Á¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ìí¼ÓÓû§

Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ ......

CÓïÑÔÁ¬½ÓMySQLÊý¾Ý¿â

ǰ¼¸Ì칫˾ÈÃÎÒ×öCÓïÑÔºÍMySQLÊý¾Ý¿âµÄ½»»¥²Ù×÷£¬·ÑÁ˾ÅÅ£¶þ»¢Ö®Á¦Ö®ºó×ÜËã×ö³öÀ´ÁË£¬½ñÌìÌØµØ°ÑÔ´´úÂëÌù³öÀ´¹©´ó¼Òѧϰ£»ÈçÓÐÈËÏëÒª´ò°üÏîÄ¿¿ÉÒÔ¼ÓÎÒQQ260990509,×¢Ã÷¼¼Êõ½»Á÷£¬¼´¿É»ñµÃ´ò°üÖ®ºóµÄÏîÄ¿£¡
#if defined(_WIN32) || defined(_WIN64)  //ΪÁËÖ§³Öwindowsƽ̨ÉϵıàÒë
#include <windows.h>
#end ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ