Private Networking - mysql server

Posted July 22, 2014 7.3k views

Hey all.

I was wondering if anyone could help me in what i’m doing wrong here.

I want to have a droplet be mysql server for my other droplets.
Both droplets are on amsterdam2. both with private networking turned on.
one is running ubuntu with lamp on. the other is a fresh ubuntu only with mysql installed.
i use SSH key for both servers.
i have set my bind-address to my mysql eth1 inet address.
When i set bind-adress up to the servers eth0, could i connect from my own pc.
both servers can ping each other.

I want the mysql server to only be visible on the private network

Soo. what am i doing wrong here? :)

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

never mind :D

Forgot that i should probably install a mysql client on the website server.

(read this to understand that)

by Justin Ellingwood
When your site begins to get more visitors, you may have to think about how to handle the additional traffic. One easy way of doing this is to separate your database operations from your web server so that each can handle its own load. In this guide, we'll demonstrate how to do this for a WordPress site built on Nginx by configuring a remote MySQL database.