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