How to allow mysql remote access on windows

Is there a way other than the http tunneling method to allow access to the desktop from the laptop via navicat? Just make sure that your mysql is binding to a socket on 0. I guess the default is for mysql to bind to You need to find the bind-address parameter and change it to 0. Everyone on your network should then be able to connect that MySQL instance. Of course, that may include people who better shouldn't do that. But as long as there is a password for each mysql user and the instance is not facing the internet, there is not much to worry about.

Restart MySQL. More details here. You can delete the newly created row after your purpose will be solved. Sign up to join this community.

The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. How do I allow remote access to mysql using xampp? Ask Question. This will grant mysql remote access to any IP or network. This command grants access only to the table clients , inside the mydb database :. If you need to grant access specifically to more than one table, then you should run the command more than once:.

If you need to recover the mysql user password, you can also read this article. But be warned that you need to specify the desired hostname or IPs that have access to it. What is the syntax to add grant an ip range like I dont want to add the whole IP range just a small range of ip address. Your email address will not be published. Share and Enjoy! You can also use SSH to connect to servers on your local network, such as those hosted on a Raspberry Pi.

So, you will need to establish this connection first before you can proceed. By this stage, this guide will assume you have already connected to the server, PC, or Mac hosting your mySQL database remotely and have console access. The locations referenced above are the default locations for MySQL configuration files.

At this stage, your MySQL database should allow remote connections from devices using the IP address you set as the bind-address value in your MySQL configuration file or from all devices if you set this value to 0. However, connections will still be blocked by your device or network firewall. Most servers and PCs use a firewall to block connections unless access to a specific port is granted.

Many Linux servers use iptables as the default firewall utility. You can configure it by following the steps below. If you have trouble connecting, repeat these steps above, making sure to create a new outbound rule in your firewall settings using the same details port , etc. You may also need to configure your local network router to open the necessary blocked ports to allow inbound and outbound connections to your database.

You can do this using the mysql command mysql.