Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 °ÑwordÎĵµÄÚÈݵ¼ÈëmysqlÊý¾Ý¿â

ÎҼǵÃÔÚmysqlÖÐÓиöload data infile Óï¾ä¿ÉÒÔ°ÑwordÎĵµµÄÄÚÈݰ´Ò»¶¨¸ñʽµ¼ÈëÊý¾Ý¿â£¬ÕâÑùµ¼ÈëµÄÊý¾ÝÀàÐͺÃÏñÖ»ÄÜÊÇÎı¾¸ñʽµÄÊý¾Ý£¬ÇëÎÊÓÐû¸üºÃµÄ·½·¨¿ÉÒÔµ¼ÈëÊý¾Ý¿â¡£

1¡£Èç¹ûÎÒÃÇÒª°ÑÊÔÌâµ¼ÈëÌâ¿â£¬ÄÇà ......

JSP Á¬½ÓMysql Ò»Ö±Á¬½Ó²»ÉÏ

ÎÒÓõÄÊÇeclipse-jee-galileo-SR1-win32 tomca6.0 Mysql5.1 ÏÂÔØÏÂÀ´µÄÇý¶¯ÊÇmysql-connector-java-5.1.10-bin.jar ÎÒ½«Ëü·ÅÔÚÁËD:\Ŀ¼Ï²¢Ð´½øÁËϵͳ±äÁ¿calsspath »¹°ÑËü·Å½øÁËeclipse¹¤×÷ÇøµÄ ÏîÄ¿\WebContent\W ......

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

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

ÕÒmysql·þÎñͻȻµ±µôÔ­Òò

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²» ......

MySQL±àÂëµÄÎÊÌâ

ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ