Á¬½Ó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('ÃÜÂë'); ×¢ÒâǰºóµÄ·ÖºÅ
Ïà¹ØÎĵµ£º
JDBCÁ¬½ÓMySQLÊý¾Ý¿â¹Ø¼üµÄËĸö²½Öè http://www.mesfr.com
Ò»¡¢²éÕÒÇý¶¯³ÌÐò
¡¡¡¡MySQLĿǰÌṩµÄJavaÇý¶¯³ÌÐòΪConnection/J£¬¿ÉÒÔ´ÓMySQL¹Ù·½ÍøÕ¾ÏÂÔØ£¬²¢ÕÒµ½mysql-connector-java-3.0.15-ga-bin.jarÎļþ£¬´ËÇý¶¯³ÌÐòΪ´¿JavaÇý¶¯³ÌÐò£¬JDBCÁ´½ÓMySQL²»Ðè×öÆäËûÅäÖá£
¶þ¡¢¶¯Ì¬Ö¸¶¨classpath
¡¡¡¡Èç¹ûÐèÒªÖ´ÐÐʱ¶¯Ì¬ ......
MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»
¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷Ðбà徎ÓïÑÔPHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆä
µ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪà ......
MySQLµÄĬÈϱàÂëÊÇLatin1£¬²»Ö§³ÖÖÐÎÄ.ÒªÈÃĬÈϱàÂë±äΪutf8¡£¿É½øÐÐÈçÏÂÅäÖãº
SET GLOBAL character_set_client = utf8;
SET GLOBAL character_set_connection = utf8;
SET GLOBAL character_set_database = utf8;
SET GLOBAL character_set_results = utf8;
......
mysqlµÄ´æ´¢ÒýÇæÓм¸ÖÖ£¬µ«ÊÇ´Ó5.0¿ªÊ±´ó²¿·ÖÊÇĬÈϲÉÓà innodb´æ´¢ÒýÇæ¡£innodb´æ´¢ÒýÇæÖ§³Ö ÊÂÎñ£¬Íâ¼ü£¬ÐÐÊý¾ÝËø¶¨£¨µ±È»ÊÇÏà¶ÔmyisamµÄ±íËø¶¨£©¡£magento°²×°µÄʱºòÓмì²é mysqlÊÇ·ñÖ§³Öinnodb´æ´¢ÒýÇæ£¬Èç¹û²»Ö§³ÖÔò²»ÄܼÌÐø°²×°¶øÌáʾÈçÏ´íÎ󣬾¡¹Üinnodb´æ´¢²¢Ã»Óб»ÁÐΪ°²×°magentoµÄǰÌáÌõ¼þÖ®Ò»¡£
Database&nbs ......