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 |