mysql 권한관리 allow access from any client. 실전 임베디드 2016. 3. 2. 22

권한을 줄 때

 

grant all on dbname.* to 'user1'@'%' identified by 'password...';

 

뺏을 때

 

revoke all privileges, grant option from 'user1'@'%';

Query OK, 0 rows affected (0.00 sec)

 

Query OK, 0 rows affected (0.00 sec)