Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> About Mysql....
r_blackmoor
post Oct 17 2005, 04:17 PM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 1
Joined: 17-October 05
Member No.: 5,640



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?
Go to the top of the page
 
+Quote Post
Termina
post Oct 17 2005, 05:37 PM
Post #2


RMS is my Hero
******

Group: Support Specialist
Posts: 862
Joined: 18-February 04
From: Wisconsin
Member No.: 2,404



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


--------------------
*Points finger at the author above him* They're a witch! Burn them!
---
Vist my website!
Join me in IRC! Server: st0rage.org Channel: #UnhandledExceptions
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 20th October 2017 - 12:45 PM