Configure phpmyadmin to communicate to remote mysql server on private network
I have 2 droplets with private networking enabled (same datacenter). Both systems are running Ubuntu 18.04. I have installed Apache and PHP on my web server. I have installed mysql on my database server. Once I install phpMyAdmin on my web server, what steps need to be taken to allow connection to the database on a remote server? I did not find any tutorials to reference this situation.
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.