[Maria/MySQL] How to allow remote client access database (원격 접속 허용 설정)

1. Connect database as root

#> mysql -uroot -p

2. Check current status

SELECT host FROM mysql.user WHERE user='[USER_NAME]';

3. Add remote authority

INSERT INTO mysql.user (host,user,password) VALUES ('[Allowed IP]', '[USER_NAME]', password('[PASSWORD]'));

GRANT ALL PRIVILEGES ON *.* TO '[USER_NAME]'@'[Allowed IP]';
FLUSH PRIVILEGES;