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

MYSQL °²È«ÎÊÌâ

×î½üÔÚÑо¿Êý¾Ý¿âµÄ°²È«ÎÊÌ⣬·¢ÏÖMYSQLÓкܶలȫ©¶´£¬ÏëÇë½Ì´ó¼Ò£¬ÔÚ¹ÜÀí·½ÃæÈçºÎÀ´·ÀÖ¹°²È«Òþ»¼¡£

ÎÒÁ˽⵽ÓÐ×¢Èë¹¥»÷£¬¸ÃÈçºÎ·ÀÖ¹£¿

»¹ÓйØÓÚÕ˺š¢ÃÜÂëµÄ¹ÜÀí¡¢ÎļþÊôÐÔµÈ
1. ²Ù×÷ϵͳµÄ°²È«£¬±ÈÈç windows »ò linux µÄ°²È«¡£
2. MySQL ×ÔÉíµÄȨÏÞÉèÖÃ

http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#security
5.6. Ò»°ã°²È«ÎÊÌâ
5.6.1. ͨÓð²È«Ö¸ÄÏ
5.6.2. ʹMySQLÔÚ¹¥»÷ÕßÃæÇ°±£³Ö°²È«
5.6.3. Mysqld°²È«Ïà¹ØÆô¶¯Ñ¡Ïî
5.6.4. LOAD DATA LOCAL°²È«ÎÊÌâ
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. ʹÓð²È«Á¬½Ó
5.9. ±¸·ÝÓë»Ö¸´
5.9.1. Êý¾Ý¿â±¸·Ý
5.9.2. ʾÀýÓñ¸·ÝÓë»Ö¸´²ßÂÔ
5.9.3. ×Ô¶¯»Ö¸´
5.9.4. ±íά»¤ºÍ±ÀÀ£»Ö¸´
5.9.5. myisamchk£ºMyISAM±íά»¤ÊµÓù¤¾ß
5.9.6. ½¨Á¢±íά»¤¼Æ»®
5.9.7. »ñÈ¡¹ØÓÚ±íµÄÐÅÏ¢


µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html


Ïà¹ØÎÊ´ð£º

PHPÁ¬½ÓMYSQLÐèÒªÁ¬½ÓÆ÷Âð

ÎÒ°²×°µÄÊÇappserv-win32-2.4.4a.exe×éºÏ°ü£¬ÎÒÔÚmysqlÖд´½¨ÁËÒ»¸ödb_bookÊý¾Ý¿â,²¢ÔÚdb_bookÊý¾Ý¿âÖд´½¨ÁËÒ»¸ötb_book±í£¬ÎÒÏëдһ¸öphp³ÌÐòÏòtb_book±íÖвåÈëÊý¾Ý£¬¿ÉÊdzöÏÖ¡°Ñ¡ÔñÊý¾Ý¿âʧ°Ü£¡¡±µÄÌáʾ£¬²»ÖªÊÇÊ ......

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

javaµ÷ÓÃmysqlÃüÁîµ¼ÈëÊý¾Ý

Java code:

public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......

javaÔõôµ÷ÓÃmysql´´½¨µÄ±í

Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ