mysql problem in LAN

[LikeToMove]

First of all you MUST learn some linux basics (and mysql tuts too).

Anyway, if Im not wrong you have a problem to connect to your MySQL db over the nat..

First step: install nmap on your machine using apt-get install nmap

Start your mysqld daemon

Check if mysqld is trying to listen on your net (lo, eth0, eth1):

type as root the command ifconfig

read and copy yout eth ip
type nmap 127.0.0.1 and nmap 192.168.[CeNsOrEd].[CeNsOrEd]

If you see your listening mysqld port (3306) you need just to add wildcard % to your mysql users hosts. (If you dont understand what Im speaking for try with Google)

 

Good luck