MySQLÊý¾Ý¿âÏê½â
´Ó±¾Æª²©ÎÄ¿ªÊ¼£¬ÎÒÃǾÍÒªÉîÈëµ½PHPµÄÓ¦Óõ±ÖÐÈ¥ÁË¡£PHPµÄÊý¾Ý¿âÓ¦ÓÃÊÇÖØÖÐÖ®ÖØ£¬±ØÐëÕÆÎÕ¡£Ñ¡ÔñʲôÑùµÄÊý¾Ý¿âÄØ£¬µ±È»ÊÇÎÒÃǵÄMySQLÀ²£¬Ã»ÓÐÈË»áȥʹÓÃÄÇЩÅÓ´ó¡¢µÍЧ¶øÓÖ°º¹óµÄÉÌÒµÊý¾Ý¿âÀ´¹¹½¨PHPÓ¦Óðɡ£
1 MySQLÊý¾Ý¿âµÄ°²×°
¹ýÈ¥£¬°²×°Ò»¸öMySQLÊý¾Ý¿â²¢ÇÒÒªÆô¶¯ÆðÀ´ºÜ·ÑÊ£¬ÌرðÊÇÔÚLinuxÕâÑùµÄ¿ª·¢»·¾³Ï£¬ÐèÒª¸üкܶàÀà¿â»òÕ߯äËû¶«¶«¡£²»¹ý£¬ÏÖÔÚÓÐÁËLAMP¼Ü¹¹£¬Ò»Çо¡ÔÚÕÆÎÕ£¡
Çë´Ó Apache Friends Web Õ¾µãÉÏÏÂÔØ×îеĶþ½øÖÆÎļþ²¢½øÐнâ°ü£º
xampp-linux-1.7.3.tar.gz¡£
http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/1.7.3/xampp-linux-1.7.3.tar.gz/download
ʹÓÃÏÂÃæµÄÃüÁÆä½â¿ªµ½ /opt Ŀ¼ÖУº
tar xvfz xampp-linux-1.7.2.tar.gz
½âѹºó³öÏÖlamppÎļþ¼Ð£¬Ò»¶¨Òª½«lampp·Åµ½/opt ÏÂÃæ£¨·ñÔò²»ÄÜÆô¶¯£©¡£ÏÖÔÚËùÓеÄÈí¼þ¶¼ÒѾ°²×°ºÃÁË£¬ÈÃÎÒÃÇÆô¶¯ÐµÄÊØ»¤½ø³Ì¡£½«µ±Ç°µÄ¹¤×÷Ŀ¼Çл»µ½ /opt/lampp £¨ cd /opt/lampp£©²¢ÊäÈëÏÂÃæµÄÃüÁ
./lampp start
Æô¶¯ÆðÀ´ºó£¬ÎÒÃǾͿÉÒÔʹÓÃÆäÖеÄMySQLÄ£¿éÁË£º
# cd /opt/lampp/bin
# ./mysql
mysql>
2 ÐÞ¸ÄmysqlÃÜÂë
# ./mysqladmin -u root password 'new-password'
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
Àý1£º¸øroot¼Ó¸öÃÜÂë123456¡£
¡¡¡¡¼üÈëÒÔÏÂÃüÁî £º
¡¡¡¡ /opt/lampp/bin/mysqladmin -u root password 123456
¡¡¡¡×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£²âÊÔÊÇ·ñÐ޸ijɹ¦£º
1£©²»ÓÃÃÜÂëµÇ¼
# ./mysql
2£©ÓÃÐ޸ĺóµÄÃÜÂëµÇ¼
# ./mysql -u root -p
¡¡¡¡Enter password: (ÊäÈëÐ޸ĺóµÄÃÜÂë123456)
¡¡¡¡Welcome to the MySQL monitor.¡¡Commands end with ; or \g.
¡¡¡¡Your MySQL connection id is 4 to server version: 4.0.16-standard
¡¡¡¡Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
¡¡¡¡mysql>
¡¡¡¡³É¹¦£¡
3)Í˳ömysqlÃüÁexit£¨»Ø³µ£©
3 Êý¾Ý¿âºÍ±íµÄ²Ù×÷
mysql> show databases;
ÏÔʾÈçÏÂÐÅÏ¢£º
+---------------------+
| Database |
+---------------------+
| information_schema |
| cluster_replication |
| mysql |
| test &nbs
Ïà¹ØÎĵµ£º
ISAM
ISAMÊÇÒ»¸ö¶¨ÒåÃ÷È·ÇÒÀú¾Ê±¼ä¿¼ÑéµÄÊý¾Ý±í¸ñ¹ÜÀí·½·¨£¬ËüÔÚÉè¼ÆÖ®Ê±¾Í¿¼Âǵ½Êý¾Ý¿â±»²éѯµÄ´ÎÊýÒªÔ¶´óÓÚ¸üеĴÎÊý¡£Òò´Ë£¬ISAMÖ´ÐжÁÈ¡²Ù×÷µÄËٶȺܿ죬¶øÇÒ²»Õ¼ÓôóÁ¿µÄÄÚ´æºÍ´æ´¢×ÊÔ´¡£ISAMµÄÁ½¸öÖ÷Òª²»×ãÖ®´¦ÔÚÓÚ£¬Ëü²»Ö§³ÖÊÂÎñ´¦Àí£¬Ò²²»Äܹ»ÈÝ´í£ºÈç¹ûÄãµÄÓ²Å̱ÀÀ£ÁË£¬ÄÇôÊý¾ÝÎļþ¾ÍÎÞ·¨»Ö¸´ÁË¡£Èç¹ûÄãÕýÔÚ°Ñ ......
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕÍ¨ÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔØºÃµÄ“apache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃæ£º
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃæ£¬µã“Next”¼ÌÐø
È·È ......
ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡£
......
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......
MysqlÖеÄÊÂÎñ¿ÉÒÔÔËÐÐÔÚÏÂÃæ4¸öisolation levelÖУ¬Ó°Ïì×Åselect²Ù×÷µÄ½á¹û£º
1. Read Uncommitted
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñûÓÐÌá½»µÄÄÚÈÝ
2. Read Committed
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñÒѾÌá½»µÄÄÚÈÝ
3. Repeatable Read
InnoDBµÄĬÈÏlevel£¬¿ÉÒÔÈ·±££¬ÔÚÊÂÎñÖÐÿ´ÎÖ´ÐеĶÁ²Ù×÷·µ»ØµÄ½á¹û¶¼ÓëµÚÒ»´ÎʱµÄÒ»ÖÂ
4. Seriali ......