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 È»ºóµ
Ïà¹ØÎĵµ£º
MysqlÂÒÂë²úÉúµÄÔÒò£º
²úÉú´ËÀàÎÊÌâµÄ×î¿ÉÄÜÊÇÄãµÄÊý¾Ý¿âÔÚ°²×°Ê±Ã»ÓÐÑ¡¶Ô×Ö·û¼¯£¬Õâ¸öÊ®·ÖÖØÒª.
Äã¿ÉÒÔͨ¹ýÈçϵķ½Ê½À´²é¿´£º´ò¿ªMysql´°¿Ú£¬ÔÚ´°¿ÚµÄ×î×óÉϽǵã»÷Êó±êÓÒ¼ü£¬Ñ¡ÔñÊôÐÔ£¬¾Í¿ÉÒÔ¿´µ½ÄãĬÈϵÄ×Ö·û±àÂëÁË£¨ÈçÏÂͼ£©£º
......
1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow
databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚ
ORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿É ......
mysql> use information_schema
Database changed
mysql> select concat(round(sum(index_LENGTH)/(1024*1024),2),'MB') as 'Data Size' from tables where table_schema='bbs';
+-----------+
| Data Size |
+-----------+
| 0.00MB |
+-----------+
1 row in set (0.01 sec)
½âÊÍ£º
......
1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......