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.net/webtools/MyODBC-3.51.11-1-win.exe
MySQL
Control Center ( mysqlcc-0.9.4-win32.zip ) -- ¹ÜÀí¹¤¾ß
ÏÂÔØµØÖ·£º
http://down.21sun.net/webtools/mysqlcc-0.9.4-win32.zip
ÒÔÉÏÏÂÔØµØÖ·ÈôʧЧ£¬ÇëÁíѰËü´¦ÏÂÔØ£¡
[Éý¼¶ÏµÍ³ODBC- MySQL ODBC driver ]
Ê×ÏÈ´ò¿ªÄãµÄ¿ØÖÆÃæ°æ£¬ÕÒµ½ [Ìí¼Óɾ³ý³ÌÐò] °Ñ¾ÉµÄMySQL ODBC driverɾ³ý£¬È»ºó°²×°MyODBC-3.51.11-1-win.exe
[ɾ³ýÄãµçÄÔÀïµÄ¾É°æMYSQL·þÎñ]
Èç¹ûÄãÊÇȫа²×°£¬¾Í¿ÉÒÔÌø¹ýÕâÒ»²½À²Èç¹ûÄãÒÔǰ°²×°¹ý¾É°æµÄ£¬ÄǾÍÒª¿´¿´ÈçºÎÍêÕû´ÓÄãµÄϵͳÄÚɾ³ýMysqlÔÚÄã´ÓµçÄÔÀïÐ¶ÔØ¾ÉµÄMYSQLÊý¾Ý¿â·þÎñʱ
Ê×ÏÈÏÈÔÚWINDOWS·þÎñÀïÍ£µôMYSQLµÄ·þÎñÔÙµ½¿ØÖÆÃæ°åÀïµÄÔö¼Óɾ³ý³ÌÐòÄÚ½øÐÐɾ³ý£¬µ«ÊÇÄã²¢²»ÄÜÍêÕûµÄ°ÑMYSQL·þÎñɾ³ý£¬ÄÇô¾ÍÒªÔÚ×¢²á±íÀïÇå³ýÄãµÄMYSQL·þÎñÓм¸¸öµØ·½£º(Ó¦¸ÃÓÐÁ½Ï²»¼ÇµÃÀ²£¬´ó¼Ò²é²é°É)
1¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
2¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
3¡¢HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ýÈçÏÂͼËùʾ£º
Çå³ýÍêÒԺ󣬻¹Òª¼ÇµÃ°Ñ C:\WINDOWS\my.ini
Õâ¸öÎļþɾ³ýŶȻºóÖØÐÂÆô¶¯¼ÆËã»úÔÙµ½Äã¼ÆËã»ú·þÎñÀï¿´Ò»ÏÂÊDz»ÊÇMYSQL·þÎñÒѾ²»¼ûÀ²,ºÃÁË¿ÉÒÔ½øÐа²×°Ð°æµÄMYSQLÀ²£¡
[ ¿ªÊ¼°²×°MYSQL 4.1.12 ]
1¡¢ÔËÐÐMYSQL Server 4.1
°²×°°üÈçÏÂͼ£º
2¡¢µã»÷(Change..)Ñ¡Ôñ¸ü¸Ä°²×°Â·¾¶£¬½¨Ò鲻ҪװÔÚCÅÌ£¬ÎÒÖ»ÊÇÔÚ»úÆ÷ÉϲâÊÔ£¬ËùÒÔ¾ÍûÓиü¸Ä£¡
3¡¢¸ü¸ÄÍê·¾¶ºóµã»÷Next£¬½Ó×ŵãInstall¿ªÊ¼°²×°
4¡¢ÎÒÃÇ¿´µ½°²×°½ø¶È£¡
5¡¢Ñ¡ÔñSkip Sign-Up Ïµã»÷Next<¼ÌÐø°²×°!
6¡¢µ½ÕâÀïÎÒÃǰ²×°ÒѾÍê³É£¬Ñ¡ÉÏConfigure the MySQL Server nowºóµã»÷ Finish
½øÈëMysqlµÄÅäÖù¤×÷£º
7¡¢½øÈëMysqlµÄÅäÖýçÃæ£¡
8¡¢Ñ¡ÔñDetailed Configuration Ñ¡Ôñºó£¬µã»÷Next<½øÐÐÏÂÒ»²½!
9¡¢Ñ¡ÔñServer Machine È»ºóµã»÷Next<¼ÌÐø£¡
10¡¢Ñ¡ÔñMultifunctional Database È»ºóµ
Ïà¹ØÎĵµ£º
1¡¢´´½¨mysqlÊý¾Ý¿âµÄ¹ÜÀíÓû§
Êý¾Ý¿â°²×°ºÃºó£¬ÎÒÃÇÓ¦¸ÃΪmysqlÊý¾Ý¿â´´½¨Ò»¸ö¹ÜÀíÕʺš£Òª°ÑrootÓû§ÉèÖÃΪ¹ÜÀíÔ±£¬´ËʱÐèÒªÖ´ÐÐÏÂÃæÃüÁ
[root@CDS2 bin]# /usr/bin/mysqladmin -u root password 123456
˵Ã÷£ºÉÏÃæ´´½¨µÄmysqlÊý¾Ý¿â¹ÜÀíԱΪroot£¬ÃÜÂë123456
2¡¢´´½¨Ò»°ãµÄÓû§
¹¤×÷ÖÐÓõ½web·þÎñÆ÷ºÍmysql·þÎñÆ ......
×÷Õß: ÍõÕßÖ®½£(http://www.albertsong.com/) ÈÕÆÚ: 2008-01-05 22:10
×ÖÌå´óС: С ÖÐ ´ó
ʾÀýÑÝʾÁËÓÃC#²Ù×÷MySQLµÄ·½·¨£¬ÌṩÁËÈý¸ö¿ÉÖØÓõÄÀàMySqlDBUtil,MySqlPageUtil,Page¡£
±¾Ê¾ÀýÓÉ C#²Ù×÷AccessÊý¾Ý¿âµÄ¼òµ¥Àý×Ó£¨http://www.albertsong.com/read-56.html£©Ð޸ĶøÀ´¡£
1.Ê×ÏÈÏÂÔ ......
1.´Óhttp://prdownloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.18.exe?downloadÉÏÏÂÔØMySQLDriverCS.
2.°ÑMySQLDriverCS.dll.Ìí¼Óµ½.netµÄ×é¼þ
3.ʹÓ÷½·¨
ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
using MySQLDriverCS;
MySQLConnection conn ......
mysql> desc aa;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | &n ......
¸ñʽÎļþ .frm ÃèÊö±íµÄ½á¹¹£¨ÁС¢ÁÐÀàÐÍ¡¢Ë÷Òý£¬µÈµÈ£©
Êý¾ÝÎļþ .ISD(ISAM) »ò .MYD (MyISAM) °üº¬±íµÄÊý¾Ý©¤¼´ËüµÄÐÐ
Ë÷ÒýÎļþ ISD(ISAM) »ò .MYI (MyISAM) °üº¬Êý¾ÝÎļþÖÐÈκÎË÷ÒýµÄË÷ÒýÊ÷¡£ÎÞÂ۸ñíÓÐÎÞË÷Òý£¬Ë÷ÒýÎļþ¶¼´æÔÚ
......