CREATE DATABASE new_db;
CREATE USER 'new_user'@'%' IDENTIFIED BY 'new_user_password!';
ALTER USER 'new_user'@'%' IDENTIFIED BY 'new_user_password!';
GRANT ALL PRIVILEGES ON new_db. * TO 'new_user'@'%';
FLUSH PRIVILEGES;
USE new_db;
SHOW GRANTS FOR 'new_user'@'%';
'Routine > Database' 카테고리의 다른 글
| [mongodb]리스트내 특정 텍스트 검색 (0) | 2020.02.02 |
|---|---|
| MySQL 정렬 처리 방식 (0) | 2020.02.02 |
| MySQL 5.7.5 Handling of GROUP BY Issue (0) | 2020.02.02 |
| Useful PostgreSQL Query (0) | 2020.02.02 |