Allow Remote MySQL (MariaDB) CentOS

allow_remote.sql

-- Edit dulu file my.cnf ( biasanya di sini /etc/my.cnf )
-- [mysqld]
-- # bind sesuai dengan IP yg diijinkan 0.0.0.0 = allow all IP4
-- bind-address=0.0.0.0
-- # Disabling symbolic-links is recommended to prevent assorted security risks
-- symbolic-links=0
-- port=3306

-- Kemudian restart mysql: sudo systemctl restart mysql 
-- Login ke mysql melalui terminal (ssh): mysql -uroot -p
-- Grant All ke root, pastikan ON-nya '%'.* bukan *.* <-- tidak akan bisa ngeset database ke user
GRANT ALL PRIVILEGES ON `%`.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

-- Jalankan di terminal sesuai port yg di open
-- iptables -I INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT