I stumbled today a useful tool that we could use for implementing a database which also makes a map of nodes out of it. The tool is called mySQL workbench, and it's a neat tool that you can easily integrate your data into your database server. Now first of all, the application needs to establish a connection between the software and the database server. At first I used the log-in credentials that I created for the database server and it didn't work. I tried to find a lot of tutorials about how to connect the application into the server that I'm using (cPanel). A lot of trial and error and some coding including opening the terminal in Mac in order to check if the connection really works or not. There we're two type of connection that I could use, TCP/IP or TPC/IP over ssh, but both failed on me In the end, I found out from my friend, who provide the web host for us, that they don't allow ssh connection. I might have to let my friend make an additional remote access host to mySQL so that I could enter the static IP in the localhost and work out the connection of the software. I know it seems like I'm trying to take a lot of time just to use this application, but I believe that it would benefit us a lot if we could use this such amazing tool. I could also use this in the future for managing database. here are some screenshots of the application that I use including the other one called "Sequel Pro".
Here's the terminal connection I made
using ssh connection in order to check if there's
a route going on with the username/hostname credentials
No comments:
Post a Comment