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

Can't connect to MySQL server on '' (10060)

Ô¶³ÌÁ¬½Ó·þÎñÆ÷³öÏÖÒÔÉÏ´íÎó
Ö÷ÒªÓÐÈý¸öÔ­Òò£º
1¡¢mysqlÊÚȨ±íÀïûÓÐÔ¶³Ì»úÆ÷µÄȨÏÞ£¬¼°ÐèÒªÔÚÊÚȨ±ímysql.userÌí¼Ó
grant all privileges on *.* to 'root'@'Ô¶³ÌµÇ½IP' identified by 'Ô¶³ÌµÇ½ÃÜÂë'
flush privileges;
2¡¢ÍøÂ粻ͨ£¬Õâ¸ö¾Í²»ËµÁË¡£
3¡¢·À»ðǽ½ûÖ¹3306¶Ë¿Ú£¬ÒÔiptableΪÀý
vi /etc/sysconfig/iptables
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306-j ACCEPT  
service iptables restart
ps:  iptablesÉèÖÃ
1) ÖØÆôºóÉúЧ
¿ªÆô£º chkconfig iptables on
¹Ø±Õ£º chkconfig iptables off
2) ¼´Ê±ÉúЧ£¬ÖØÆôºóʧЧ
¿ªÆô£º service iptables start
¹Ø±Õ£º service iptables stop


Ïà¹ØÎĵµ£º

How to change max_allowed_packet value in mysql?

 
If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows.
 
mysql>show variables like’max_allowed_packet’; ......

mysql cluster rpm°²×°°üµÄÑ¡Ôñ °²×° ÅäÖà ²âÊÔ

            ÏÖÔÚа汾µÄmysql¼¯ÈºÒÑ´ÓÆÕͨµÄmysql°æ±¾ÖÐÌáÈ¡³öÀ´ÁË£¬Ò²¾ÍÊÇÒª×ömysqlµÄ¼¯ÈºÐèҪѡÔñmysql¼¯Èº¶ÔÓ¦µÄÈí¼þ°ü¡£¶øÇÒmysqlרÃÅÌṩÁËÕë¶Ôredhat ²Ù×÷ϵͳµÄrpmÈí¼þ°ü¡£¿ÉÒÔ´Óhttp://dev.mysql.com/downloads/»ñµÃ¶ÔÓ¦µÄ²Ù×÷ϵͳµÄrpmÈí¼þ°ü¡£ÔÚÕâÀïÖ÷ ......

mysql Á¬½Óorcal Êý¾Ý¿â OCIDefineByName


Oracle 8 資ÁÏ庫º¯Ê½庫
OCIDefineByName
讓 SELECT Ö¸Áî¿ÉʹÓà PHP 變數¡£
語·¨: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳»ØÖµ: ²¼ÁÖÖµ
º¯Ê½種類: 資ÁÏ庫¹¦ÄÜ
 
內È ......

MYSQLÒýÇæ¼òµ¥¶Ô±È

·þÎñÆ÷ÒµÎñÀàÐÍ¶Ô±È ÐÔÄÜÆ¿¾±
DB                   I/O´ÅÅÌ
ת·¢·þÎñÆ÷         Íø¿¨PPS
¶¯Ì¬WEBǰ̨         CPU
¾²Ì¬WEBǰ̨   ......

javaÅúÁ¿µ¼Èëexcelµ½MysqlÊý¾Ý¿â

package com.google.i_sales.service.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Locale;
import java.uti ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ