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

½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨


ÒÔÏÂÕª×ÔÍøÂç
----------------------------------------
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlºó£¬¸ü¸Ä “mysql” Êý¾Ý¿âÀïµÄ “user” ±íÀïµÄ “host” Ï´Ó”localhost”¸Ä³Æ'%'¡£¡£
mysql -u root -p
mysql>use mysql;
mysql>select 'host' from user where user='root';
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host'   from user where user='root';
µÚÒ»¾äÊÇÒÔȨÏÞÓû§rootµÇ¼
µÚ¶þ¾ä£ºÑ¡Ôñmysql¿â
µÚÈý¾ä£º²é¿´mysql¿âÖеÄuser±íµÄhostÖµ£¨¼´¿É½øÐÐÁ¬½Ó·ÃÎʵÄÖ÷»ú/IPÃû³Æ£©
µÚËľ䣺ÐÞ¸ÄhostÖµ£¨ÒÔͨÅä·û%µÄÄÚÈÝÔö¼ÓÖ÷»ú/IPµØÖ·£©£¬µ±È»Ò²¿ÉÒÔÖ±½ÓÔö¼ÓIPµØÖ·
µÚÎå¾ä£ºË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í
µÚÁù¾ä£ºÔÙÖØÐ²鿴user±íʱ£¬ÓÐÐ޸ġ£¡£
ÖØÆðmysql·þÎñ¼´¿ÉÍê³É¡£
 
============================
Ò»¡¢Í¨¹ýMySQL-Front»òmysql administratorÁ¬½ÓmysqlµÄʱºò·¢ÉúµÄÕâ¸ö´íÎó
ERROR 1130: Host ***.***.***.*** is not allowed to connect to this MySQL server
˵Ã÷ËùÁ¬½ÓµÄÓû§ÕʺÅûÓÐÔ¶³ÌÁ¬½ÓµÄȨÏÞ£¬Ö»ÄÜÔÚ±¾»ú(localhost)µÇ¼¡£
Ðè¸ü¸Ä mysql Êý¾Ý¿âÀïµÄ user±íÀïµÄ hostÏî
°Ñlocalhost¸Ä³Æ%
Ê×ÏȰ´ÏÂÃæµÄ²½ÖèµÇ¼Mysql·þÎñÆ÷
µÇ¼mysqlÐèÒªÇл»µ½dosϵÄmysqlµÄbinĿ¼£¬½øÐÐÈçϲÙ×÷£º
Óï·¨¸ñʽ£ºmysql -h host_name -u user_name -p password   £¨±¾»úµÄ»°-h ºÍhost_name¿ÉÊ¡£©
ÀýÈ磺
C:\program files\mysql\mysql server 5.0\bin>mysql -u root -p
Enter password:******
ÏÈÊäÈëÓû§ÃûºÍÃÜÂëµÇ½ҪÇó£¨-p£©£¬»Ø³µºóµÈ³öÏÖ"Enter password:"£¬ÔÙÊäÈëÃÜÂë»Ø³µ£¬ÕâÑù¾Í¿ÉÒÔ
³É¹¦µÇ½mysql£¬·ñÔò½«»áµÇ½ʧ°Ü¡£
µÇ½³É¹¦ºó»áÏÔʾÈçÏÂÐÅÏ¢¼°Mysql±êʶ·û£º
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.1-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
±êʶ·û"mysql>"£¬µ±Äã¿´µ½Õâ¸ö³öÏÖÔÚ´°¿ÚµÄ×î×ó±ßµÄ¶¥¸ñʱ£¬Õâ¾ÍÊǸ


Ïà¹ØÎĵµ£º

mysql´æ´¢¹ý³Ì»ù±¾º¯Êý


Ò».×Ö·û´®Àà 
CHARSET(str) //·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2  [,... ]) //Á¬½Ó×Ö´®
INSTR (string ,substring ) //·µ»ØsubstringÊ×´ÎÔÚstringÖгöÏÖµÄλÖÃ,²»´æÔÚ·µ»Ø0
LCASE (string2 ) //ת»»³ÉСд
LEFT (string2 ,length ) //´Óstring2ÖеÄ×ó±ßÆðÈ¡length¸ö×Ö·û
LENGTH (string ) //string³¤¶È
LO ......

MYsql ÒìµØ±¸·Ý½Å±¾

ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒ԰Ѱ²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
 
±ÈÈçÎļþà ......

mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö

mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö
Ò». MySQLÃÜÂëµÄ»Ö¸´·½·¨Ö®Ò»
Èç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂ룬¿ÉÒÔÓÃÒÔÏ·½·¨ÖØÐÂÉèÖãº
1. KILLµôϵͳÀïµÄMySQL½ø³Ì£»
killall -TERM mysqld
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
safe_mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£» ......

mysqlÊý¾ÝË«Ïòͬ²½

2.»·¾³ËµÃ÷
2.1    Ó²¼þ»·¾³(Á½Ì¨»úÆ÷µÄÓ²¼þ»·¾³Ïàͬ)
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
Ó²ÅÌ´óС
8GB
ÆäËü˵Ã÷
±¾»úÆ÷ΪÐéÄâ»ú£¬ÆäÓÐÁ½¿éÍø¿¨£¬Ò»¶ÔÍø¿¨Ö±Á¬£¬Ò»¶Ô½ÓÈë½»»»»ú
 
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
......

MySQLÐÔÄÜÓÅ»¯


MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾­Ñé
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊDzé±íʱµÄSQLÓï¾ä£©£¬ÎÒÃǶ¼ÐèҪעÒâÊý¾Ý²Ù×÷µÄÐÔÄÜ¡£ÕâÀÎÒÃDz»» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ