[MySQL] 원격지 접속 설정

1. 모든 IP 설정

insert into mysql.user (host,user,password,ssl_cipher,x509_issuer,x509_subject) values('%','[user id]',password('[user password]'),'','','');

grant all privileges on *.* to '[user id]'@'%';

flush privileges;

2. IP 지정

insert into mysql.user (host,user,password,ssl_cipher,x509_issuer,x509_subject) VALUES ('123.123.%','[user id]',password('[user password]'),'','','');

grant all privileges on *.* to '[user id]'@'123.123.%';

flush privileges;

 - %는 모든 IP를 나타내나 localhost가 포함되어 있지는 않음

3. 읽기전용 계정

create user [user id];

set password for [user id] = password('[user password]');

grant select on *.* to [user id];

또는

insert into mysql.user (host,user,password,select_priv,ssl_cipher,x509_issuer,x509_subject) values ('%','[user id]',password('[user password]'),'Y','','','');

insert into mysql.user (host,user,password,select_priv,ssl_cipher,x509_issuer,x509_subject) values ('localhost','[user id]',password('[user password]'),'Y','','','');

select host, user, password from mysql.user;

flush privileges;