MySqlÓû§´´½¨¡¢ÊÚȨÒÔ¼°É¾³ý(תÌù)

he create user command:
mysql
> CREATE
 
USER
 yy IDENTIFIED 
BY
 
'
123
'
;
yy±íʾÄãÒª½¨Á¢µÄÓû§Ãû£¬ºóÃæµÄ123±íʾÃÜÂë
ÉÏÃ潨Á¢µÄÓû§¿ÉÒÔÔÚÈκεط½µÇ½¡£
Èç¹ûÒªÏÞÖÆÔڹ̶¨µØÖ·µÇ½£¬±ÈÈçlocalhost µÇ½£º
mysql
> CREATE
 
USER
 yy@localhost
 IDENTIFIED 
BY
 
'
123
'
;
grant:
mysql
> GRANT
 
ALL
 
PRIVILEGES
 
ON
 
*
.
*
 
TO
 
user
;
@
local
host
grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
¸ñʽ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
ÐÞ¸ÄÃÜÂ룺
mysql
> grant   all   privileges   on   pureftpd.*   to   koko@localhost   identified   by   'mimi';  
flush:
mysql
> flush 
privileges
;
²é¿´Óû§ÐÅÏ¢£º
mysql
> select host,user from mysql
.user;