MySql ÔõôÔÚÊý¾Ý¿â°²×°µÄʱºò¾Í×Ô¶¯Éú³ÉĬÈÏÓû§ÄØ£¿
±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩÓû§µÄ£¬Ö»ÓÐÒ»¸öϵͳĬÈÏÓû§ root@localhost
Èç¹ûÄãÐèÒªÔÚÄã×Ô¼ºµÄ°²×°½Å±¾»ò³ÌÐòÖÐÉèÖá£ÔòÄãÐèÒª create user 'Client'@'%' IDENTIFIED BY '12345'
×¢Òâ£Í£Ù£Ó£Ñ£ÌµÄÓû§Õ˺ÅÓÉ username@hostname ×é³É scott@localhost Óë scott@198.123.21.22 ²»ÊÇͬһ¸öÓû§£¡
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¿ÉÒԲο¼Ò»Ï¹ٷ½ÎĵµÖÐµÄ create user ºÍ
5.7. MySQL·ÃÎÊȨÏÞϵͳ
5.7.1. ȨÏÞϵͳµÄ×÷ÓÃ
5.7.2. ȨÏÞϵͳ¹¤×÷ÔÀí
5.7.3. MySQLÌṩµÄȨÏÞ
5.7.4. ÓëMySQL·þÎñÆ÷Á¬½Ó
5.7.5. ·ÃÎÊ¿ØÖÆ, ½×¶Î1£ºÁ¬½ÓºËʵ
5.7.6. ·ÃÎÊ¿ØÖÆ, ½×¶Î2£ºÇëÇóºËʵ
5.7.7. ȨÏÞ¸ü¸ÄºÎʱÉúЧ
5.7.8. ¾Ü¾ø·ÃÎÊ´íÎóµÄÔÒò
5.7.9. MySQL 4.1ÖеÄÃÜÂë¹þÏ£´¦Àí
5.8. MySQLÓû§ÕË»§¹ÜÀí
5.8.1. MySQLÓû§ÃûºÍÃÜÂë
5.8.2. ÏòMySQLÔö¼ÓÐÂÓû§ÕË»§
5.8.3. ´ÓMySQLɾ³ýÓû§ÕË»§
5.8.4. ÏÞÖÆÕË»§×ÊÔ´
5.8.5. ÉèÖÃÕË»§ÃÜÂë
5.8.6. ʹÄãµÄÃÜÂ밲ȫ
5.8.7. ʹÓð²È«Á¬½Ó
mysqlΪÁ˰²È«£¬ÏÖÔÚÖ»ÓÐÒ»¸öĬÈϰ²×°Õ˺ţ¬ÆäËûµÄÒª×Ô¼º´´½¨
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......