How do I allow remote access to mysql using xampp?

Question

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?

What OS -- Linux? Windows? – Dan Carley Aug 11 '09 at 16:03 — Dan Carley, Aug 11 '09 at 16:03

innaM · Accepted Answer · 2009-08-11T20:08:53.920

7

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.

edited Aug 11 '09 at 20:08

answered Aug 11 '09 at 16:22

innaM

1,428
9
9

Any idea where I adjust that? Any security issues I ned to worry about? – sprugman Aug 11 '09 at 19:15
I assumed you had at least some knowledge about MySQL configuration. Sorry. I'll add that to my answer. – innaM Aug 11 '09 at 20:04

score 2 · Answer 2 · answered Apr 29 '10 at 07:24

2

If not found, add it.

bind-address=0.0.0.0 under mysqld

See it http://www.afella.org/mysql/my.ini

answered Apr 29 '10 at 07:24

score 0 · Answer 3 · answered Dec 21 '19 at 13:19

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.

3. Restart MySQL

More details here. You can delete the newly created row after your purpose will be solved.

How do I allow remote access to mysql using xampp?

3 Answers3