ÎҵijÌÐòÔÚд´úÂëµÄµçÄÔÉÏÓÃÁ¬½Óµ½ Ô¶³ÌµÄ¿Í»§¶Ë£¬µ«ÊÇÄõ½ÆäËû»úÆ÷ÉϾͱ¨
Client does not support authentication protocol requested by server
ÎÒ°´ÕÕÍøÉÏËÑË÷µÄ·½·¨¸ÄÁË
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Æä¶þ ......
Ïë´ïµ½µÄЧ¹ûͼ£º
Èç¿´²»µ½Í¼£¬Í¼Æ¬Á¬½Ó£ºhttp://hiphotos.baidu.com/loglab/pic/item/deb30c365e3e09050b55a913.jpg
ÇóÒ»¾äMYSQLËÑË÷Óï¾ä
Ìõ¼þÒ»£ºÏÖÔÚ¼Ù¶¨Êý¾Ý±í½á¹¹¼°²¿·ÖÊý¾ÝÈçÏ£º
id username inserttime
1 aa &n ......
ÇëÎÊ´ó¼ÒÏÖÔÚÓõÄÊÇʲôµÚÈý·½¹¤¾ßÁ¬½Ómysql,±¾ÈËÓõÄÊÇnavicat¸Ð¾õ²»Ïñoracle µÄµÚÈý·½¹¤¾ßPLSQL DeveloperºÃʹ ;
navicat ±È½Ï¶à¡£
²»¹ýÓõÃ×î¶àµÄ»¹ÊÇ mysql.exe ÃüÁîÐС£Ã»ÓаæÈ¨ÎÊÌâ¡£
sqlyog£¬»¹²»´í
ÒýÓÃ
navicat ±È½Ï¶à¡£
²»¹ýÓõÃ×î¶àµÄ»¹ÊÇ mysql.exe ÃüÁîÐС£Ã»ÓаæÈ¨ÎÊÌâ¡£
Èç¹ûÓÃ mysql. ......
×öjava¿ª·¢ ÓÃlinuxµÄmysql
ÓÉÓÚÉæ¼°¶à¹úµÄÊ±ÇøÉèÖà £¬ÓÐʱºò±ØÐëÐ޸ĻúÆ÷µÄÊ±Çø£¬ Õâʱ±ØÐëÍ¬Ê±ÖØÆômysql £¨±¾ÏîĿҪÇómysqlµÄʱ¼ä±ØÐëºÍos±£³ÖÒ»Ö£©
ÎÊÓÐûÓÐÆäËû·½·¨±ÜÃâÕâ¸ö·½·¨ £¨²»ÈÃmysqlÖØÆô
java¹¤³Ìÿ´ÎÖØÆô»¨Ê±¼ä¹ý³¤ £¬ÐèÒª20·Ö ¡£ Ï£ÍûÄÜÓÐÆäËû·½·¨
²»ÖØÆômysqlʵÏÖÓëosµÄʱ¼ä±£³ÖÒ»Ö£¬ ±ÈÈçÔ ......
create table test (
code varchar(10),
check int
)
Ö´ÐÐÕâ¸ö¾Í»á±¨´í
´ÓÍøÉϲéµÄÊÇcheckÊǹؼü×ÖµÄÎÊÌâ Èç¹ûÎÒÈÔÈ»ÏëÓÃcheck×öÁÐÃ÷
¸ÃÔõô°ì £¿ ÊÇ·ñ¿ÉÒÔ½â¾ö ¸ßÊÖÖ¸½Ì £¡£¡
mysql °æ±¾ Server version: 5.1.40-community MySQL Community Server (GPL)
create table test (
code va ......
½ñÃæÊÔ±»Îʵ½Õâ¸ö£¬²»ÖªµÀ¸ÄÔõô»Ø´ð°¡£¬ÄÇλ´óÏÀ¸øÐ¡µÜ½²½âÏÂ
1mysqlºÍ oracleµÄÇø±ðÔÚ¼¼ÊõÉÏ
2arraylistµ½µ×ÄÜ´æ¶àÉÙ
µÚÒ»¸öÎÊ¡£¡£¡£¡£¡£Õâ¸ö´ð°¸Ò²Ì«¹ã·ºÁË£¬Õâ¸öµÈ¥Ͻâ´ð
µÚ¶þ¸öµÄ»°µ×²ãÊÇÒ»¸öÊý×é×ö³É£¬µ±Êý×é²»¹»Î»Ê±£¬»á×Ô¶¯°ÑËùÓÐÊý¾Ý¿½±´µ½Ò»¸öеÄLISTÈ¥£¬ËùÒÔ°´ÀíÀ´Ëµ£¬Ó¦¸ÃJVM²»±¨ÄÚ´æÒç³ö£¬¾ ......