I'm using xampp and navicat to manage mysql on two dev machines (laptop & desktop). The laptop is my main machine, while the desktop acts as a local dev server for the group.
Connecting to mysql via localhost in navicat is working fine on the laptop. Is there a way (other than the http tunneling method) to allow access to the desktop from the laptop via navicat?
asked Aug 11, 2009 at 15:37
1
Just make sure that your mysql is binding to a socket on 0.0.0.0 and you should be able to connect to that socket. I guess the default is for mysql to bind to 127.0.0.1, which, of course, is hard to reach from the outside.
EDIT: The MySQL configuration file should be in .\xampp\mysql\bin\my.ini. You need to find the bind-address parameter and change it to 0.0.0.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.
answered Aug 11, 2009 at 16:22
innaMinnaM
1,4289 silver badges9 bronze badges
2
To me, this is easier and quick:
- Go to PhpMyAdmin and then: localhost/phpmyadmin -> User accounts -> Edit privileges -> Login Information
- Change Host name drop down to Any host or type any IP 192.168.0.3 or even with masking 192.168.0.% And click the button Go.
More details here. You can delete the newly created row after your purpose will be solved.
answered Dec 21, 2019 at 13:19
Connect to a database with MySQL Workbench on your shared, VPS, or Dedicated hosting account. MySQL Workbench is a free tool you can use to connect to your
server databases from your personal computer. MySQL Workbench can be Downloaded for free at the following link:
You will want to use the Windows (x86, 64-bit), MSI Installer if you are on Windows. The file we are installing in this tutorial is the mysql-workbench-gpl-5.2.47-win32.msi file.
Once you have downloaded MySQL Workbench, you can install it onto your computer. After you have the program installed, follow the steps below to set up a remote connection.
Don’t have time to read the article? Watch our walk-through video.
Add IP to your Remote MySQL
In order for you to be able to connect to your databases remotely you will need to add your local computer IP address to the Remote MySQL in cPanel. You can get your IP address by going to the following link:
What’s My IP address?
Steps to connect to your database remotely
- Open MySQL Workbench.
- Click New Connection towards the bottom left of MySQL
Workbench.
- In the
“Set up a New Connection Dialogue” box, Type your Database connection credentials. The credentials will be like the following:
Connection Name: You can name this whatever you like.
Connection Method: Standard (TCP/IP).
Hostname: You can use your domain our your cPanel IP address.
Port: 3306
Username: Your cPanel username or the user you created for the database.
Password: cPanel password or the password for the database user that was created.
Default Schema: This can be left blank.Click Test Connection.
- Type your
password and click the “Save Password in Vault” check box.Click Ok.
- MySQL Workbench should say
“Connection parameters are correct“. Click
Ok.
- Click
Ok again to accept the connection
settings.
- Now under the SQL
Development section you will see your connection listed in the Open Connection to Start Querying box. Click your newly created
account.
Now you will see the databases list in the area on the left.