To be able to do this you should have the following:
- permission to set-up and configure your hosting database
- username and password to access the database
1. Login to your web hosting control panel and select the option for Remote MySQL.
*You need this because we want to access the database remotely, using SQL Yog.
If you're using SiteGround's hosting, the icon for Remote MySQL looks like this:
2. Add an access host.
You can get your public IP Address and put it as access host. This means that your IP address will be recognized by the database so that you can access it. If you're not sure of your IP address, you can put the percentage (%) which means "wild card". This will allow ANY IP ADDRESS to access your database. This will work but is DANGEROUS so better set your IP instead.
3. Set-up SQL Yog to access your website's server.
Just input the credentials and you're good to go. Be careful with your live data! Make sure to BACK-UP first before touching anything. And oh, secure your backup in a proper location too!
The values are as follows:
Saved Connections - this is the name of your connection just for you to easily recognize it. Any name will do.
MySQL Host Address - this is the name of your website (ex. www.example.com) where your database is located. Note that if the database is in a different server you may put a different name here. You can also put the IP Address instead.
Username - your database username. The one that you used to access your database.
Password - your database password.
Hope this helps.