MySql 권한 관리 쿼리

mysql DB 사용

 mysql> use mysql;
 mysql> select host, user from user;
 
|    host   | user |
| localhost | root |

IP 접근 권한

GRANT ALL PRIVILEGES ON *.* to 'username'@'IP address' IDENTIFIED BY 'password';

IP 대역 접근 권한

GRANT ALL PRIVILEGES ON *.* to 'username'@'111.111.%' IDENTIFIED BY 'password';

모든 IP 접근 허용(보안 위험 주의)

GRANT ALL PRIVILEGES ON *.* to 'username'@'%' IDENTIFIED BY 'password';

적용 업데이트

flush privileges;

접근 권한 제거

DELETE FROM mysql.user WHERE host=’IP address′ AND User=’username’;