Posted on Thursday 4th January 2018
When developing or debugging code, its best practice to do everything locally, including using a local database installation. But sometimes you need access to libe data, in such cases as;
The simplest way do achieve this is using an SSH Tunnel, but when you do so be aware that you can affect live data. So only use not descructive queries, such as SELECTS.
sudo service mysql stop
ssh yourname@server -L3306:localhost:3306
Now interacting with the local version of your database will actually be interacting with the live database.