You are not logged in.

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

phunni
Member
From: Bristol, UK
Registered: 2003-08-13
Posts: 787

remote connection to mysql

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...?

Offline

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

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: remote connection to mysql

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


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

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

phunni
Member
From: Bristol, UK
Registered: 2003-08-13
Posts: 787

Re: remote connection to mysql

thanks - that worked

Offline

Board footer

Powered by FluxBB