You are not logged in.

#1 2008-03-19 16:46:20

raul_nds
Member
From: Lisbon, Portugal
Registered: 2007-06-28
Posts: 258

Mysql Problem [SOLVED]

[raul@horus ~]$ cat /etc/my.cnf | grep skip
skip-locking
skip-networking

[raul@horus ~]$ sudo /etc/rc.d/mysqld restart
:: Stopping MySQL                                                       [DONE] 
:: Starting MySQL                                                       [DONE] 
[raul@horus ~]$ telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

sad

Last edited by raul_nds (2008-06-02 21:54:14)

Offline

#2 2008-03-19 17:24:02

raul_nds
Member
From: Lisbon, Portugal
Registered: 2007-06-28
Posts: 258

Re: Mysql Problem [SOLVED]

[raul@horus ~]$ telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
Connection closed by foreign host.
[raul@horus ~]$



whyyyyyyyy

Offline

#3 2008-03-20 04:05:46

gobeav3rs297
Member
From: Portland Oregon
Registered: 2007-11-06
Posts: 60

Re: Mysql Problem [SOLVED]

Hi rual_nds,

not sure if this is what are you looking for but to connect to mysql --> http://dev.mysql.com/doc/refman/5.1/en/ … cting.html

also be sure secure your initial msql account -> http://dev.mysql.com/doc/refman/5.0/en/ … leges.html

hope that helps,

-Vincent

Offline

#4 2008-06-02 05:33:42

tsweetser
Member
Registered: 2008-02-11
Posts: 10

Re: Mysql Problem [SOLVED]

I had this problem recently. Assuming you've disabled the skip-networking startup option and have granted the proper permissions to your db user, simply add the following line to /etc/hosts.allow:
mysqld : ALL : ACCEPT

That cleared up the "Connection closed by foreign host" issue for me.

Offline

#5 2008-06-02 21:53:51

raul_nds
Member
From: Lisbon, Portugal
Registered: 2007-06-28
Posts: 258

Re: Mysql Problem [SOLVED]

tsweetser ,

That does indeed solve it smile I forgot to post the solution and mark the thread as solved

Offline

Board footer

Powered by FluxBB