Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ¡°SET NAMES x¡±×Ö·û¼¯ÎÊÌâ·ÖÎö

MySQLµÄ×Ö·û¼¯ÎÊÌâ¡£WindowsÏ¿Éͨ¹ýÐÞ¸Ämy.iniÄÚµÄ
CODE:
# CLIENT SECTION
[mysql]
default-character-set=utf8
#
SERVER SECTION
[mysqld]
default-character-set=utf8
Õâ
Á½¸ö×Ö¶ÎÀ´¸ü¸ÄÊý¾Ý¿â
µÄ
ĬÈÏ×Ö·û¼¯¡£µÚÒ»¸öÊǿͻ§¶ËĬÈϵÄ×Ö·û¼¯£¬µÚ¶þ¸öÊÇ·þÎñÆ÷¶ËĬÈϵÄ×Ö·û¼¯¡£¼ÙÉèÎÒÃǰÑÁ½¸ö¶¼ÉèΪutf8£¬È»ºó ......

MYSQLÓÅ»¯ÐĵÃ

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½Óɿͻ§¶Ë·¢À´µÄSQLÓï¾äºó£¬ Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ ......

ÀûÓÃ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ѧϰ±Ê¼Ç(Ò»)

¸ßÐÔÄÜMySqlѧϰ±Ê¼Ç
1.Õë¶ÔÓ¦Óý¨Á¢×Ô¼ºµÄË÷Òý
URL²éÕÒÀý×Ó
    select * from tUrl where url='http://www.163.com';
ÒÔurl£¨×Ö·û´®£©×÷ÐÐΪË÷Òý»áʹµÃ×÷ΪË÷Òý½á¹¹µÄB-Tree±ä´ó£¬¿ÉÒÔÒÆ³ýurlÁÐÉϵÄË÷Òý£¬²¢Ìí¼ÓÒ»¸öurl_crcË÷ÒýÁУ¬
ÏȽ¨Á¢±í£º
create tables tUrl(
     ......

MySQL 5.1ÍêÈ«Ð¶ÔØ

1¡¢¿ØÖÆÃæ°åÀïµÄÔö¼Óɾ³ý³ÌÐòÄÚ½øÐÐɾ³ý
2¡¢É¾³ýMySQLÎļþ¼ÐϵÄmy.iniÎļþ£¬Èç¹û±¸·ÝºÃ£¬¿ÉÒÔÖ±½Ó½«Îļþ¼ÐÈ«²¿É¾³ý
3¡¢¿ªÊ¼->ÔËÐÐ-> regedit ¿´¿´×¢²á±íÀïÕ⼸¸öµØ·½É¾³ýûÓÐ
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL Ŀ¼ɾ³ý
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ