hi, what is the best way to connect to mysql db remotely to manage the tables n fields?

    If mysql is running on a webserver, phpMyAdmin can be installed on the web server and you can access it pretty much from anywhere.

    If not, you can use the MYSQL command-line (for those hardcore types) or a GUI such as SQLYog or the MySQL GUI tools.

      Using MySQL command line requires you to have it installed on your own machine and that the server and database allows you to make that connection. Else you have to connect to the server first (most likely via SSH), and then run MySQL's CLI.

        If the ports are open, you can have phpMyAdmin set up locally to connect to a remote database. Bear in mind though that a lot of hosts close these ports, and you need them open at both ends in order for it to work. The same is true for any local software that connects to a remote MySQL install.

          Write a Reply...