So, I am loving my DH (DreamHost) server; the control panel is great, and the CS team on point (although I haven’t bothered them with this topic yet).
I have been developing a site locally which utilizes mySQL DB’s and am now trying to port it over to my DH server.
After several house of reading through the wiki and Googling I am feeling really lost and looking for a helping hand.
I would rather not have to use the “shell account” and need to enter command lines to edit my databases.
I am looking for a GUI (Graphical User Interface) based MySQL editor such as phpMyAdmin (which I have been using locally), but the DH Wiki says that connecting to phpMyAdmin directly will expose my user name and password. I am not a fan of that and am looking for more security.
It has been suggested that I use Putty to connect via SSH, but how do I go about setting that up, and would I be able to use a 3rd party GUI editor (I have been trying to connect, but failing to do so, with MySql Workbench)?
Any and all help is appreciated.
Thank you kindly,