MySQL 접속 유저 추가

# 현재 유저별 호스트 확인
select user,host,password from mysql.user order by user;

# 유저 추가
create user 'ID'@'a.b.c.d' identified by 'PASSWD';
grant all privileges on *.* to 'ID'@'a.b.c.d' with grant option;
flush privileges;

 

5.7 버전 이상시

select user,host,authentication_string from mysql.user order by user;

create user 'id'@'a.b.c.d59' identified by 'passwd';
grant all privileges on *.* to 'id'@'a.b.c.d' with grant option;

flush privileges;