Êý¾Ý¿â»ù´¡£ºMySQL Ìí¼ÓÓû§µÄÁ½ÖÖ·½·¨
ÓÐ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ûÓÐÒ»¸ö¿ÚÁî½øÐÐÁ¬½Ó²¢ÇÒ±»ÊÚÓèreloadºÍ
process¹ÜÀíȨÏÞµÄÓû§¡£ÕâÔÊÐíÓû§Ö´ÐÐmysqladmin reload¡¢mysqladmin refreshºÍmysqladmin
flush-*ÃüÁ»¹ÓÐmysqladmin processlist¡£Ã»ÓÐÊÚÓèÊý¾Ý¿âÓйصÄȨÏÞ¡£ËûÃÇÄÜÔÚÒÔºóͨ¹ý·¢³öÁíÒ»¸öGRANTÓï¾äÊÚȨ¡£
dummy£º¿ÉÒÔ²»ÓÃÒ»¸ö¿ÚÁîÁ¬½ÓµÄÒ»¸öÓû§£¬µ«ÊÇÖ»ÄÜ´Ó±¾µØÖ÷»ú¡£È«¾ÖȨÏÞ±»ÉèÖÃΪ'N'--USAGEȨÏÞÀàÐÍÔÊÐíÄãÎÞÐèȨÏ޾ͿÉÉèÖÃÒ»¸öÓû§¡£Ëü¼Ù¶¨Ä㽫ÔÚÒÔºóÊÚÓèÊý¾Ý¿âÏà¹ØµÄȨÏÞ¡£
ÄãÒ²¿ÉÒÔÖ±½Óͨ¹ý·¢³öINSERTÓï¾äÔö¼ÓͬÑùµÄÓû§´æÈ¡ÐÅÏ¢£¬È»ºó¸æËß·þÎñÆ÷ÔÙ´Î×°ÈëÊÚȨ±í£º
shell> mysql --user=root mysql
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('something'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql>
Ïà¹ØÎĵµ£º
±¾ÎÄתÔØ×Ô£ºhttp://hi.baidu.com/xiaoxiaolq/blog/item/7984dcbf15dd030018d81f27.html
MyISAMºÍInnoDBÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì£¬µ«ÊDz»Ìá¹©Ê ......
1 1 Linux Red Hat 7.2 °²×°
¡¡¡¡Red Hat Linux 7.2µÄ°²×°¹âÅ̹²ÓÐÁ½ÕÅ£ºµÚÒ»ÕÅ¿ÉÒÔÖ±½Ó´Ó¹âÅÌÆô¶¯£¬°üº¬Á˴󲿷ֵÄÈí¼þ°üºÍһЩ°²×°¹¤¾ß£»µÚ¶þÕŹâÅ̳ýÁ˸½¼ÓµÄÈí¼þ°üÍ⣬Ö÷ÒªÊÇÔ´Âë¡¢Ô¤ÀÀ°æÈí¼þµÈ¡£
¡¡¡¡Red Hat Linux 7.2µÄ°²×°½çÃæ·Ç³£ÓѺã¬×óÃæÓм´Ê±Ï꾡µÄ°ïÖúÐÅÏ¢£¬ÓÒÃæÊÇÑ¡ÏÍêÈ«Ö§³ÖÊó±ê²Ù×÷¡£
¡¡¡¡½« ......
1¡¢mysql_connect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó {3RY4HVT?
¸ñʽ£º Fv n:V\eb
resource mysql_connect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]]) _I;+p eq
Àý£º 1(V>8}zn
$conn = @mysql_connect("localhost", "username", "password") or dir(" ......
GRANT ALL PRIVILEGES
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
Sql´úÂë ¸´ÖÆ´úÂë
1. mysql -u root -pvmwaremysql>use mysql;
  ......
¶Ïµç»ò·ÇÕý³£¹Ø»ú¶øµ¼ÖÂMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)Êý¾Ý¿â³öÏÖ´íÎóÊǷdz£³£¼ûµÄÎÊÌâ¡£ÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖ·½·¨Ê¹ÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄcheck tableºÍrepair table µÄsqlÓï¾ä£¬ÁíÒ»ÖÖ·½·¨ÊÇʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÌṩµÄ¶à¸ömyisamchk, isamchkÊý¾Ý¼ì²â»Ö¸´¹¤¾ß¡£Ç°ÕßʹÓÃÆðÀ´±È½Ï¼ò±ã¡£ÍƼöʹÓá£
1. ......