remote connection to mysql

phunni · 2005-10-09 19:31:28

I have a mysql db running on one of my computers and I want to be able to access it from a remote machine. I have created user on the db which is supposed to be allowed to connect from all hosts and the same user who is restricted to localhost (I read somewhere in the mysql docs about this being necessary). I haven't modified the installation from the arch package.

I can connect quite happily from the local machine, but whenever I try to connect from the remote machine I get a connection refused.

I have tried to connect using both Java JDBC drivers and telnet with the same result...

Can anyone shed any light on why this might be the case...?

cactus · 2005-10-10 01:01:52

edit /etc/my.cnf
comment out the 'skip networking' line
restart mysql
make sure your firefall isn't blocking the mysql port

phunni · 2005-10-10 09:22:13

thanks - that worked

Arch Linux

#1 2005-10-09 19:31:28

remote connection to mysql

#2 2005-10-10 01:01:52

Re: remote connection to mysql

#3 2005-10-10 09:22:13

Re: remote connection to mysql

Board footer