How to access MySQL DB through the LAN network from another computer

How to access MySQL DB through the LAN network from another computer

So you have MySQL on your web server, but it is only open to local ports by default for security reasons. If you want to access your database from a client tool like MySQL Query Browser, which would normally have to open up access to local IP address … but that is not so sure. 

So instead, we'll just use port forwarding through the SSH tunnel, so that his client believes that MySQL is the connection to localhost, but actually connecting to another server through the tunnel. 

If you are using the ssh command line, the command would look like. (You can do the same graphically in putty or SecureCRT options if necessary) 

ssh-L 3306: localhost: 3306 geek@webserver. com 

The syntax is ssh-L hostname @ . We are using localhost as the hostname, as it directly accesses the remote MySQL server via ssh. You can also use this technique in the port forward through a ssh server to another server. 

If you already have MySQL running on your local machine, you can use a different local port for port forwarding, and just set the client tools to access MySQL on a different port.

Once you have the ssh tunnel, you can start the MySQL Query Browser and enter the details of your remote server using localhost as the server, and set the port to what you use.