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

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ÂÒÂë²úÉúµÄÔ­Òò£º
    ²úÉú´ËÀàÎÊÌâµÄ×î¿ÉÄÜÊÇÄãµÄÊý¾Ý¿âÔÚ°²×°Ê±Ã»ÓÐÑ¡¶Ô×Ö·û¼¯£¬Õâ¸öÊ®·ÖÖØÒª.
    Äã¿ÉÒÔͨ¹ýÈçϵķ½Ê½À´²é¿´£º´ò¿ªMysql´°¿Ú£¬ÔÚ´°¿ÚµÄ×î×óÉϽǵã»÷Êó±êÓÒ¼ü£¬Ñ¡ÔñÊôÐÔ£¬¾Í¿ÉÒÔ¿´µ½ÄãĬÈϵÄ×Ö·û±àÂëÁË£¨ÈçÏÂͼ£©£º
    ......

ORACLE Óë mysql µÄÇø±ð

1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow
databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚ
ORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿É ......

mysql²é¿´Êý¾Ý¿â´óС£¬Ë÷Òý´óС

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)
½âÊÍ£º
......

MysqlÖд´½¨Óû§ÕÊ»§µÄ·½·¨

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ