본문 바로가기

DataBase/MySQL

[MySQL] 사용자 계정 추가

[mysql@dev]$ mysql -uroot -p
Enter password: 
 
(root@localhost) [(none)]> 

create database batch;
create user 'batch'@'%' identified by 'password1!'; 
grant all privileges on batch.* to batch@'%' identified by 'password1!';