vicidial.org

im trying to connect to GoAuto's mysql from another server but im getting this error

Code: Select all

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.x.x' (113)

locally, i am able to do so. my firewall is already disabled and has my.cnf setting

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-name-resolve
skip-host-cache
max_connections=200

[mysql.server]
user=mysql
basedir=/var/lib

bind-address=192.168.x.x
port=3306

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


help. thanks.

did you restart mysql after making these changes? (perhaps even a full reboot, to be sure)

does the user attempting to log on have permission to log on FROM THAT LOCATION (FROM % or FROM the ip address of the other server)

i can easily connect to mysql if within the server.

i already performed mysqld restart, and reboot completely.

i also check other websites concerning this error but seems to be dead end.

williamconley wrote:does the user attempting to log on have permission to log on FROM THAT LOCATION (FROM % or FROM the ip address of the other server)

use iftop to verify that there is data being exchanged between the two servers and use mysql logs to find out if the request was received ...

i'll check it again tonight. thanks for add'l info.

i tried again tinkering with goAuto's mysql. i still can't access it outside ip. the only way i can access it is via phpmyadmin

What user are you trying to connect to the database?

i created another user called r00t

| % | r00t | 39aa9eb5065367ed |
| localhost | r00t | 39aa9eb5065367ed |

standard mysql question. use the mysql site for help, but you basically need to grant permission for that user to log in from % (any) or the specific ip from which you are attempting access, and be sure your mysql is configured for external access in my.cnf and be sure the port is open through your firewall.