MySQLÓû§Ìí¼ÓºÍ·ÖÅäȨÏÞ
mysql> grant ȨÏÞ1,ȨÏÞ2,¡È¨ÏÞn on Êý¾Ý¿âÃû³Æ.±íÃû³Æ to Óû§Ãû@Óû§µØÖ· identified by ¡®Á¬½Ó¿ÚÁ; ȨÏÞ1,ȨÏÞ2,¡È¨ÏÞn´ú±íselect,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,fileµÈ14¸öȨÏÞ¡£µ±È¨ÏÞ1,ȨÏÞ2,¡È¨ÏÞn±»all privileges»òÕßall´úÌ棬±íʾ¸³ÓèÓû§È«²¿È¨ÏÞ¡£ µ±Êý¾Ý¿âÃû³Æ.±íÃû³Æ±»*.*´úÌ棬±íʾ¸³ÓèÓû§²Ù×÷·þÎñÆ÷ÉÏËùÓÐÊý¾Ý¿âËùÓбíµÄȨÏÞ¡£ Óû§µØÖ·¿ÉÒÔÊÇlocalhost£¬Ò²¿ÉÒÔÊÇipµØÖ·¡¢»úÆ÷Ãû×Ö¡¢ÓòÃû¡£Ò²¿ÉÒÔÓá¯%'±íʾ´ÓÈκεØÖ·Á¬½Ó¡£ ¡®Á¬½Ó¿ÚÁ²»ÄÜΪ¿Õ£¬·ñÔò´´½¨Ê§°Ü¡£ ÀýÈ磺 mysql>grant select,insert,update,delete,create,drop on vtdc.employee to joe@10.163.225.87 identified by ¡®123¡ä; ¸øÀ´×Ô10.163.225.87µÄÓû§joe·ÖÅä¿É¶ÔÊý¾Ý¿âvtdcµÄemployee±í½øÐÐselect,insert,update,delete,create,dropµÈ²Ù×÷µÄȨÏÞ£¬²¢É趨¿ÚÁîΪ123¡£ mysql>grant all privileges on vtdc.* to joe@10.163.225.87 identified by ¡®123¡ä; ¸øÀ´×Ô10.163.225.87µÄÓû§joe·ÖÅä¿É¶ÔÊý¾Ý¿âvtdcËùÓбí½øÐÐËùÓвÙ×÷µÄȨÏÞ£¬²¢É趨¿ÚÁîΪ123¡£ mysql>grant all privileges on *.* to joe@10.163.225.87 identified by ¡®123¡ä; ¸øÀ´×Ô10.163.225.87µÄÓû§joe·ÖÅä¿É¶ÔËùÓÐÊý¾Ý¿âµÄËùÓбí½øÐÐËùÓвÙ×÷µÄȨÏÞ£¬²¢É趨¿ÚÁîΪ123¡£ mysql>grant all privileges on *.* to joe@localhost identified by ¡®123¡ä; ¸ø±¾»úÓû§joe·ÖÅä¿É¶ÔËùÓÐÊý¾Ý¿âµÄËùÓбí½øÐÐËùÓвÙ×÷µÄȨÏÞ£¬²¢É趨¿ÚÁîΪ123¡£mysql>grant all privileges on *.* to joe@"%" identified by ¡®123¡ä; ¸øÓû§joe·ÖÅäÔÚÈκÎÖ÷»úÉϾù¿É¶ÔËùÓÐÊý¾Ý¿âµÄËùÓбí½øÐÐËùÓвÙ×÷µÄȨÏÞ£¬²¢É趨¿ÚÁîΪ123¡£ mysql>GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; ¸øÓû§Ö±½Ó·ÖÅägrantȨÏÞ; ȨÏÞ1,ȨÏÞ2,¡È¨ÏÞn´ú±íselect,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,fileµÈ14¸öȨÏÞ¡£
µ±È¨ÏÞ1,ȨÏÞ2,¡È¨ÏÞn±»all privileges»òÕßall´úÌ棬±íʾ¸³ÓèÓû§È«²¿È¨ÏÞ¡£
µ±Êý¾Ý¿âÃû³Æ.±íÃû³Æ±»*.*´úÌ棬±íʾ¸³ÓèÓû§²Ù×÷·þÎñÆ÷ÉÏËùÓÐÊý¾Ý¿âËùÓбíµÄȨÏÞ¡£
Óû§µØÖ·¿ÉÒÔÊÇlocalhost£¬Ò²¿ÉÒÔÊÇipµØÖ·¡¢»úÆ÷Ãû×Ö¡¢ÓòÃû¡£Ò²¿ÉÒÔÓá¯%'±íʾ´ÓÈκεØÖ·Á¬½Ó¡£
¡®Á¬½Ó¿ÚÁ²»ÄÜΪ¿Õ£¬·ñÔò´´½¨Ê§°Ü¡£
Ïà¹ØÎĵµ£º
http://immike.net/blog/2007/04/09/how-not-to-optimize-a-mysql-query/
ÕâƪÎÄÕ½¨Ò飺
£¨1£©²»ÒªÊ¹ÓÃһЩmysqlµÄtip£¬È磺SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED£¬STRAIGHT_JOIN£¬³ý·ÇûÓÐÆäËû·½·¨£¬ÒòΪÕâÑùʧȥÁËSQLµÄ¿ÉÒÆÖ²ÐÔ
£¨2£©Êʵ±¶Ô±í½øÐÐË÷Òý
£¨3£©±ÜÃâ¶Ô²»±ØÒªÊý¾ÝµÄ²éѯ
£¨4£©´¦Àí× ......
http://www.mysqlperformanceblog.com/2006/11/12/trying-archive-storage-engine/
£¨1£©ÔÚÏàͬµÄÌõ¼þÏ£¬archiveµÄÊý¾Ý´óСԶСÓÚmyisam
£¨2£©ÔÚѹËõarchiveÊý¾Ýʱ£¬bzip2ºÃÓÚgzip
£¨3£©ÐèÒªÌí¼ÓarchiveµÄ·½·¨ºÍѹËõµÄlevel£¬ÒÔÂú×㲻ͬÓû§µÄÐèÇó
£¨4£©Õâ¸ö´æ´¢ÒýÇæÊÊÓÃÓÚÈÕÖ¾Êý¾Ý
£¨5£©´ËÒýÇæ²»ÄÜupdate,delete£¬²¢ ......
ÔÚÍøÉÏ¿´Á˺ܶà¹ØÓÚwindows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖõÄÎÄÕ£¬´óÌåÉ϶¼ÊÇ»¥Ïà³Ï®£¬²»¹ýһЩ¹«¹²µÄÐÅÏ¢»¹ÊǺÜÕýÈ·µÄ£¬µ«ÊÇÕë¶ÔһЩÌرðµÄ»úÆ÷»òÕßÒòΪ¸öÈ˲»Í¬µÄÅäÖÃ×ܲ»ÄÜ°´ÕÕÎÄÕµÄÄÚÈݲÙ×÷³É¹¦£¬ÏÂÃæ˵һÖÖ½ÏΪ¼òµ¥µÄ²Ù×÷·½·¨£¬²½ÖèÈçÏ£º
1.iis°²×°£¨ÂÔ£©
2.ÏÂÔØAppServ²¢°²×°
3.ÔÚc:\½¨php5Îļþ¼Ð£¬È»ºóÔÙphp5 ......
MySQLµ¼³öºÍµ¼ÈëSQL½Å±¾
µ¼³ösql½Å±¾£º
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > ´æ·ÅλÖÃ
mysqljump -u root -p test > c:\a.sql
µ¼Èësql½Å±¾£º
Òª½¨»·¾³±äÁ¿»òÕßÔÚbinµÄĿ¼Ï£¬mysqlÕâ¸öÃüÁî²ÅÄÜʶ±ð¡£
testÊÇÄãÒªµ¼½øÈ¥µÄÊý¾Ý¿âÃû×Ö£¬ÒªÌáÇ°½¨ºÃ~~
mysql -u Óû§Ãû -p Êý¾Ý¿âÃû < ´æ·ÅλÖÃ
mysqljump -u ro ......
mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ
ÎÄÕ·ÖÀà:Êý¾Ý¿â
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£ ......