MySQLÊý¾Ý¿âÖÐÓÃGRANTÓï¾äÔöÌíÐÂÓû§
MySQLÊý¾Ý¿âÖÐÓÃGRANTÓï¾äÔöÌíÐÂÓû§
Ìí¼Óʱ¼ä:2007-4-22¡¡
ÓÐ2¸ö²»Í¬µÄ·½·¨Ôö¼ÓÓû§£ºÍ¨¹ýʹÓÃGRANTÓï¾ä»òͨ¹ýÖ±½Ó²Ù×÷MySQLÊÚȨ±í¡£±È½ÏºÃµÄ·½·¨ÊÇʹÓÃGRANTÓï¾ä£¬ÒòΪËûÃÇÊǸü¼òÃ÷²¢ÇÒºÃÏñ´íÎóÉÙЩ¡£
ÏÂÃæµÄÀý×ÓÏÔʾ³öÈçºÎʹÓÃMySQL¿Í»§°²×°ÐÂÓû§¡£ÕâЩÀý×Ó¼Ù¶¨È¨ÏÞÒÑȱʡ±»°²×°¡£ÕâÒâζ×ÅΪÁ˸ı䣬Äã±ØÐëÔÚMySQLÕýÔÚÔËÐÐͬһ̨»úÆ÷ÉÏ£¬Äã±ØÐë×÷ΪMySQL rootÓû§Á¬½Ó£¬²¢ÇÒrootÓû§±ØÐë¶ÔMySQLÊý¾Ý¿âÓÐinsertȨÏÞºÍreload¹ÜÀíȨÏÞ¡£ÁíÍ⣬Èç¹ûÄã¸Ä±äÁËrootÓû§¿ÚÁÄã±ØÐëÈçϵÄMySQLÃüÁîÖ¸¶¨Ëü¡£
Äã¿ÉÒÔͨ¹ý·¢³öGRANTÓï¾äÔö¼ÓÐÂÓû§£º
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
IDENTIFIED BY 'something' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
IDENTIFIED BY 'something' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;
ÕâЩGRANTÓï¾ä°²×°3¸öÐÂÓû§£º
monty£º¿ÉÒÔ´ÓÈκεط½Á¬½Ó·þÎñÆ÷µÄÒ»¸öÍêÈ«µÄ³¬¼¶Óû§£¬µ«ÊDZØÐëʹÓÃÒ»¸ö¿ÚÁî('something'×öÕâ¸ö¡£×¢Ò⣬ÎÒÃDZØÐë¶Ômonty@localhostºÍmonty@"%"·¢³öGRANTÓï¾ä¡£Èç¹ûÎÒÃÇÔö¼ÓlocalhostÌõÄ¿£¬¶ÔlocalhostµÄÄäÃûÓû§ÌõÄ¿ÔÚÎÒÃÇ´Ó±¾µØÖ÷»úÁ¬½Ó½ÓʱÓÉmysql_install_db´´½¨µÄÌõÄ¿½«ÓÅÏÈ¿¼ÂÇ£¬ÒòΪËüÓиüÌØ¶¨µÄHost×Ö¶ÎÖµ£¬ËùÒÔÒÔuser±íÅÅÁÐ˳Ðò¿´¸üÔçµ½À´¡£
admin£º¿ÉÒÔ´ÓlocalhostûÓÐÒ»¸ö¿ÚÁî½øÐÐÁ¬½Ó²¢ÇÒ±»Ê
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......