Ê×Ò³ | ¹«Ë¾¼ò½é | Êý¾Ý»Ö¸´ | ±¸·Ý·þÎñ | ³É¹¦°¸Àý | ¼¼ÊõÖÐÐÄ | ¿Í»§·þÎñ | ·þÎñ±¨¼Û | Êý¾Ý»Ö¸´Èí¼þ | ÁªÏµÎÒÃÇ | ±±ÑDz©¿Í  
 
  ±±¾©×ܲ¿£º 4006-505-646
  Ìì ½ò ²¿£º 4006-505-646
  ÉÏ º£ ²¿£º 4006-505-646
  Éî ÛÚ ²¿£º 4006-505-646
  ¹ã ÖÝ ²¿£º 4006-505-646
  ÖØ Çì ²¿£º 4006-505-646
  ÄÏ ¾© ²¿£º 4006-505-646
  ÆäËüµØÇø£º 4006-505-646
±±ÑÇÊý¾Ý»Ö¸´Èí¼þWindowsרҵ°æ
ÈýÐÇÊÖ»úÊý¾Ý»Ö¸´Èí¼þV1.0
±±ÑÇÆ»¹ûÊÖ»úÊý¾Ý»Ö¸´Èí¼þV2.0
±±ÑÇÓ²Å̼Ïñ»úÊý¾Ý»Ö¸´Èí¼þ V
±±ÑÇvmwareÐéÄâ»úÊý¾Ý»Ö¸´Èí¼þ
±±ÑÇÕÕƬÊý¾Ý»Ö¸´Èí¼þ
±±ÑÇÉãÏñ»úÊý¾Ý»Ö¸´Èí¼þ v2.1
±±ÑÇSybaseÊý¾Ý¿âÐÞ¸´Èí¼þ V2.
raid´ÅÅÌÕóÁÐÓ¦¼±·½°¸
HP EVA4400/6400/8400/P6000
iphone Í¨Ñ¶Â¼¶ªÊ§ÈçºÎ»Ö¸´£¿
xen server ´æ´¢¿â(sr)Ë𻵺ó
RAID6½á¹¹Ô­ÀíÏê½â£¨±±ÑÇÊý¾Ý
AIXÏÂɾ³ýLVºóµÄÏÖ³¡±£»¤ºÍÊý
RAIDË𻵺ó ¶ÔÊý¾ÝµÄÍêÕû±¸·Ý
Äúµ±Ç°µÄλÖãºÊ×Ò³ >> ¼¼ÊõÖÐÐÄ >> Êý¾Ý¿âÐÞ¸´ÎÄÀ¸ >> ÕýÎÄ

MssqlºÍMysqlµÄ°²È«ÐÔ·ÖÎö


Êý¾Ý¿âÊǵç×ÓÉÌÎñ¡¢½ðÈÚÒÔ¼°ERPϵͳµÄ»ù´¡£¬Í¨³£¶¼±£´æ×ÅÖØÒªµÄÉÌÒµ»ï°éºÍ¿Í»§ÐÅÏ¢¡£´ó¶àÊýÆóÒµ¡¢×éÖ¯ÒÔ¼°Õþ¸®²¿Ãŵĵç×ÓÊý¾Ý¶¼±£´æÔÚ¸÷ÖÖÊý¾Ý¿âÖУ¬ËûÃÇÓÃÕâЩÊý¾Ý¿â±£´æһЩ¸öÈË×ÊÁÏ£¬»¹ÕÆÎÕ×ÅÃô¸ÐµÄ½ðÈÚÊý¾Ý¡£µ«ÊÇÊý¾Ý¿âͨ³£Ã»ÓÐÏó²Ù×÷ϵͳºÍÍøÂçÕâÑùÔÚ°²È«ÐÔÉÏÊܵ½ÖØÊÓ¡£Êý¾ÝÊÇÆóÒµ£¬×éÖ¯µÄÃüÂöËùÔÚ£¬Òò´ËÑ¡ÔñÒ»¿î°²È«µÄÊý¾Ý¿âÊÇÖÁ¹ØÖØÒªµÄ¡£´óÐÍÍøÕ¾Ò»°ãʹÓÃoracle»òDB2£¬¶øÖÐСÐÍÍøÕ¾´ó¶àÊýʹÓøü¼ÓÁé»îСÇɵÄmssqlÊý¾Ý¿â»òÕßmysqlÊý¾Ý¿â¡£ÄÇô£¬ÔÚͬÑùµÄÌõ¼þÏ£¬Î¢ÈíµÄmssqlºÍÃâ·ÑµÄmysqlÄĸö¸ü¼Ó°²È«ÄØ£¿

ÎÒÔÚÎҵĻú×ÓÉÏÃæÓùÜÀíÔ±ÕʺÅĬÈÏ°²×°ÁËmssqlºÍmysqlÒÔ±ãÔÚÏàͬµÄÇé¿öϲâÊÔËûÃǵݲȫÐÔ¡£ÎÒµÄϵͳÅäÖÃÈçÏ£º²Ù×÷ϵͳMicrosoft Windows 2000 Version5.0£¬°²×°ÁËsp4£¬ftp·þÎñºÍiis·þÎñ£¬Ö§³ÖaspºÍphp¡£ÏµÍ³Ö»ÓÐÒ»¸ö¹ÜÀíÔ±ÕʺÅadmin£¬guestÕʺÅûÓнûÓá£


Ò».ϵͳÄÚ²¿°²È«ÐÔ·ÖÎö

1.mysqlÊý¾Ý¿âȨÏÞ¿ØÖÆÎÊÌâ

mysqlµÄȨÏÞ¿ØÖÆÊÇ»ùÓÚmysqlÕâ¸öÊý¾Ý¿âµÄ£¬½Ð×öÊÚȨ±í£¬Ò»¹²°üÀ¨°üÀ¨Áù¸ö±í
columns_priv£¬db£¬func£¬host£¬tables_privºÍuser¡£ÏÈʹÓÃdesc userÃüÁî²é¿´·Ç
³£ÖØÒªµÄuser±íµÄ½á¹¹ÒÔ±ã²éѯÄÚÈÝ£¬ÏÖÔÚ¿ÉÒԲ鿴ËûµÄȨÏÞÉèÖÃÁË¡£
ʹÓÃÃüÁîselect host,user,password,delete_priv,update_priv,drop_priv from user;
Õâ¸öÃüÁî²é¿´Á˼¸¸ö±È½ÏΣÏÕµÄȨÏÞ£¬ÏÔʾ½á¹ûÈçÏ£º
mysql> select host,user,password,delete_priv,update_priv,drop_priv from user;
+-----------+------+------------------+-------------+-------------+-----------+
| host | user | password | delete_priv | update_priv | drop_priv |
+-----------+------+------------------+-------------+-------------+-----------+
| localhost | root |0e4941f53f6fa106 | Y | Y | Y |
| % | root | | Y | Y | Y |
| localhost | | | Y | Y | Y |
| % | | | N | N | N |
+-----------+------+------------------+-------------+-------------+-----------+
4 rows in set (0.00 sec)
µÚÒ»Ìõ±íʾÔÚ±¾»úʹÓÃrootÓÃÃÜÂëµÇ½£¬ÓµÓÐɾ³ý¼Ç¼£¬Ð޸ļǼ£¬É¾³ý±íµÈȨÏÞ£¬
ºÃ£¬ÕâÊÇ°²È«µÄ¡£µÚ¶þÌõ±íʾÔÚÈκÎÖ÷»úʹÓÃroot²»ÐèÃÜÂëµÇ½£¬ÓµÓÐɾ³ý¼Ç¼£¬
Ð޸ļǼ£¬É¾³ý±íµÈȨÏÞ¡£µÚÈýÌõ±íʾÔÚ±¾»úÄäÃûµÇ½£¬ÓµÓÐɾ³ý¼Ç¼£¬Ð޸ļÇ
¼£¬É¾³ý±íµÈȨÏÞ¡£×îºóÌõ±íʾ¿ÉÒÔÔÙÈκÎÖ÷»úÄäÃûµÇ½£¬µ«ÊÇûÓÐÈκÎȨÏÞ¡£
ÏÔÈ»£¬µÚ¶þ£¬Èý£¬ËĶ¼ÊDz»°²È«µÄ£¡µÚ¶þÌõ²»ÓÃ˵£¬¾ÍµÚÈýÌõ¶øÑÔ£¬¾ÍËãÄãÔÚ±¾µØ
ÊÇguestȨÏÞ£¬µ«ÊÇÒ²¿ÉÒԵǽmysqlÊý¾Ý¿â£¬¶øÇÒÓµÓÐÈ«²¿È¨ÏÞ¡£ÕâÑù£¬¾Í¿ÉÒÔ¶ÔÊý
¾Ý¿âΪËùÓûΪÁË¡£
½â¾ö·½·¨£ºÈç¹ûÄã²»ÐèÒªÔ¶³Ìά»¤£¬É¾³ýµôµÚ¶þÌõ,delete from user where
host="%" and user="root";»òÕ߸øËü¼Ó¸öǿ׳µÄÃÜÂ롣ɾ³ýµÚÈýÌõ£¬delete from
user where host="localhost" and user="";


2.mysql°²×°Ä¿Â¼È¨ÏÞÎÊÌâ

mysqlĬÈÏ°²×°µ½c:\mysql£¬µ«ÊÇcÅÌĬÈÏÊÇeveryoneÍêÈ«¿ØÖÆ£¬ÓÉÓÚȨÏ޵ļ̳Ð
ÐÔ£¬c:\mysql¶ÔeveryoneÒ²ÊÇÍêÈ«¿ØÖƵģ¬ÏÔÈ»ÕâÑùÊDz»°²È«µÄ¡£ÒòΪ¶ñÒâÓû§¿ÉÒÔ
ɾ³ýÖØÒªµÄÊý¾ÝÎļþ¡£
½â¾ö·½·¨£ºÖØÐÂÉèÖÃmysqlĿ¼µÄ´æȡȨÏÞ¡£»òÕß½«mysql°²×°µ½ÆäËûĿ¼,Èç¹û
ÄãÒƶ¯Mysql·Ö·¢µ½D:\mysql£¬Äã¾Í±ØÐëʹÓÃÓÃ
D:\mysql\bin\mysqld --basedir D:\mysqlÀ´Æô¶¯mysqld£¬ÉõÖÁ»¹ÐèÒªÐÞ¸ÄËüµÄÅäÖÃ
Îļþ¡£

3.mssqlÊý¾Ý¿âȨÏÞ¿ØÖÆÎÊÌâ

mssqlÊý¾Ý¿âµÄȨÏÞ¿ØÖÆÊÇ»ùÓÚmaster¿âµÄsyslogins±í£¬ÓµÓÐËùÓÐȨÏÞµÄÕʺÅÊÇ
sa£¬ÆäËû»¹ÓÐsysadmin£¬db_ownerµÈ²»Í¬È¨ÏÞÕʺš£µ«ÊÇ£¬mssqlÊý¾Ý¿â×î¸ßȨÏÞÕÊ
ºÅsaµÄĬÈÏÃÜÂëÊÇ¿Õ£¬ÕâÑùÈç¹û°²×°µÄʱºò²»×¢Ò⣬¾Í»á¸øÊý¾Ý´øÀ´»ÙÃðÐÔµÄÔÖÄÑ¡£
¶ñÒâ¹¥»÷Õß¿ÉÒÔÐ޸ģ¬É¾³ýËùÓÐÊý¾Ý£¬¸ü¼ÓÖØÒªµÄÊÇmssqlÕʺſÉÒÔÀûÓÃÀ©Õ¹Ö´ÐÐϵ

±¾ÐÂÎŹ²4Ò³,µ±Ç°ÔÚµÚ1Ò³  1  2  3  4  

ÉÏһƪ£ºMssqlºÍMysqlµÄ°²È«ÐÔ·ÖÎö
ÏÂһƪ£ºÌ½Ë÷AccessÊý¾Ý¿â×î¼ÑNTFSȨÏÞÉèÖÃ
·µ»ØÊ×Ò³ | ÁªÏµÎÒÃÇ | ¹ØÓÚÎÒÃÇ | ÕÐƸÐÅÏ¢ | ÓÑÇéÁ´½Ó | ÍøÕ¾µØͼ | ºÏ×÷»ï°é
°æȨËùÓÐ ±±¾©±±ÑÇå·ÐǿƼ¼ÓÐÏÞ¹«Ë¾
È«¹úͳһ¿Í·þÈÈÏߣº4006-505-646
±±¾©×ܲ¿£º±±¾©Êк£µíÇøÓÀ·á»ùµØ·á»ÛÖз7ºÅвÄÁÏ´´Òµ´óÏÃB×ù205ÊÒ
¾©ICP±¸09039053ºÅ

"c c ¸