MySQLÊý¾Ý¿âµÄ¼òµ¥²Ù×÷
MySQLÊý¾Ý¿âµÄ¼òµ¥²Ù×÷
Ò».´´½¨Êý¾Ý¿â ͨ¹ýshow databases;ÃüÁîÏÔʾËùÓÐÒÑ´´½¨µÄÊý¾Ý¿âµÄÃû³Æ¡£
ͨ¹ýcreate database XXX;´´½¨Êý¾Ý¿âÃûΪXXXµÄÊý¾Ý¿â¡£ ÀýÈ磺mysql>create database test; ¶þ.´´½¨±íµ¥ ͨ¹ýcreate table XXX();´´½¨ ÀýÈç: È»ºó¿ÉÒÔͨ¹ýdescÃüÁî²é¿´±íµ¥: ÀýÈç: Èý.²åÈëÊý¾Ý ͨ¹ýinsert into XXX values( , );À´Íê³É²åÈë¹ý³Ì¡£È»ºóͨ¹ýselectÃüÁî²é¿´±íµ¥µÄ¾ßÌåÐÅÏ¢¡£ ÀýÈç: ËÄ.¸üÐÂÊý¾Ý ͨ¹ýupdate XXX set XX=XX where XX=XX;À´Íê³É±íµ¥µÄ¸üС£ ÀýÈç: Îå.ɾ³ýÊý¾Ý ͨ¹ýdelete from XXX where XX=XX;ÃüÁîÀ´É¾³ýÊý¾Ý¡£ ÀýÈç: Áù.ɾ³ýÊý¾Ý¿â ͨ¹ýdrop database XXX;À´É¾³ýÊý¾Ý¿â¡£ ÀýÈç:
Ïà¹ØÎĵµ£º
°æÈ¨ÉùÃ÷£º¿ÉÒÔÈÎÒâ×ªÔØ£¬×ªÔØÊ±ÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷
http://www.5ilinux.com/lamp01.html
¹Ø¼ü×Ö£ºapache+mysql+php apache mysql php ÅäÖà lamp ·þÎñÆ÷ web
Linux+Apache+Mysql+PHPµäÐÍÅäÖÃ
µ÷ÊÔ»·¾³£ºRedhat9.0 Apache1.3.29 Mysql3.23.58 PHP4.3.4
LinuxϵͳµÄ°²×°ÎҾͲ»½²Á ......
×î½üÒ»Ö±ÔÚ½øÐÐPenroseÁ¬½ÓMysqlµÄ³¢ÊÔ£¬¿É×ÜÊÇÌáʾÎÞ·¨Á¬½Óµ½Mysql£¬ÎÞÂÛÊǼì²é¶Ë¿ÚÊÇ·ñ¿ªÆô£¬ÉèÖÃMysqlÔ¶³Ì·ÃÎÊȨÏ޵ȶ¼²»¹ÜÓ㬺óÀ´ÔÚPenroseµÄ¹ÙÍøÕÒµ½Ò»¸ö½¨Á¢ÑùÀýÊý¾Ý¿â¼°ÉèÖÃÔ¶³ÌÁ¬½ÓµÄÎĵµ£¬Ã»Ïëµ½Ò»¾Ù³É¹¦£¬Í´¿ì°¡£¡
ÏÂÃæ¾Í°ÑÎĵµºÍ´ó¼Ò¹²Ïíһϣ¡£¨ÊÇÓ¢ÎÄ£¬´ó¼Ò¾Í´ÕºÏ×Å¿´Ï°ɣ¡ÒòΪ×î½ü¸ãPenroseÌ«ÀÛÁË£¬ ......
1. ʹÓÃGRANTÓï¾äÌí¼Ó£ºÊ×ÏÈÔÚÊý¾Ý¿â±¾»úÉÏÓÃROOTÓû§
µÇ¼MySql£¨ÎÒÊÇÓÃÔ¶³Ì¿ØÖÆlinux·þÎñÆ÷£¬Ï൱ÓÚÔÚ·þÎñÆ÷±¾»úµÇ¼MySqlÁË£©£¬È»ºóÊäÈ룺
mysql>GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY 'something' WITH GRANT OPTION;
Ìí¼ÓÒ»¸öÓû§admin²¢ÊÚȨͨ¹ý±¾µØ»ú£¨localhost)·ÃÎÊ£¬ÃÜÂë“s ......
ĿǰÓв»ÉÙAMP£¨Apache\MySQL\PHP£©µÄ¼¯³ÉÈí¼þ£¬¿ÉÒÔÈÃÎÒÃÇÒ»´Î°²×°²¢ÉèÖúá£Õâ¶ÔÓÚ²»ÊìϤAMPµÄÓû§À´Ëµ£¬ºÃ´¦¶à¶à¡£
Ò»¡¢Ê¹ÓÃAMP¼¯³ÉÈí¼þµÄÓŵ㣺
1¡¢¿É±ÜÃâÓÉÓÚȱ·¦AMPµÄ֪ʶ£¬¶øÎÞ·¨ÕýÈ·ÉèÖû·¾³£»
2¡¢¿É¿ìËÙ°²×°²¢ÉèÖúÃAMP»·¾³£¬ÈÃÎÒÃÇÖ±½Ó¿ªÊ¼ÕæÕý¸ÐÐËȤµÄÈí¼þ£¬Èçxoops£»
3¡¢¿É·½±ãµÄ´î½¨²âÊÔ»·¾³£¬¶ÔÓÚ² ......
µÚÒ»²½£ºÐÞ¸ÄÊý¾Ý¿âÅäÖÃÎļþmy.ini
¿Í»§¶ËµÄĬÈÏ×Ö·û±àÂ룺
default-character-set=utf8
·þÎñÆ÷¶ËµÄĬÈÏ×Ö·û±àÂë
default-character-set=utf8
µÚ¶þ²½£ºÖØÐÂÆô¶¯mysqlÊý¾Ý¿â
net stop mysql
net start mysql
µÚ¶þ²½£ºÐÞ¸ÄapplicationContent.xml
ÐÞ¸ÄurlÊôÐÔ£¬½«Æä¸ÄΪ£ºjdbc:mysql://localhost:3306/member?useUni ......