How to connect my ubuntu 16.04 vm to mysql database of another server?

March 13, 2019 327 views
Databases Ubuntu 16.04

VIrtual Machine Ubuntu 16.04

Details of the “another server” (Ubuntu 16.04.5 LTS (GNU/Linux 4.4.0-1065 aws ec2 server)

1 Answer

Greetings!

I found a tutorial for this here:
https://www.techrepublic.com/article/how-to-set-up-mysql-for-remote-access-on-ubuntu-server-16-04/

It basically comes down to two steps, and that guide covers them well:

  1. Bind MySQL to 0.0.0.0 instead of 127.0.0.1
  2. Create or edit MySQL user to be a remote user (ex. ‘user’@'ipaddress’)

Jarland

Have another answer? Share your knowledge.