mysql root 원격 접속

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;

vi /etc/mysql/my.cnf

#bind-address            = 127.0.0.1

bind-address            = 0.0.0.0