You are not logged in.

#1 2007-09-30 18:14:31

Shaika-Dzari
Member
From: Québec, Canada
Registered: 2006-04-14
Posts: 436
Website

[Solved] MySql No TCP Connection

Hello!

I need to access to my mysql database from school.
I forwarded the correct port on my router, comment skip-networking in my.cnf and add bind-address = 192.168.0.121.

But, I always get this error when I try to connect form another computer:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

I found this bug:
http://bugs.archlinux.org/task/3818
but i'm not really sure what I need to add in etc/hosts.allow.

Thank you for your help. wink

Last edited by Shaika-Dzari (2007-10-02 01:29:13)

Offline

#2 2007-09-30 20:22:08

harlekin
Member
From: Germany
Registered: 2006-07-13
Posts: 408

Re: [Solved] MySql No TCP Connection

As you want to connect to your computer through the internet (not a local network!), you should add the following to your /etc/hosts.allow.

mysqld: ALL: ALLOW

Also make sure, the users host is set to '%' for connections not coming from localhost.


Hail to the thief!

Offline

#3 2007-10-02 01:28:53

Shaika-Dzari
Member
From: Québec, Canada
Registered: 2006-04-14
Posts: 436
Website

Re: [Solved] MySql No TCP Connection

harlekin wrote:

As you want to connect to your computer through the internet (not a local network!), you should add the following to your /etc/hosts.allow.

mysqld: ALL: ALLOW

Also make sure, the users host is set to '%' for connections not coming from localhost.

Great!

It works!

Thank harlekin smile

Offline

Board footer

Powered by FluxBB