[MariaDB] Connection to Maria db server in another virtual machine in same network
Hi,
I want to configure 2 machine in linode provider: 1 for web app and 1 for database.Both the machine are in the same datacenter and can ping between them.
I don't have firewall configuration enable.
I do the follow configuration in MariaDB to test:
skip-bind_addres
skip-networking=0
But I want to bind the private ip.
When I try to connect from web server to database but I found the error: Can't connect to MySQL server on 'li1509-143.members.linode.com' (113)
with the same string connection I can login in database server.
Thank you for any help!
2 Replies
I found this link to be really helpful with this:
https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/
However, it’s been my experience that instead of doing “skip-bind-address” I did “bind-address” using the private IP.
Ex: bind-address = insert Private IP here
You may need to determine where the default config file is for the bind-address information to be entered. This is a good resource to help figure out where your default config files may be:
Unfortunately, there isn’t just one way to figure this out, you’re going to need to do a lot of searching in your directories & files to figure out where to make the correct changes since configurations can be different from one instance to the next.
Another link that could be helpful: