MySQLÖÐÔö¼ÓÐÂÓû§²¢¶ÔÆä¸³ÓèÏàӦȨÏ޵İ취
£¨1£©¸ñʽ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
£¨2£©Àý1¡¢Ôö¼ÓÒ»¸öÓû§user_1ÃÜÂëΪ123£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬ÈëMySQL£¬È»ºó¼üÈëÒÔÏÂÃüÁ
mysql> grant select,insert,update,delete on *.* to user_1@"%" identified by "123";
Àý1Ôö¼ÓµÄÓû§ÊÇÊ®·ÖΣÏյģ¬Èç¹ûÖªµÀÁËuser_1µÄÃÜÂ룬ÄÇôËû¾Í¿ÉÒÔÔÚÍøÉϵÄÈκÎһ̨µçÄÔÉϵǼÄãµÄMySQLÊý¾Ý¿â²¢¶ÔÄãµÄÊý¾ÝΪËùÓûΪÁË£¬½â¾ö°ì·¨¼ûÀý2¡£
£¨3£©Àý2¡¢Ôö¼ÓÒ»¸öÓû§user_2ÃÜÂëΪ123£¬ÈôËÓû§Ö»¿ÉÒÔÔÚlocalhostÉϵǼ£¬²¢¿ÉÒÔ¶ÔÊý¾Ý¿âaaa½øÐвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄ²Ù×÷£¨localhostÖ¸±¾µØÖ÷»ú£¬¼´MySQLÊý¾Ý¿âËùÔÚµÄÄÇ̨Ö÷»ú£©£¬ÕâÑùÓû§¼´Ê¹ÓÃÖªµÀuser_2µÄÃÜÂ룬ËûÒ²ÎÞ·¨´ÓÍøÉÏÖ±½Ó·ÃÎÊÊý¾Ý¿â£¬Ö»ÄÜͨ¹ý MYSQLÖ÷»úÀ´²Ù×÷aaa¿â¡£
mysql>grant select,insert,update,delete on aaa.* to user_2@localhost identified by "123";
£¨4£©ÓÃÐÂÔöµÄÓû§Èç¹ûµÇ¼²»ÁËMySQL£¬ÔڵǼʱÓÃÈçÏÂÃüÁ
mysql -u user_1 -p -h 192.168.113.50 £¨-hºó¸úµÄÊÇÒªµÇ¼Ö÷»úµÄipµØÖ·£©
Ïà¹ØÎĵµ£º
1.Í£µômysqld
service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
service mysqld start --skip-networking --skip-grant-tables
»òÕß
/opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
/opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
skip-grant-tables:Á¬½ÓÊ±Ìø¹ýÊ ......
½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔǰ¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔǰÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇÎ§ÈÆ×ÅÕâ¸ö×éºÏ ......
MysqlÖеÄÊÂÎñ¿ÉÒÔÔËÐÐÔÚÏÂÃæ4¸öisolation levelÖУ¬Ó°Ïì×Åselect²Ù×÷µÄ½á¹û£º
1. Read Uncommitted
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñûÓÐÌá½»µÄÄÚÈÝ
2. Read Committed
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñÒѾÌá½»µÄÄÚÈÝ
3. Repeatable Read
InnoDBµÄĬÈÏlevel£¬¿ÉÒÔÈ·±££¬ÔÚÊÂÎñÖÐÿ´ÎÖ´ÐеĶÁ²Ù×÷·µ»ØµÄ½á¹û¶¼ÓëµÚÒ»´ÎʱµÄÒ»ÖÂ
4. Seriali ......
etting up OpenLDAP with MySQL backend
ÓÃmysql×÷ºǫ́Êý¾Ý¿â°²×°openldap
author: TBONIUS
OpenLDAP is an X.500 Lightweight Directory Access Server used for
centralized authentication and directory lookups. ......
MySQL°²×°Íê³Éºó²»ÏóSQL ServerĬÈϰ²×°ÔÚÒ»¸öĿ¼£¬ËüµÄÊý¾Ý¿âÎļþ¡¢ÅäÖÃÎļþºÍÃüÁîÎļþ·Ö±ðÔÚ²»Í¬µÄĿ¼£¬Á˽âÕâЩĿ¼·Ç³£ÖØÒª£¬ÓÈÆä¶ÔÓÚLinuxµÄ³õѧÕߣ¬ÒòΪ Linux±¾ÉíµÄĿ¼½á¹¹¾Í±È½Ï¸´ÔÓ£¬Èç¹û¸ã²»Çå³þMySQLµÄ°²×°Ä¿Â¼ÄǾÍÎÞ´Ó̸ÆðÉîÈëѧϰ¡£ÏÂÃæ¾Í½éÉÜÒ»ÏÂÕ⼸¸öĿ¼¡£
£¨1£©Êý¾Ý¿âĿ¼
......