Connect remote MySql using ssh tunneling
This blog is related to configuration of MySql connection (which is hosted on remote server) from windows. There are two cases we can think of. You have authority to connect to remote MySQL server You do not have authority to connect directly to remote MySQL. But, you have one server which has access to MySQL and you can do SSH to this server. Use case of 2nd condition can be explained as follows MySQL server is of production database and it can be connected only from production server You do not have VPN, so that you can connect to MySQL server directly MySQL admin cannot open direct connection for your windows machine due to security reasons. lastly which is important, you can connect to production server via SSH Lets dive one by one. I assume, first scenario is quite easy and straight forward. 1. Connect to remote MySQL You can either use command line or one of MySql Workbench. To connect using command line Open command line Use fol