Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
phpMyAdmin to manage remote database
I am using two droplets for my application: one is running mySQL only, the other one runs Nginx (PHP, mysql-client etc.).
I have followed this tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql to set things up.
Everything is running fine but I would love to manage the MySQL database from the second droplet where I already have a running webserver.
I can install it but how can I tell phpMyAdmin to use the remote datebase? It looks like it tries to create a new database on the very droplet to manage its settings but the installation routine leaves no place to change that behaviour.
Any help? Thanks, Dominik