MySQLFront Cant Connect.

Azzuron · Posted: Tue Aug 13, 2002 12:11 am Post subject: MySQLFront Cant Connect.

I cant seem to get MySQL-Front to connect to my mysql server. i cant seem to figure out why the error i get is

2013: connection lost when querying the server

I read that this may require you to increase acceptably packet size but from what i can tell none of that helped, supposing i did it right. Any ideas? I dont think mySQL goes through xinet does it? I think this is the last compenent i need to get my server finaly workin the way i want it. oi. Thnx again.

_________________
--Azzuron

rac · Posted: Tue Aug 13, 2002 12:44 am Post subject:

Can you telnet to port 3306 on the machine running MySQL? If not, check to see if "skip-networking" is turned on in /etc/mysql/my.cnf.
_________________
For every higher wall, there is a taller ladder

Azzuron · Posted: Tue Aug 13, 2002 1:22 am Post subject:

my connection is refused when telneting to that port, and the line with that "skip-networking" on it is commented.
_________________
--Azzuron

rac · Posted: Tue Aug 13, 2002 1:45 am Post subject:

OK, if skip-networking is not turned on, and you're sure that mysqld is really running, then I would next turn to packet filtering. Could tcpwrappers be blocking you? Check /etc/hosts.deny and /etc/hosts.allow. Is there a firewall between the machines? Is anybody running iptables?
_________________
For every higher wall, there is a taller ladder

Azzuron · Posted: Tue Aug 13, 2002 2:45 am Post subject:

I can SSH the machine fine, its on the LAN with me, everything i do goes behind my firewall (Router). It could be that i just need to add mysql to hosts.allow, which is a thought i have had, but i didnt think mysql ran through xinet...
_________________
--Azzuron

rac · Posted: Tue Aug 13, 2002 3:50 am Post subject:

inetd != tcp-wrappers.

Unless you have turned tcp-wrappers off (USE="-tcpd'), they are on by default, and if they are on, mysql will link with them. hosts.allow and hosts.deny affect mysqld even if it is running standalone.
_________________
For every higher wall, there is a taller ladder

Azzuron · Posted: Tue Aug 13, 2002 4:18 am Post subject:

Excilent. One step closer to the edge. Now it says my host isnt allowed to use MYSQL on this server, and it lists the IP of connecting machine. Ill get to work on this one here see what i can dig out.

The answer:

rac · Posted: Tue Aug 13, 2002 4:46 am Post subject:

I find GRANT statements the easiest way to deal with this: http://www.mysql.com/doc/en/Adding_users.html
_________________
For every higher wall, there is a taller ladder

Azzuron · Posted: Tue Aug 13, 2002 4:59 am Post subject:

YES! I ran around the MYSQL site a little bit and found how to add the users. Thank you much for your time! THNX alot

.
_________________
--Azzuron