데이타베이스/MYSQL
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