Connect to MySQL Using ODBC from a Remote Server

For this example, I will use two $5 a month Ubuntu 20.04 LTS Server Droplets from Digital Ocean.

You will need the IP Addresses of both servers, and both servers should be able to ping each other using each others IP addresses.

Server A

Install MySQL

~# sudo apt install mysql-server

Check it is running

~# sudo service mysql status