Question
phpMyAdmin to manage remote database
- Posted on February 26, 2017
- MySQLUbuntu 16.04
Asked by Dominik
Hello guys,
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
@dmnkhhn
phpMyAdmin is definitely one way to manage your databases, though what I recommend to my own clients is a slightly smaller tool that offers the majority of the functionality that phpMyAdmin does in a single file. That tool would be Adminer.
https://www.adminer.org/#download
It’s a single PHP file, requires no installation and it just works regardless of what directory you drop it in to. The biggest benefit is that unlike phpMyAdmin, you can just delete the file when you’re done and then you no longer need to worry about security or removing other configuration.
You can use
wgetto pull down the file from a server, or you can upload it manually. As long as PHP is running on the server you pull it to, it’ll just work.As far as connecting to a remote MySQL server, that too is possible, as long as the server you’re connecting to has been configured to accept remote connections – i.e. port 3306 is open and the bind-address is set to either a public IPv4 address or a private network IPv4 address (which is useful when the Droplets are in the same data center).
@dmnkhhn i also want to know that.
my own project is under development and when ill put it on production im gonna need same thing you are looking.
take a look at this and please let me know it works or not. http://stackoverflow.com/questions/16801573/how-to-access-remote-server-with-local-phpmyadmin-client