mysqlÓû§ÈÏÖ¤ÐÒé¸ü»»£¨mysqlʹÓÃÎÊÌâ)
°²×°ºÃmysqlºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
MYSQL 4.1ÒÔºó, ²ÉÓÃÁËÒ»ÖÖеÄÓû§ÈÏÖ¤ÐÒé, ¶ÔÓÚÀϵĿͻ§¶Ë»á³öÏÖ²»Ö§³ÖÈÏÖ¤ÐÒéµÄ´íÎó, ÒÔÏÂÊǹٷ½ÍøÕ¾µÄ½â¾ö·½·¨﹔
1When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
ʹÓÃÒÔǰ½¨Á¢µÄÕ˺ÅÁ¬½Ó£¬¶ÔÓÚÔÚеÄÈÏÖ¤ÐÒéϽ¨Á¢µÄÕË»§¾Í²»ÐÐÁË
£³Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function: mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.
ÕâÊÇÒ»¸ö²»´íµÄ°ì·¨£¬Ð½¨Á¢µÄÕ˺ŲÉÓÃÀÏʽµÄ¼ÓÃÜÐÒé
£´Tell the server to use the older password hashing algorithm:
Start mysqld with the --old-passwords option.
ÕâÑùÐÂÈÏÖ¤ÐÒéµÄÓŵã¾Íû·¨Ê¹ÓÃÁË
£µAssign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query: mysql> SELECT Host, User, Password from mysql.user
-> WHERE LENGTH(Password) > 16;
For each account record displayed by the query, use the Host and User values and assign a password using th
Ïà¹ØÎĵµ£º
InnoDB
ºÍMyISAM
ÊÇÔÚʹÓÃMySQL
×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAM
ÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDB
ÀàÐÍÖ§³Ö¡£MyISAM
ÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDB
ÀàÐ͸ü¿ì£¬µ«ÊDz»ÌṩÊÂÎñÖ§³Ö£¬¶øInnoDB
ÌṩÊÂÎñÖ§³ÖÒѾÍⲿ¼üµÈ¸ß¼¶Êý¾Ý¿â¹¦ÄÜ¡£
MyIASMÊÇIASM± ......
ÌâÄ¿£º¸ø¶¨Ò»¸ö·Ö¸î·û£¬ÔõÑùµÃµ½¸ø¶¨×Ö·û´®×îºóÒ»¸ö·Ö¸î·ûºóµÄ×Ö·û´®¡£ È磺‘fsb-ibees-zxj-fsbk’ ÔõÑùµÃµ½fsbk, ÒªÇó£ºjavaʵÏÖ£¬sqlʵÏÖ£¿sql¿ÉÒÔÊÇoracle£¬mysqlµÈʵÏÖ¡£
1.OracleʵÏÖ
SET SERVEROUTPUT ON;
DECLARE
str VARCHAR2(266):='123-890-ibees-zxj';--±»½âÎöµÄ×Ö·û´®
splitStr VARCH ......
»·¾³£ºRHEL 5.3
°²×°ÁËMySQLÖ®ºó£¬MySQLµÄrootÓû§Ä¬ÈÏÊDz»¿ª·ÅÔ¶³Ì·ÃÎÊȨÏ޵ġ£ÎªÁË¿ª·ÅËü£¬Ö»ÐèÒªÁ½²½£º
ÓÃLinuxϵͳµÄrootÓû§µÇ¼ϵͳ£¬È»ºó£º
£¨1£©¿ª·Å3306¶Ë¿ÚµÄÔ¶³ÌÁ¬½ÓȨÏÞ£º
ÔÚ“-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited”ÕâÒ»ÐеÄÉÏÃæ£¨×¢Ò⣬һ¶¨ÊÇÉÏÃæ£©£¬Ìí¼ÓÈçÏ ......
http://hi.baidu.com/qk618/blog/item/f61e5830f2125d93a9018e0c.html
½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ ......
Õ⼸Ìì×öÒ»¸ö²éѯ£¬ÐèÒªÔÚÒ»¸öÖ¸¶¨µÄ½á¹û¼¯ÖнøÐвéѯ£¬ÀýÈ磺
select * from table_name where doc_id IN ('1dba', 'c20a', '907b')
ÆäÖÐIN×Ó¾äÖеÄdoc_idÁбíÊÇͨ¹ýµ÷ÓÃÒ»¸öÍⲿ½Ó¿Ú»ñµÃÒ»×édoc_id³£Á¿ÁÐ±í£¬È»ºóÔÚ±¾µØ¿âÖÐËÑË÷·ûºÏÕâ¸öÁбíµÄÊý¾Ý
¼Ç¼¡£ºóÀ´·¢ÏÖmysql·µ»ØµÄ½á¹û¼¯µÄÅÅÐòÊǰ´ÕÕÈë¿â˳Ðò¸ø³öµÄ£¬µ«ÊÇÎÒ ......