Unable to Connect remotely MariaDB

[Tribalist]

HI -

I followed the installation guide on Wiki for CentOS, managed to compile the server. However when I try to use my test VPS IP for mysql connection in conf folder, server cant connect to mysql but if I use 127.0.0.1, it connects just fine.

Tried using Workbench to access my database remotely, but I can't establish a connection. Seems like the mysql server or MariaDB only allows connection from localhost or 127.0.0.1? How do I fix this?

[Magnetix]

rAthena and the database server will run on the same machine. That's why in the guide, it was set to allow connection from localhost.

If you want to remotely connect, you have to allow connection for the 'your-user'@'your-ip'. This part

Also, if you have installed a firewall or enabled iptables, you have to open and allow connection to your mysql/mariadb port.

[Chaos92]

Try to add user database privilege.

[Litro Endemic]

first make a mysql user that suit your need.

replace user, ip, password and your_db to what you need. ip can be "%" which mean can from anywhere

CREATE USER 'user'@'ip' IDENTIFIED BY 'password';
GRANT ALL ON your_db.* TO 'user'@'ip';

note: grant all is bad practice, imo just set permission as you deem fit (i am lazy to look up permission that needed for rA db).

find in file '/etc/mysql/my.cnf' set bind-address value like below. "x.x.x.x" is ip that used when created mysql user or can be set with "0.0.0.0" to match if you use "%" when created mysql user.

#
# Allow server to accept connections on all interfaces.
#
bind-address=x.x.x.x

 

Edited June 3, 2021 by Litro Endemic