Mysql accept remote connections

invader7 · 10-10-2011, 10:09 AM

Hello, i want mysql to accept remote connections so i found this guide http://www.cyberciti.biz/tips/how-do...se-server.html and i followed it.

Step # 5 Grant access to remote IP address

i want "How Do I Grant Access To An Existing Database?"

mysql> update db set Host='202.54.10.20' where Db='webdb';
mysql> update user set Host='202.54.10.20' where user='webadmin';

doesn't helped me so i added the user from the phpmyadmin page.

Finally , my mysql does not accept remote connections. Do you have another guide ? or an idea whats going wrong ?

bathory · 10-10-2011, 11:34 AM

Hi,

Make sure you don't use a "skip-networking" either in my.cnf, or in the mysqld service startup script.
You can run

Code:

netstat -tanpl|grep mysql

to see if mysqld is listening and on what IP(s)

Regards

invader7 · 10-10-2011, 12:21 PM

thanks for the command.

root@b0x:~# netstat -tanpl|grep mysql
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 28329/mysqld

root@b0x:~# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT tcp -- x.x.x.x anywhere tcp dpt:mysql

x.x.x.x = the ip of the client i want to connect

[mysqld]
#
# * Basic Settings
#
...
bind-address = my server real ip here
#skip-external-locking

bathory · 10-10-2011, 01:23 PM

Quote:

root@b0x:~# netstat -tanpl|grep mysql
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 28329/mysqld

mysqld is listening only on the local loopback interface, that's why you cannot connect from other boxes. Are you sure you use your server public IP in the "bind-address" option?
Try to comment out the "bind-address", as by default mysqld will listen on all available interfaces, and restart the service.

invader7 · 10-10-2011, 01:55 PM

Quote:

Originally Posted by bathory

mysqld is listening only on the local loopback interface, that's why you cannot connect from other boxes. Are you sure you use your server public IP in the "bind-address" option?
Try to comment out the "bind-address", as by default mysqld will listen on all available interfaces, and restart the service.

i already have it as you say , look at my latest post , the line does not have # in front of it

thanks for helping

bathory · 10-10-2011, 02:14 PM

Quote:

i already have it as you say , look at my latest post , the line does not have # in front of it

Yeah I saw that, but since it's not working (as mysqld listens on 127.0.0.1), I told you to comment it out (add the # in front) and restart mysqld.
Could be that you're using the wrong my.cnf. Usually it's located in /etc/my.cnf

invader7 · 10-10-2011, 02:30 PM

Quote:

Originally Posted by bathory

Yeah I saw that, but since it's not working (as mysqld listens on 127.0.0.1), I told you to comment it out (add the # in front) and restart mysqld.
Could be that you're using the wrong my.cnf. Usually it's located in /etc/my.cnf

its the only my.cnf

bathory · 10-10-2011, 04:23 PM

Could be the only my.cnf, but mysqld looks like it doesn't use it. Did you try to comment out the "bind-address ...' line and see what happens?
You could also edit the /etc/init.d/mysqld (or whatever is called the startup script for your distro) and add either a "--no-defaults" or a "--defaults-file=/etc/my.cnf" among the other startup options

rameshshihora · 10-10-2011, 08:36 PM

Hello,

Please check your servers /etc/hosts file.

< IP > localhost.localdomain localhost

If the above entry present the comment it our and make it like this:

< IP > <Servers FQDN>

Thanks & Regards,
Ramesh Shihora

invader7 · 10-11-2011, 04:43 AM

thanks for helping my problem solved , my.cnf had 2 bind-address lines (the other one was far too down)