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

Á¬½ÓMySQLÊý¾Ý¿âʱ³öÏÖ#1251´íÎóµÄ½â¾ö·½·¨

Á¬½ÓMySQLÊý¾Ý¿âʱ³£»á³öÏÖÈçϵĴíÎóÌáʾ£º
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
³öÏÖÕâÖÖÎÊÌâÊÇÔÚMySQL4.1ÒÔÉϰ汾£¬Ô­ÒòMySQL·þÎñÆ÷°æ±¾Ê¹ÓÃÁËеÄÃÜÂëÑéÖ¤»úÖÆ£¬Æä½â¾ö·½·¨ÈçÏ£º
mysql>;set password for 'Óû§Ãû' @ 'Ö÷»úÃû' = old_password('ÃÜÂë');     ×¢ÒâǰºóµÄ·ÖºÅ


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿â±¸·ÝÓë»Ö¸´

·½·¨Ò»£º
1.µ¼³öÕû¸öÊý¾Ý¿â
ÃüÁîÐнøÈëµ½mysql°²×°Ä¿Â¼µÄbinĿ¼ÏÂ
¼ÙÉè×°ÔÚD:/mysql/bin
¼´£º¿ªÊ¼ ÔËÐÐ ÊäÈëcmd
d:
cd mysql/bin
È»ºóÖ´ÐÐÏÂÃæÓï¾ä
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû  
ʾÀý£ºmysqldump -u root -p sq_wcnc > d:\wcnc.sql
2.»Ö¸´Êý¾Ý¿â
   ³£ÓÃsource ÃüÁî ......

MysqlÊýѧº¯Êý½âÎö

ËùÓеÄÊýѧº¯ÊýÔÚÒ»¸ö³ö´íµÄÇé¿öÏ·µ»ØNULL¡£ 

µ¥Ä¿¼õ¡£¸Ä±ä²ÎÊýµÄ·ûºÅ¡£ 
mysql> select - 2; 
×¢Ò⣬Èç¹ûÕâ¸ö²Ù×÷·ûÓëÒ»¸öBIGINTʹÓ㬷µ»ØÖµÊÇÒ»¸öBIGINT£¡ÕâÒâζ×ÅÄãÓ¦¸Ã±ÜÃâÔÚÕûÊýÉÏʹÓÃ-£¬ÄÇ¿ÉÄÜÓÐÖµ-2^63£¡ 
ABS(X)
·µ»ØXµÄ¾ø¶ÔÖµ¡£ 
mysql> select ABS(2);&n ......

mysql¼ÓÃܽâÃܺ¯ÊýAES_ENCRYPTÓëAES_DECRYPT

mysqlϵļÓÃܺ¯ÊýÓÐÈçϼ¸¸ö
PASSWORD()£º´´½¨Ò»¸ö¾­¹ý¼ÓÃܵÄÃÜÂë×Ö·û´®£¬ÊʺÏÓÚ²åÈëµ½MySQLµÄ°²È«Ïµ
ͳ¡£¸Ã¼ÓÃܹý³Ì²»¿ÉÄæ£¬ºÍunixÃÜÂë¼ÓÃܹý³ÌʹÓò»Í¬µÄËã·¨¡£Ö÷ÒªÓÃÓÚMySQLµÄÈÏ֤ϵͳ¡£
 
ENCRYPT(£¬)£ºÊ¹ÓÃUNIX crypt()ϵͳ¼ÓÃÜ×Ö·û´®£¬ENCRYPT()º¯Êý½ÓÊÕÒª¼ÓÃܵÄ×Ö·û´®ºÍ£¨¿ÉÑ¡µÄ£©ÓÃÓÚ¼ÓÃܹý³ÌµÄsalt£¨Ò»¸ ......

Mysql¿ªÆôÈÕÖ¾

Ô­ÎÄת×Ô:http://hi.baidu.com/jackli00/blog/item/21b2e242025bfa1473f05d24.html
Mysql¿ªÆôÈÕÖ¾
2008-11-18 11:23
ÊÇ·ñÆôÓÃÁËÈÕÖ¾
mysql>show variables like 'log_bin';
ÔõÑùÖªµÀµ±Ç°µÄÈÕÖ¾
mysql> show master status;
¿´¶þ½øÖÆÈÕÖ¾ÎļþÓÃmysqlbinlog
shell>mysqlbinlog mail-bin.000001(Ҫд¾ø¶ÔÎÊÌâ ......

JDBCÁ¬½ÓMySQLÊý¾Ý¿â¹Ø¼üµÄËĸö²½Öè

JDBCÁ¬½ÓMySQLÊý¾Ý¿â¹Ø¼üµÄËĸö²½Öè http://www.mesfr.com
Ò»¡¢²éÕÒÇý¶¯³ÌÐò
¡¡¡¡MySQLĿǰÌṩµÄJavaÇý¶¯³ÌÐòΪConnection/J£¬¿ÉÒÔ´ÓMySQL¹Ù·½ÍøÕ¾ÏÂÔØ£¬²¢ÕÒµ½mysql-connector-java-3.0.15-ga-bin.jarÎļþ£¬´ËÇý¶¯³ÌÐòΪ´¿JavaÇý¶¯³ÌÐò£¬JDBCÁ´½ÓMySQL²»Ðè×öÆäËûÅäÖá£
¶þ¡¢¶¯Ì¬Ö¸¶¨classpath
¡¡¡¡Èç¹ûÐèÒªÖ´ÐÐʱ¶¯Ì¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ