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

Linux mysql ·þÎñÆ÷ÂýµÄÔ­Òò

Õ⼸ÌìLinux·þÎñÆ÷ºÜÂý,ºÜ׿±ÕÒ²»µ½½â¾ö°ì·¨!ºó°Ù¶ÈÏà¹Ø×ÖÑÛ,²éÕÒµ½ÊÇMySQLµÄÎÊÌâ,
ÈçÏÂΪ½â¾ö·½°¸
:
Á¬½ÓMySQLËÙ¶ÈÂýµÄ½â¾ö·½·¨.
PHPÔ¶³ÌÁ¬½ÓMYSQLËÙ¶ÈÂý,ÓÐʱԶ³ÌÁ¬½Óµ½MYSQLÓÃʱ4-20Ãë²»µÈ,±¾µØÁ¬½ÓMYSQLÕý³£,³öÏÖÕâÖÖÎÊÌâµÄÖ÷ÒªÔ­ÒòÊÇ,ĬÈϰ²×°µÄ
MYSQL¿ªÆôÁËDNSµÄ·´Ïò½âÎö,ÔÚMY.CNF(UNIX»òLINUXϵͳÏÂ)»òMY.INI(WINDOWSϵͳÏÂ)ÎļþµÄ[mysqld]ϼÓÈë
skip-name-resolveÕâÒ»¾ä¡£
ÔÚ¾ÖÓòÍøÄÚÁ¬½ÓÆäËû»úÆ÷µÄMYSQL,·¢ÏÖ
ËÙ
¶ÈÂýµÄºÜ,²»ÖªµÀʲôԭÒò,×ÜÓм¸ÃëµÄÑÓ³Ù.
ºóÀ´ÔÚÍøÉÏ·¢ÏÖ½â¾ö·½·¨£¬my.cnfÀïÃæÌí¼Ó
[mysqld]
skip-name-resolve
skip-grant-tables
ÕâÑùËٶȾͿìÁË!
skip-name-resolve
Ñ¡Ïî¾ÍÄܽûÓÃDNS½âÎö£¬Á¬½ÓËÙ¶È»á¿ìºÜ¶à¡£²»¹ý£¬ÕâÑùµÄ»°¾Í²»ÄÜÔÚMySQLµÄÊÚȨ±íÖÐʹ
ÓÃ
Ö÷
»úÃûÁ˶øÖ»ÄÜÓÃip¸ñʽ¡£
ÈôʹÓÖskip-grant-tablesϵͳ½«¶ÔÈκÎÓû§µÄ·ÃÎʲ»×öÈκηÃÎÊ¿ØÖÆ£¬µ«¿ÉÒÔÓà mysqladmin
flush-privileges»òmysqladmin reloadÀ´¿ªÆô·ÃÎÊ¿ØÖÆ;ĬÈÏÇé¿öÊÇshow databasesÓï¾ä¶ÔËùÓÐÓû§¿ª·Å£¬
Èç¹ûmysql·þÎñÆ÷ûÓпªÔ¶³ÌÕÊ»§£¬¾ÍÔÚmy.cnfÀïÃæ¼ÓÉÏskip-grant-tables


Ïà¹ØÎĵµ£º

WindowsÏ»·¾³±äÁ¿Ð޸ģ¨Éæ¼°MySQLÃüÁîµÄÖ±½ÓÔËÐУ©


ÓÒ¼üÎҵĵçÄÔ->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿
¿ÉÒÔ¿´µ½ÓÐÓû§±äÁ¿ºÍϵͳ±äÁ¿
ÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½øÐÐÐ޸Ļ·¾³±äÁ¿
±ÈÈç˵ÎÒÃǰ²×°ÁËMySQL·þÎñÆ÷£¬Ïë½øÈëMySQLµÄÃüÁîÐеϰ¾Í±ØÐëÔËÐÐcmd
Èç¹ûûÓÐÉèÖû·¾³±äÁ¿µÄ»°ÎÒÃDZØÐë½øÈëMySQLµÄ°²×°Â·¾¶²ÅÄÜʹÓÃmysql -u root -pÕâ¸öÃüÁî
ÕâÑù»á¸øÎÒÃÇ´øÀ´ºÜ¶àÂé·³£¬ÕâʱºòÎÒÃÇÏëÔ ......

.NETÁ¬½ÓMySqlÊý¾Ý¿âµÄ·½·¨¼°Ê¾Àý

·½·¨Ò»£º
ʹÓÃMySQLÍÆ³öµÄMySQL Connector/Net×é¼þ£¬ ¸Ã×é¼þÊÇMySQLΪADO.NET·ÃÎÊMySQLÊý¾Ý¿âÉè¼ÆµÄ.NETרÓ÷ÃÎÊ×é¼þ¡£Íê³É¸Ã×é¼þºó£¬ÐèÒªÔÚÏîÄ¿ÖÐÒýÓÃÕâ¸ö×é¼þ£¬Ò²¿ÉÒÔÖ±½ÓÔÚÅäÖÃÎļþµÄ<assemblies>½ÚµãÄÚÌí¼ÓÏÂÃæµÄ½Úµã£º
<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687 ......

[ת]MySQLÊý¾Ý¿âµÄÊý¾Ý±¸·ÝºÍ»Ö¸´Ïê½â

ת:http://home.mysql.cn/space-51084-do-blog-id-43.html
±¾ÎÄÌÖÂÛ MySQL
µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM ºÍ Innodb£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ŀǰ MySQL
Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACKUP TABLE »òÕß SELECT ......

AmfphpÓëFlex½»»¥:¶ÁÈ¡mysqlÊý¾Ý

·þÎñÆ÷¶Ë´úÂë,amfphpµÄservicesĿ¼Ï½¨Á¢readData.phpÎļþ,´úÂëÈçÏÂ
<?php
    class ReadDB
    {
              function getData()
            &nb ......

½â¾öFlex+amfphp+MySQLÖÐÎÄÂÒÂëµÄ·½·¨


Ê×ÏÈ£ºÈ·¶¨Êý¾Ý¿âµÄ±àÂëΪutf8£¬Õý³£´¢´æÖÐÎÄ£¨ÓÃMySQL-Front²é¿´ÖÐÎÄÊÇ·ñÕý³££©
È»ºó£ºServices²éѯMySQLʱʹÓÃ"SET NAMES 'utf8'"£¬ÇÒͨ¹ý"amfphp/browser"ÔËÐп´¿´ÊÇ·ñÖÐÎÄ£¬Èç¹ûÂÒÂëÔòÐÞ¸Ägateway.phpÎļþ£¬È¥µô $gateway->setCharsetHandler("utf8_decode", "ISO-8859-1", "ISO-8859-1");
×îºó£ºÔËÐÐFlex³ÌÐòÏÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ