DB »ý¼º
create database testdb;
»ç¿ëÀÚ Ãß°¡
insert into user (Host, User, Password) values('%', 'aaa', password('aaa'));
insert into user (host, user, password) values('localhost','testuser',password('test'));
»ç¿ëÇÒ DB ¼³Á¤
insert into db values('%', 'db¸í', 'user¸í', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
insert into db values('localhost','testdb','testuser','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
flush privileges;
±ÇÇÑ ¼³Á¤
update user set Select_priv ='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y';
GRANT [ºÎ¿©ÇÒ±ÇÇÑ] ON [´ë»óDB¸í] to [»ç¿ëÀÚ¸í] identified by 'ºñ¹Ð¹øÈ£';
GRANT ALL PRIVILEGES ON *.* to testuser@"%" IDENTIFIED BY 'test' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* to testuser@"localhost" IDENTIFIED BY 'test' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* to testuser@"testuser@210.xxx.xxx.xxx" IDENTIFIED BY 'test' WITH GRANT OPTION;
[Tip] ÀÎÅͳÝÀÌ °¡´ÉÇÑ ´ëºÎºÐÀÇ ÄÄÇ»ÅÍ¿¡¼ ¿¬°áÀÌ °¡´ÉÇÏ°Ô ÇÏ·Á¸é % »ç¿ë
[Ãâó] MySQL »ç¿ëÀÚ »ý¼º ¹× ±ÇÇÑ ¼³Á¤|ÀÛ¼ºÀÚ ÈæÇâ
---------------------------------------------------------------------------
»ç¿ëÀÚ °èÁ¤ Ãß°¡Çϱâ
- DB »ý¼º:sample
mysql>create database sample;
- »ý¼ºµÈ µ¥ÀÌÅÍ º£À̽º º¸±â
mysql>show databases;
- »ý¼ºµÈ µ¥ÀÌÅͺ£À̽º »èÁ¦Çϱâ
mysql>drop database sample;
- ÇöÀç »ý¼ºµÇ¾î ÀÖ´Â Å×ÀÌºí º¸±â
mysql>show tables;
- ¾ÆÀ̵ð:root ºñ¹Ð¹øÈ£:1234
mysql>insert into user (host, user, password) values('localhost','root',password('1234'));
- ±ÇÇÑÁÖ±â
mysql>insert into db values('localhost','sample','root','y','y','y','y','y','y','y','y','y','y','y','y');
- ½Ã½ºÅÛ¿¡ Àû¿ë½ÃÅ°±â
mysql>flush privileges;
- »ç¿ëÀÚ °èÁ¤ ºñ¹Ð¹øÈ£ º¯°æ
mysql>update user set password=password('1234') where user='root';
|
|
|