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

MySQL°²×° Apply security settings±¨´í1045½â¾ö·½°¸

½ñÌìΪÁ˰²×°MySQl£¬¸ãÁË5¸ö¶àÖÓ£¬ÖÐÎç·¹¶¼Ã»³Ô£¬ÏÈÊÇstart service ²»Í¨¹ý£¬ÔÙÊÇApply security settings ²»Í¨¹ý£¨±¨Á˸ö1045µÄError£©£¬ºóÀ´ÖÕÓÚTMDµÄ¸ãµ½Ëüͨ¹ýÁË£¬½â¾ö°ì·¨ÈçÏ£º
¡¶µÚÒ»Öֳɹ¦£¬µÚ¶þºÍµÚÈýÖÖûÊÔ¡·£¬µÚ¶þºÍµÚÈýÊDZðÈËÌṩµÄ¡£
·½·¨Ò»£º
1, Ð¶ÔØMySQL
2, ɾ³ýĿ¼ C:\Documents and Settings\Óû§Ãû\Application Data\MySQL
3, ÖØÐ°²×°MySQL ¾Í OK À²
·½·¨¶þ£º
Ð¶ÔØÖØ×°£¬²»ÉèrootÃÜÂ룬ÒòΪMySqlĬÈÏÃÜÂëΪ¿Õ¡£
·½·¨Èý£º
±£³ÖÏÖÔÚµÄÃÜÂ룬´ò¿ª¡°MySQL Command Line Client¡±ÊäÈëÄãµÄÃÜÂ루°²×°Ê±ÉèµÄÄǸö£¬Èç¹ûÃÜÂë²»¶Ô¿ÉÒÔÊÔÏ¿ÕÃÜÂëµÇ¼£¬ÓпÉÄܰ²×°Ê±ÃÜÂëÉèÖÃÎÞЧ£©¡£
µ±µÇ¼³É¹¦ºóÊäÈëÃüÁî:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql'); 'mysql'ΪÄãÏëÒªÉèÖõÄÐÂÃÜÂë¡£ÐÞ¸ÄÃÜÂë³É¹¦ºóÔÙÅäÖÃMysql¾ÍOKÁË¡£
¸½£ºMysql¹Ø±Õ³ö´í·äÃùµÄ°ì·¨£¬´ò¿ªMySql°²×°Ä¿Â¼Ï嵀 my.ini Îļþ£¬ÔÚ[mysql]ÐÐÏÂÌí¼ÓÕâ¸öÓï¾ä'no-beep', ±£´æ£¬ÖØÆôMysql·þÎñ¾ÍOKÁË¡£


Ïà¹ØÎĵµ£º

mysql´æ´¢¹ý³Ì£¬Óα꣬ÊÂÎï

drop procedure if exists pro_rep_shadow_rs;
delimiter |
----------------------------------
-- rep_shadow_rs
-- ÓÃÀ´´¦ÀíÐÅÏ¢µÄÔö¼Ó£¬¸üкÍɾ³ý
-- ÿ´ÎÖ»¸üÐÂÉÏ´ÎÒÔÀ´Ã»ÓÐ×ö¹ýµÄÊý¾Ý
-- ¸ù¾Ý²»Í¬µÄ±ê־λ
-- ÐèÒªÒ»¸öÊä³öµÄ²ÎÊý£¬
-- Èç¹û·µ»ØÎª0£¬Ôòµ÷ÓÃʧ°Ü£¬ÊÂÎñ»Ø¹ö
-- Èç ......

MYsql ÒìµØ±¸·Ý½Å±¾

ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒ԰Ѱ²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
 
±ÈÈçÎļþà ......

c# Á¬½ÓMySqlÊý¾Ý¿âµÄÁ½ÖÖ·½·¨

1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ

MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
 
using

S ......

ASP.NETÓëMySqlµÄÁ¬½Ó——Êý¾Ý¿â·ÃÎʲÙ×÷

1.¶Á³ö·½Ê½
DataReaderºÍDataSet¶¼¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âÊý¾ÝµÄ²éѯ·µ»Ø£¬µ«Ç°ÕßÖ»ÄÜÌṩ¿ìËٵIJéѯ·½Ê½£¬ºóÕß»¹¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄÌí¼Ó¡¢Ð޸ġ¢É¾³ý¹¦ÄÜ¡£
£¨1£©DataReader·½Ê½¶ÁÈ¡£º
string sConnString = "server=localhost;User Id=root;password=root;Persist Security Info=True;database=db_user";
MySqlConnection myC ......

mysqlÊý¾ÝË«Ïòͬ²½

2.»·¾³ËµÃ÷
2.1    Ó²¼þ»·¾³(Á½Ì¨»úÆ÷µÄÓ²¼þ»·¾³Ïàͬ)
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
Ó²ÅÌ´óС
8GB
ÆäËü˵Ã÷
±¾»úÆ÷ΪÐéÄâ»ú£¬ÆäÓÐÁ½¿éÍø¿¨£¬Ò»¶ÔÍø¿¨Ö±Á¬£¬Ò»¶Ô½ÓÈë½»»»»ú
 
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ