External MySQL Database for WoW private server (or anything else)

This can be used for any database function but for this case we are doing it for WoW Private servers to offload the queries.

create user: CREATE USER 'username'@'%' IDENTIFIED BY 'password';
apply: FLUSH PRIVILEGES;
Give permissions: GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
modify mysql config: sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
replace bind ips with 0.0.0.0
restart msyql server: sudo sytemctl restart mysql
verify mysql running: sudo systemctl status mysql