½â¾ö ubuntu ÉϵÄmysqlÎÞ·¨Ô¶³Ì·ÃÎÊ
ÔÚUbuntu9.10ÉÏʹÓÃsudo apt-get install mysql-server-5.0 °²×°ÁËmysql£¬ÔÚÍâÃæ·ÃÎʲ»ÁËmysql,µ«ÊÇÔÚUbuntuÉÏ·ÃÎÊÊÇûÓÐÎÊÌâµÄ¡£
ÓÚÊÇ¿ªÊ¼²éÕÒÔÒò£º
3306¶Ë¿ÚÊDz»ÊÇûÓдò¿ª£¿
ʹÓÃnestatÃüÁî²é¿´3306¶Ë¿Ú״̬£º
~# netstat -an | grep 3306
tcp 0 0
127.0.0.1:3306 0.0.0.0:* LISTEN
´Ó½á¹û¿ÉÒÔ¿´³ö3306¶Ë¿ÚÖ»ÊÇÔÚIP 127.0.0.1ÉϼàÌý£¬ËùÒԾܾøÁËÆäËûIPµÄ·ÃÎÊ¡£
½â¾ö·½·¨
£ºÐÞ¸Ä/etc/mysql/my.cnfÎļþ¡£
´ò¿ª
Îļþ£¬ÕÒµ½ÏÂÃæÄÚÈÝ£º
# Instead of skip-networking the default is now to listen only on
#
localhost which is more compatible and is not less secure.
bind-address =
127.0.0.1
°ÑÉÏÃæÕâÒ»ÐÐ×¢Ê͵ô»òÕß°Ñ127.0.0.1»»³ÉºÏÊʵÄIP£¬½¨Òé×¢Ê͵ô¡£
ÖØÐÂÆô¶¯ºó£¬ÖØÐÂʹÓÃnetstat¼ì²â£º
~# netstat -an | grep 3306
tcp
0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
ÎÊÌâ½â¾ö
Ïà¹ØÎĵµ£º
Äê³õµÄʱºòÒ»Ö±ÔÚ×öÒ»¸öÍøÕ¾MSSQL2000->MySQL5µÄÇ¨ÒÆ¹¤×÷£¬ÒòΪ²ÉÓÃÁ˲»Í¬µÄ³ÌÐòϵͳ£¬ËùÒÔÖ÷ÒªÎÊÌâÔÚÊý¾ÝµÄÇ¨ÒÆ¡£ÓÉÓÚ2¸öϵͳÊý¾Ý¿â½á¹¹²îÒì·Ç³£´ó£¬²»·½±ã²ÉÈ¡SQLSERVERÀïµ¼ÈëMYSQLµÄODBCÊý¾ÝÔ´µÄ¹¦ÄÜ£¨Ò²²»ÍƼöÕâô×ö£¬×Ö¶ÎÀàÐ͵Ȳ»Í¬µã»á¸ãËÀÈ˵ġ«£©£¬Òò´Ë¾ÍÔÚWINDOWSÏÂ×Ô¼ºÐ´PHP½Å±¾´ÓSQLSERVERÀï¶ÁÊý¾Ý£¬È»ºó°´ÕÕ ......
ÔÚÈÕ³£µÄ¹¤×÷ÖУ¬±£»¤Êý¾ÝÃâÊÜδÊÚȨÓû§µÄÇÖ·¸ÊÇϵͳ¹ÜÀíÔ±ÌØ±ð¹ØÐĵÄÎÊÌâ¡£Èç¹ûÄãĿǰÓõÄÊÇMySQL£¬¾Í¿ÉÒÔʹÓÃһЩ·½±ãµÄ¹¦ÄÜÀ´±£»¤ÏµÍ³£¬À´´ó´ó¼õÉÙ»úÃÜÊý¾Ý±»Î´ÊÚȨÓû§·ÃÎʵķçÏÕ¡£
ÆóÒµ×îÓмÛÖµµÄ×ʲúͨ³£ÊÇÆäÊý¾Ý¿âÖеĿͻ§»ò²úÆ·ÐÅÏ¢¡£Òò´Ë£¬ÔÚÕâЩÆóÒµÖУ¬Êý¾Ý¿â¹ÜÀíµÄÒ»¸öÖØÒª²¿·Ö¾ÍÊDZ£»¤ÕâЩÊý¾ÝÃâÊÜÍⲿ¹¥»÷£ ......
mysql ´´½¨ Êý¾Ý¿âʱָ¶¨±àÂëºÜÖØÒª£¬ºÜ¶à¿ª·¢Õß¶¼Ê¹ÓÃÁËĬÈϱàÂ룬µ«ÊÇÎÒʹÓõľÑéÀ´¿´£¬Öƶ¨Êý¾Ý¿âµÄ±àÂë¿ÉÒԺܴó³Ì¶ÈÉϱÜÃâµ¹Èëµ¼³ö´øÀ´µÄÂÒÂëÎÊÌâ¡£
ÎÒÃÇ×ñѵıê×¼ÊÇ£¬Êý¾Ý¿â£¬±í£¬×ֶκÍÒ³Ãæ»òÎı¾µÄ±àÂëҪͳһÆðÀ´
ºÜ¶àmysqlÊý¾Ý¿â¹¤¾ß£¨³ýÁËphpmyadmin£¬ÎÒż¶ûÓ㬹¦ÄÜÇ¿ËÙ¶ÈÂý£©¶¼²»Ö§³Ö´´½¨Ê±Ö¸¶¨Êý¾Ý¿â±àÂ룬 ......
´æ´¢ÒýÇæ Ö§³ÖË÷Òý myisam b-tree,r-tree,full-text,²»Ö§³Öhash innodb b-tree(clustered-index) merge b-tree,r-tree memory b-tree,hash archive ÎÞË÷Òý ......