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µØÖ·£©
Ïà¹ØÎĵµ£º
ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËƵĶ«Î÷À´×ö,ÈçÏ£º
create table myseq ( &nb ......
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:Á¬½ÓʱÌø¹ýÊ ......
http://javeye.javaeye.com/blog/558093
ÎÒÃÇÖªµÀ£¬group by¿ÉÒÔ½«sql²éѯ½á¹û°´ÕÕgroup byºóÃæÁнøÐзÖÀàÏÔʾ¡£±ÈÈ磺
Sql´úÂë
select
columnA,columnB
from
table
group
by
columnA,columnB
select columnA,columnB from table group by columnA,colum ......
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. ......