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

MySQLÅäÖÃÎļþmy.cnfÖÐÎİæ

À´×Ô: http://www.phpv.net/html/1666.html
#BEGIN CONFIG INFO
#DESCR: 4GB RAM, ֻʹÓÃInnoDB, ACID, ÉÙÁ¿µÄÁ¬½Ó, ¶ÓÁиºÔØ´ó
#TYPE: SYSTEM
#END CONFIG INFO
#
# ´ËmysqlÅäÖÃÎļþÀý×ÓÕë¶Ô4GÄÚ´æ
# Ö÷ҪʹÓÃINNODB
#´¦Àí¸´ÔÓ¶ÓÁв¢ÇÒÁ¬½ÓÊýÁ¿½ÏÉÙµÄmysql·þÎñÆ÷
#
# ½«´ËÎļþ¸´ÖƵ½/etc/my.cnf ×÷Ϊȫ¾ÖÉèÖÃ,
# mysql-data-dir/my.cnf ×÷Ϊ·þÎñÆ÷Ö¸¶¨ÉèÖÃ
# (@localstatedir@ for this installation) »òÕß·ÅÈë
# ~/.my.cnf ×÷ΪÓû§ÉèÖÃ.
#
# ÔÚ´ËÅäÖÃÎļþÖÐ, Äã¿ÉÒÔʹÓÃËùÓгÌÐòÖ§³ÖµÄ³¤Ñ¡Ïî.
# Èç¹ûÏë»ñϤ³ÌÐòÖ§³ÖµÄËùÓÐÑ¡Ïî
# ÇëÔÚ³ÌÐòºó¼ÓÉÏ"--help"²ÎÊýÔËÐгÌÐò.
#
# ¹ØÓÚ¶ÀÁ¢Ñ¡Ïî¸ü¶àµÄϸ½ÚÐÅÏ¢¿ÉÒÔÔÚÊÖ²áÄÚÕÒµ½
#
#
# ÒÔÏÂÑ¡Ïî»á±»MySQL¿Í»§¶ËÓ¦ÓöÁÈ¡.
# ×¢ÒâÖ»ÓÐMySQL¸½´øµÄ¿Í»§¶ËÓ¦ÓóÌÐò±£Ö¤¿ÉÒÔ¶ÁÈ¡Õâ¶ÎÄÚÈÝ.
# Èç¹ûÄãÏëÄã×Ô¼ºµÄMySQLÓ¦ÓóÌÐò»ñÈ¡ÕâЩֵ
# ÐèÒªÔÚMySQL¿Í»§¶Ë¿â³õʼ»¯µÄʱºòÖ¸¶¨ÕâЩѡÏî
#
[client]
#password = [your_password]
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# *** Ó¦Óö¨ÖÆÑ¡Ïî ***
#
#  MySQL ·þÎñ¶Ë
#
[mysqld]
# Ò»°ãÅäÖÃÑ¡Ïî
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# back_log ÊDzÙ×÷ϵͳÔÚ¼àÌý¶ÓÁÐÖÐËùÄܱ£³ÖµÄÁ¬½ÓÊý,
# ¶ÓÁб£´æÁËÔÚMySQLÁ¬½Ó¹ÜÀíÆ÷Ï̴߳¦Àí֮ǰµÄÁ¬½Ó.
# Èç¹ûÄãÓзdz£¸ßµÄÁ¬½ÓÂʲ¢ÇÒ³öÏÖ"connection refused" ±¨´í,
# Äã¾ÍÓ¦¸ÃÔö¼Ó´Ë´¦µÄÖµ.
# ¼ì²éÄãµÄ²Ù×÷ϵͳÎĵµÀ´»ñÈ¡Õâ¸ö±äÁ¿µÄ×î´óÖµ.
# Èç¹û½«back_logÉ趨µ½±ÈÄã²Ù×÷ϵͳÏÞÖÆ¸ü¸ßµÄÖµ,½«»áûÓÐЧ¹û
back_log = 50
# ²»ÔÚTCP/IP¶Ë¿ÚÉϽøÐмàÌý.
# Èç¹ûËùÓеĽø³Ì¶¼ÊÇÔÚͬһ̨·þÎñÆ÷Á¬½Óµ½±¾µØµÄmysqld,
# ÕâÑùÉèÖý«ÊÇÔöÇ¿°²È«µÄ·½·¨
# ËùÓÐmysqldµÄÁ¬½Ó¶¼ÊÇͨ¹ýUnix sockets »òÕßÃüÃû¹ÜµÀ½øÐеÄ.
# ×¢ÒâÔÚwindowsÏÂÈç¹ûûÓдò¿ªÃüÃû¹ÜµÀÑ¡Ïî¶øÖ»ÊÇÓôËÏî
# (ͨ¹ý "enable-named-pipe" Ñ¡Ïî) ½«»áµ¼ÖÂmysql·þÎñûÓÐÈκÎ×÷ÓÃ!
#skip-networking
# MySQL ·þÎñËùÔÊÐíµÄͬʱ»á»°ÊýµÄÉÏÏÞ
# ÆäÖÐÒ»¸öÁ¬½Ó½«±»SUPERȨÏÞ±£Áô×÷Ϊ¹ÜÀíÔ±µÇ¼.
# ¼´±ãÒѾ­´ïµ½ÁËÁ¬½ÓÊýµÄÉÏÏÞ.
max_connections = 100
# ÿ¸ö¿Í»§¶ËÁ¬½Ó×î´óµÄ´íÎóÔÊÐíÊýÁ¿,Èç¹û´ïµ½ÁË´ËÏÞÖÆ.
# Õâ¸ö¿Í»§¶Ë½«»á±»MySQL·þÎñ×èÖ¹Ö±µ½Ö´ÐÐÁË"FLUSH HOSTS" »òÕß·þÎñÖØÆô
# ·Ç·¨µÄÃÜÂëÒÔ¼°ÆäËûÔÚÁ´½ÓʱµÄ´íÎó»áÔö¼Ó´ËÖµ.
# ²é¿´ "Aborted_connects" ״̬À´»ñȡȫ¾Ö¼ÆÊýÆ÷.
max


Ïà¹ØÎĵµ£º

mysql root ÃÜÂëÍü¼Ç£¿£¿£¿£¿

½ñÌì¸øÐÂÀ´µÄÔ±¹¤Á¬½ÓÊý¾Ý¿â£¬ÐÞ¸ÄÁËÒ»ÏÂmysql rootÓû§µÄÃÜÂ룬ÎÒÏÂÔØµÄÊÇ´ò°üµÄredMine£¬Ä¬ÈÏÃÜÂëÊǿգ¬ÐÞ¸ÄÃÜÂëÖ®ºóÖØÆôredmine£¬phpAdmin Á´½Ó²»ÉÏmysqlÊý¾Ý¿âÁË£¬ÎÒÒ²ÐÞ¸ÄÁËphpadminÎļþ¼ÐϵÄconfig.inc.phpµÄÃÜÂ룬»¹ÊDz»ÐУ¬Ìáʾ#1130 - Host 'localhost' is not allowed to connect to this MySQL server´íÎó£¬Ã÷ ......

Mysql´æ´¢¹ý³Ì£¨Èý£©——´¦Àí·ÖÒ³


·ÖÒ³¹¦ÄÜÔÚÈκÎÓ¦ÓÃÖж¼±È½Ï³£¼û£¬¶ø
Mysql
µÄ´æ´¢¹ý³Ì·ÖÒ³±ØÐëͨ¹ý¶¯Ì¬
sql
À´Ö´ÐС£·ÖÒ³¶ÔÓ¦µÄ
offset
ºÍ
row_count
±ØÐëÏÈÓÃ
concat
º¯Êý±ä³É×Ö·û´®×é×°µ½
sql
ÖУ¨ÈçÓï¾ä
1
£©£¬¶ø²»ÄÜÖ±½ÓʹÓã¨ÈçÓï¾ä
2
£¬
Mysql
²»Ö§³Ö£©¡£
Mysql
·ÖÒ³¹¦ÄܵÄʵÏÖÈçÏ´úÂëËùʾ£º
    &nbs ......

Mysql´æ´¢¹ý³Ì£¨ËÄ£©——Òì³£´¦Àí

ÓÐʱºò£¬²»Ï£Íû´æ´¢¹ý³ÌÅ׳ö´íÎóÖÐÖ¹Ö´ÐУ¬¶øÊÇÏ£Íû·µ»ØÒ»¸ö´íÎóÂë¡£
Mysql
Ö§³ÖÒì³£´¦Àí£¬Í¨¹ý¶¨Òå
CONTINUE/EXIT
Òì³£´¦ÀíµÄ
HANDLER
À´²¶»ñ
SQLWARNING/NOT FOUND/SQLEXCEPTION
£¨¾¯¸æ
/
ÎÞÊý¾Ý
/
ÆäËûÒì³££©¡£ÆäÖУ¬
FOR
ºóÃæ¿ÉÒÔ¸ÄΪ
SQLWARNING,
NOT FOUND, SQLEXCEPTION
À´Ö¸Ê¾ËùÓÐÒì³£¶¼´¦Àí£¬Ïൠ......

MySql °²×°½Ì³Ì ʵ¼

×÷ÕߣºÐûÕ×Åô
--------------------------------------------------------------------------------------------------------------------------------------------
½ñÌìÔÚ±¾±¾Éϰ²×°MYSQL£¬ÔÚ°²×°¹ý³Ì³öÏÖÁËÒ»Ð©Ææ¹ÖµÄÎÊÌ⣬Òò´ËÔÚÕâÀï·ÖÏíÕû¸ö°²×°Á÷³ÌÓë´íÎó½â¾ö·½·¨¡£
MySQL°æ±¾£º5.1.40-community
1¡¢ÏÂÔØ°²×°°ü²¢° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ