You are not logged in.
- Topics: Active | Unanswered
#1 2012-02-14 13:00:14
- nigelvon
- Member
- Registered: 2012-02-14
- Posts: 4
[SOLVED]ssh access to mysql.
I tryed to access mysql on archlinux via ssh.
Show me the error:
2103 - Lost connection to mysql server at 'reading initial communication packet system error: 0
I searched it, set /etc/hosts.allow can resolve it.
But archlinux is not support hosts.allow anymore.
http://www.archlinux.org/news/dropping- … s-support/
Last edited by nigelvon (2012-02-14 13:28:21)
Offline
#2 2012-02-14 13:22:26
- Gcool
- Member
- Registered: 2011-08-16
- Posts: 1,456
Re: [SOLVED]ssh access to mysql.
Can you check the following in your /etc/mysql/my.cnf:
- skip-networking is commented out
- bind-address is set the to ip your mysql is listening on
Burninate!
Offline
#3 2012-02-14 13:26:34
- nigelvon
- Member
- Registered: 2012-02-14
- Posts: 4
Re: [SOLVED]ssh access to mysql.
Can you check the following in your /etc/mysql/my.cnf:
- skip-networking is commented out
- bind-address is set the to ip your mysql is listening on
Thank you, it works.
Just commented the 'skip-networking'.
Offline
#4 2012-02-17 19:47:47
- ssfdre38
- Member
- From: South San Francisco CA
- Registered: 2012-02-05
- Posts: 6
- Website
Re: [SOLVED]ssh access to mysql.
make sure that you bind MySQL to your ip address so you can remote connect to it and that you disable root from being able to be used remotely
A Complex man who likes the simple things in life.
Owner of YourIRC networks at http://yourirc.net/ and ssfdre38.com
Offline