[CentOS 7] Mariadb 원격접속허용

# 에러

Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MariaDB server

# iptable 추가

vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
service iptables restart

# Mariadb 접속

/usr/local/mysql/bin/mysql -u root -p
INSERT INTO mysql.user (host,user,password) VALUES ('xxx.xxx.xxx.xxx','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'xxx.xxx.xxx.xxx';
FLUSH PRIVILEGES;

# ssl_cipher, x509_issuer, x509_subject, authentication_string 에러시

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

# error 1045

ERROR 1045 (28000): Access denied for user 'testuser'@'xxx.xxx.xxx.xxx' (using password: YES)
비밀번호 확인할 것