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

ubuntu mysqlµÄ°²×°

sudo apt-get install mysql-server
Õâ¸öÓ¦¸ÃºÜ¼òµ¥ÁË£¬¶øÇÒÎÒ¾õµÃ´ó¼ÒÔÚ°²×°·½ÃæҲûʲô̫´óÎÊÌ⣬ËùÒÔÒ²¾Í²»¶à˵ÁË£¬ÏÂÃæÎÒÃÇÀ´½²½²ÅäÖá£
ÅäÖÃMySQL
×¢Ò⣬ÔÚUbuntuÏÂMySQLȱʡÊÇÖ»ÔÊÐí±¾µØ·ÃÎʵģ¬Èç¹ûÄãÒªÆäËû»úÆ÷Ò²Äܹ»·ÃÎʵĻ°£¬ÄÇôÐèÒª¸Ä±ä/etc/mysql/my.cnfÅäÖÃÎļþÁË£¡ÏÂÃæÎÒÃÇÒ»²½²½µØÀ´£º
ĬÈϵÄMySQL°²×°Ö®ºó¸ùÓû§ÊÇûÓÐÃÜÂëµÄ£¬ËùÒÔÊ×ÏÈÓøùÓû§½øÈ룺
$mysql -u root
ÔÚÕâÀïÖ®ËùÒÔÓÃ-u rootÊÇÒòΪÎÒÏÖÔÚÊÇÒ»°ãÓû§£¨firehare£©£¬Èç¹û²»¼Ó-u rootµÄ»°£¬mysql»áÒÔΪÊÇfirehareÔڵǼ¡£×¢Ò⣬ÎÒÔÚÕâÀïûÓнøÈë¸ùÓû§Ä£Ê½£¬ÒòΪû±ØÒª¡£Ò»°ãÀ´Ëµ£¬¶ÔmysqlÖеÄÊý¾Ý¿â½øÐвÙ×÷£¬¸ù±¾Ã»±ØÒª½øÈë¸ùÓû§Ä£Ê½£¬Ö»ÓÐÔÚÉèÖÃʱ²ÅÓÐÕâÖÖ¿ÉÄÜ¡£
½øÈëmysqlÖ®ºó£¬×îÒª½ôµÄ¾ÍÊÇÒªÉèÖÃMysqlÖеÄrootÓû§ÃÜÂëÁË£¬·ñÔò£¬Mysql·þÎñÎÞ°²È«¿ÉÑÔÁË¡£
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";
×¢Ò⣬ÎÒÕâ¶ùÓõÄÊÇ123456×öΪrootÓû§µÄÃÜÂ룬µ«ÊǸÃÃÜÂëÊDz»°²È«µÄ£¬Çë´ó¼Ò×îºÃʹÓôóСд×ÖĸÓëÊý×Ö»ìºÏµÄÃÜÂ룬ÇÒ²»ÉÙÓÚ8λ¡£
ÕâÑùµÄ»°£¬¾ÍÉèÖúÃÁËMySQLÖеÄrootÓû§ÃÜÂëÁË£¬È»ºó¾ÍÓÃrootÓû§½¨Á¢ÄãËùÐèÒªµÄÊý¾Ý¿â¡£ÎÒÕâÀï¾ÍÒÔxoopsΪÀý£º
mysql>CREATE DATABASE xoops£»
mysql>GRANT ALL PRIVILEGES ON xoops.* TO xoops_root@localhost IDENTIFIED BY "654321";
ÕâÑù¾Í½¨Á¢ÁËÒ»¸öxoops_rootsµÄÓû§£¬Ëü¶ÔÊý¾Ý¿âxoopsÓÐ×ÅÈ«²¿È¨ÏÞ¡£ÒÔºó¾ÍÓÃxoops_rootÀ´¶ÔxoopsÊý¾Ý¿â½øÐйÜÀí£¬¶øÎÞÐèÒªÔÙÓÃrootÓû§ÁË£¬¶ø¸ÃÓû§µÄȨÏÞÒ²Ö»±»ÏÞ¶¨ÔÚxoopsÊý¾Ý¿âÖС£
Èç¹ûÄãÏë½øÐÐÔ¶³Ì·ÃÎÊ»ò¿ØÖÆ£¬ÄÇôÄãÒª×öÁ½¼þÊ£º
ÆäÒ»£º
mysql>GRANT ALL PRIVILEGES ON xoops.* TO xoops_root@"%" IDENTIFIED BY "654321";
ÔÊÐíxoops_rootÓû§¿ÉÒÔ´ÓÈÎÒâ»úÆ÷ÉϵÇÈëMySQL¡£
Æä¶þ£º
$sudo gedit /etc/mysql/my.cnf
Àϵİ汾ÖÐ
>skip-networking => # skip-networking
еİ汾ÖÐ
>bind-address=127.0.0.1 => bind-address= Äã»úÆ÷µÄIP
ÕâÑù¾Í¿ÉÒÔÔÊÐíÆäËû»úÆ÷·ÃÎÊMySQLÁË¡£


Ïà¹ØÎĵµ£º

ÔõÑù½â¾ömysqlµÄtoo many connectionsÎÊÌâ?

¿ÉÒԲο¼ÏÂÁÐÎÄÕÂ
http://www.mysqlperformanceblog.com/2010/03/23/too-many-connections-no-problem/
½áÂÛÈçÏ£º
£¨1£©mysqlĬÈÏ»á¸øsuperÓû§ÁôÒ»¸öÁ¬½Ó£¬Äã¿ÉÒÔÓÃÕâ¸öÔ¤ÁôµÄÁ¬½ÓÀ´µÇ¼£¬À´Ôö¼ÓÁ¬½ÓÊý£»µ«ÊÇÈç¹ûÁ¬½ÓµÄÓû§È«ÊÇsuperȨÏ޵ģ¬ÔòÕâ¸öÔ¤ÁôµÄÁ¬½Ó²»´æÔÚ¡£Õâʱ¿ÉÒÔÓÃÒÔϵÄÃüÁîÀ´ÉèÖÃÁ¬½ÓÊý£ºgdb -p $(cat ......

mysql Óï¾äÓÅ»¯²éѯ

ÎÒÓõÄÊÇmysql5.0£¬
ÎÒ³ÌÐòÖÐÓõ½ÁËÒ»¾äsqlÊÇ
SQL code
select count(DISTINCT id) from Policyinfo p where p.filename not in
(select p2.filename from Policyreadinfo p2 where p2.reader='test')
µ«ÊÇÿ´ÎÔÚ³ÌÐòÖÐÿ´ÎÖ´ÐÐÕâ¾äsqlʱÍøÒ³¾ÍÌØÂý£¬Òª10¶àÃ룬¶øÕâ2¸ö±íµÄ¼Ç¼ÐÐÊýÒ²¾Í1000¶à¶øÒÑ£¬ÎÒ°ÑÕâ¾äsqlµ¥¶ÀÄ ......

Nginx+PHP+MySQLË«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½°¸

ÔÚÉú²úÓ¦ÓÃÖУ¬Ä³Ì¨“Nginx+PHP+MySQL”½Ó¿ÚÊý¾Ý·þÎñÆ÷£¬°çÑݵĽÇÉ«Ê®·ÖÖØÒª£¬Èç¹û·þÎñÆ÷Ó²¼þ»òNginx¡¢MySQL·¢Éú¹ÊÕÏ£¬¶ø ¶Ìʱ¼äÄÚÎÞ·¨»Ö¸´£¬ºó¹û½«·Ç³£ÑÏÖØ¡£ÎªÁ˱ÜÃâµ¥µã¹ÊÕÏ£¬ÎÒÉè¼ÆÁË´ËÌ×·½°¸£¬±àдÁËfailover.sh½Å±¾£¬ÊµÏÖÁËË«»ú»¥±¸¡¢È«×Ô¶¯Çл»£¬¹ÊÕÏתÒÆʱ¼ä Ö»Ð輸ʮÃë¡£
Ò»¡¢Ë«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½°¸ ......

ÀûÓÃMySQLµÄÒ»¸öÌØÐÔʵÏÖMySQL²éѯ½á¹ûµÄ·ÖÒ³ÏÔʾ

ÔÚmysqlÖÐÀûÓÃselectÓï¾äµÄÒ»¸öÌØÐԾͿÉÒԺܷ½±ãµØʵÏÖ²éѯ½á¹ûµÄ·ÖÒ³£¬selectÓï¾äµÄÓï·¨£º
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO OUTFILE 'file_name'&nb ......

mysql ´´½¨Óû§·½·¨

ÃüÁʽµÄ.×¢ÒâÿÐкó±ß¶¼¸ú¸ö £» ±íʾһ¸öÃüÁîÓï¾ä½áÊø.
¸ñʽ£ºgrant select on Êý¾Ý¿â.* to
Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
Àý1¡¢Ôö¼ÓÒ»¸öÓû§test1ÃÜÂëΪabc£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔ
rootÓû§Á¬ÈëMYSQL
£¬
È»ºó¼üÈëÒÔÏÂÃüÁ
gr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ