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

1 year ago
21

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

Loading comments...