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

ÈÃmysql Äܹ»Ô¶³ÌÁ¬½Ó

mysql error number 2003   
Can't connect to MySQL server xxx.xxx.xxx.xxx (10061)
ÔÚubuntu 9.04ÖÐĬÈϰ²×°ÁËmysql£¬Ä¬ÈÏÖ»Äܱ¾µØ·ÃÎÊ£¬googleÁËһϣº
²ÉÓÃ
µÇ¼µ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ´ÐÐ
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
¼´¿É
Èç¹ûÒªÉèÖÃΪÈκοͻ§¶Ë¶¼¿ÉÒÔÒÔrootÁ¬½ÓµÄ»°£¬¿ÉÒÔÕâôд£º
grant all on *.* to 'root'@'%' identifiied by 'rootµÄÃÜÂë'
¸ñʽ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
ÀàËÆÕâÓ÷½·¨µÄÕûÀíÈçÏ£º
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -pvmwaremysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;
2. ÊÚȨ·¨¡£ÀýÈ磬ÄãÏëmyuserʹÓÃmypassword´ÓÈκÎÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷µÄ»°¡£
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.3µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃmypassword×÷ΪÃÜÂë
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 
µ«ÎÊÌâÈÔûÓнâ¾ö£º
ÕÒµ½ ÃüÁî   mysql> flush privileges    //ʹÐÞ¸ÄÉúЧ
                ÏÔʾӰÏìÁËÁãÐС£
ÎÊÌâÒÀȻûÓнâ¾ö£¬ÖØÐÂÆô¶¯mysql  sudo /etc/init.d/mysql restart
»¹ÊDz»ÐС£
´Ó http://www.blogjava.net/waterjava/archive/2008/04/27/196385.html
Á˽⵽mysqlÓб¾»ú°ó¶¨£¬ÕÒµ½ÎÊÌâËùÔÚ¡£
±à¼­ /etc/mysql/my.cnf
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
½«”bind-address = 127.0.0.1“×¢ÊÍ
sudo /etc/init.d/mysql restartÖØÆô¼´¿ÉÔ¶³Ì·ÃÎÊ
ÎÊÌâ½â¾ö
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/helen_shw/archive/2010/01/22/5224524.aspx


Ïà¹ØÎĵµ£º

MySQL´¥·¢Æ÷½â¾ö·½°¸Àú³Ì

×î½ü£¬ÏîÄ¿ÖÐÓõ½mysql£¬ÓÉÓÚÊý¾ÝÁ¿·Ç³£´ó£¬Ã¿ÌìµÄÊý¾ÝÁ¿ÔÚ°ÙÍò¼¶£¬¿¼Âǵ½mysqlÊý¾Ý¿â´¦ÀíÐÔÄÜÒÔ¼°Êý¾ÝÊôÐÔ£¬¾ö¶¨±£´æ×ã¹»¶àµÄ²éѯÊý¾Ý¼´¿É£¬¾àµ±Ç°Ê±¼ä×î¾ÃÔ¶µÄÊý¾ÝÖ±½Óɾ³ý£¬ÎÞÐè½øÐб¸·Ý¡£
Í·ÄÔÖÐð³öµÄµÚÒ»¸öÏë·¨¾ÍÊÇ£¬ÄÜ·ñÀûÓÃmysqlÖеĴ¥·¢Æ÷£¬¼ì²éÊý¾Ý±í´óС£¬Èç¹û³¬¹ýÔ¤É賤¶È£¬Ôòɾ³ý²¿·ÖÊý¾Ý¡£
CREATE TRIGGER ......

MySQL server has gone away µÄ½â¾ö°ì·¨

ÓÐʱºòʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÃüÁîÐе¼È뱸·Ýʱ»á³öÏÖ“MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) server has gone away”´íÎó£¬Õâ¿ÉÄÜÊÇÒòΪÆäÖÐһЩinsertÓï¾äµÄ´óС³¬³öÁËMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ĿǰÉèÖõĻº³åÇø´óС¡£
½â¾ö°ì·¨
1.ʹÓÃphpmyadmin ±¸·ÝMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄʱºò£¬Ö»Ñ¡Ôñ
Êý¾Ý: ......

mysql ½«±íÖÐÊý¾Ýµ¼³ö £¨linux£©

½ñÌìÓöµ½Òªµ¼³öÊý¾Ý¿âÖбíµÄÊý¾Ý¡£ÏÂÃæÕâ¸ö¾Í¿ÉÒԸ㶨¡£¡£
#µ¼³öÖ¸¶¨µÄ±í #µ¼³öÃüÁî -uÓû§Ãû -pÃÜÂë -hÖ÷»úIPµØÖ· Êý¾Ý¿âÃû ±íÃû1 ±íÃû2 > µ¼³öÎļþ.sql
mysqldump -uroot -proot -h192.168.0.88 ok_db oktable1 oktable2 > ok_db.sql
ÁíÍâÔÚ¸ü¸ÄmysqlÃÜÂëʱºò£¬ÍøÉÏÓÐЩÃüÁî²»¶Ô£º
ÎÒÓÃÈçÏ£ºset password=pas ......

Linux Ï mysql µÄÏà¹ØÃüÁî

1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
  
   ÒѾ­ÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
   ÎÊÌ⣺
   cat  /etc/mysql/my.conf
   ÕÒµ½ÏÂÃæÒ»ÐÐ
   bind-address   = 127.0.0.1
   Î ......

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´íÎó£¬Ã÷ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ