Help - Search - Members - Calendar
Full Version: About Mysql....
Linuxhelp > Support > Technical Support
r_blackmoor
Hi!
I own a xbox, and have installed Xebian in it.
Xebian ip: 192.168.0.10, my computer 192.168.0.1

I did everything according to this: http://www.linuxhelp.net/guides/mysql/

except I installed mysql server 4.1, otherwise the same. Everything went according to plan, but when trying to contact mysql server from another computer in my lan, it can't. I'm using SQLyog as connection program.

It just says: Error 2003

can't connect to mysql server on '192.168.0.10' (10060)

How can I make the connection to work?
Termina
First you'll need to make sure your Xebian box doesn't have iptables running, and is connected to the internet.

iptables -F
ping yahoo.com

iptables -F shouldn't return anything, and I'm sure you'll be able to tell if you have internet via ping. wink.gif

Now, grant access for your remote computer.

GRANT ALL PRIVILEGES ON databasename.* to username@'192.168.0.1' identified by 'password';

This is from memory, I havn't tested it. Are you sure your computer is 192.168.0.1? Sounds like your routers gateway.

You might also have to edit my.cnf, read the comments. happy.gif

Good luck
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2017 Invision Power Services, Inc.