Connect MySQL database from MySQL Workbench

Connect MySQL database from MySQL Workbench

To directly connect the MySQL server from MySQL Workbench we have to allow the IP address of the system you will be accessing the MySQL Workbench from. As convenient it sounds, it isn't always feasible to do so since the some of us still have a dynamic IP address. 
In such cases, we have to allow everyone to access the MySQL database with '%' which can be a significant security risk.

However, we have an alternative solution on MySQL Workbench to connect without binding IP in Mysql Server. We can do it by over the SSH method (first SSH to the server using SSH user then log in to the MySQL user locally )

 Open MySQL workbench -> Database -> Connect Database 



Select connection method: "Standard TCP/IP over SSH"



Enter the IP:port_no in SSH Hostname, Username & password in SSH username & SSH password
For Mysql keep MySQL Hostname & port same as 127.0.0.1 and 3306 as we are connecting locally, username and password of DB you want to connect.




    • Related Articles

    • How to connect to ftp/sftp using filezilla?

      What is filezilla? Filezilla is a free and open source SFTP(secure FTP)/FTP client which is built on modern standards. It is available cross-platform (Mac, Windows and Linux) and is actively maintained. First you will need to download and install the ...

    • How to Connect to an SSH Server from Windows, macOS, or Linux

      An SSH client allows you to connect to a remote computer running an SSH server. 1. Windows The most popular and widely recommended solution for connecting to SSH servers is an open source, third-party application called PuTTY. But now with windows 10 ...

    • How to setup and install SoftEther VPN client in your windows system?

      Follow the steps below, in order to install SoftEther vpn client :  Go to the above link to download VPN-client - https://www.softether-download.com/en.aspx?product=softether From the drop down list, select software as  Soft ether VPN, component as ...

    • How to configure base URLs for a Magento 2 website?

      In this article, we are going to change the base URLs of a Magento 2 website, using the swiss army knife for Magento developers, sysadmins and devops i.e. n98-magerun2. Base URLs can be also changed from the Magento Site backend as well as from the ...

    • Using traceroute to troubleshoot network issues

      When you connect to a website, the traffic has to go through several intermediaries like your local router, your Internet service provider’s routers, onto larger networks, and so on. Traceroute shows us the path traffic takes to reach the website. It ...