Accessing the Database Through Sequel Pro and SSH
As with sFTP, there will be times when you need to connect to your MySQL database. How do we do that? We will be using another Open Source Software Project called Sequel Pro.
Download and Install Sequel Pro: https://www.sequelpro.com/
Once open, add a new connection and then choose the SSH tab. Fill in the fields with the following information*:
Notes: Get your MySQL Root password from the file /root/.digitalocean_password on the server. You can use your SSH key that we created a few lessons ago, or you can use the password. Be sure to change the SSH Host to your server name.
Once connected, you will be able to navigate your database, add and remove users, etc. BE CAREFUL! You have the power to destroy your entire site here!!! Caution!