MySQL 외부 접속 허용 설정

유키공 2019. 1. 23. 11:30

모든 IP 허용

INSERT INTO mysql.user (host,user,authentication_string,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','root',password('패스워드'),'','','');
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;


sudo nano /etc/mysql/my.cnf

#bind-address            = 127.0.0.1
bind-address            = 0.0.0.0

sudo /etc/init.d/mysql restart

저작자표시 (새창열림)