Cant connect to mysql server from outside

[EL7oot]

Hi everyone,
i turned on the option mysql db accessible from outside, but it is not reachable. current system ist Fedora Core 4 with mysql 4.1 what am i doing wrong?

i'm using "NAVICAT" program
host:82.129.14*.23*
user: web2_u1
pass:******

"errmsg"
cant connect to mysql on 82.129.14*.23* '10060'

this is my configuration

"netstat -tap"

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 1831/xinetd
tcp 0 0 *:32769 *:* LISTEN 1439/rpc.statd
tcp 0 0 *op3s *:* LISTEN 1831/xinetd
tcp 0 0 *:mysql *:* LISTEN 13672/mysqld
tcp 0 0 *op3 *:* LISTEN 1831/xinetd
tcp 0 0 *:imap *:* LISTEN 1831/xinetd
tcp 0 0 *:sunrpc *:* LISTEN 1421/portmap
tcp 0 0 *:10000 *:* LISTEN 2515/perl
tcp 0 0 *:81 *:* LISTEN 2237/ispconfig_http
tcp 0 0 82.129.14*.23*:domain *:* LISTEN 1518/named
tcp 0 0 192.168.0.101:domain *:* LISTEN 1518/named
tcp 0 0 82.129.14*.25*:domain *:* LISTEN 1518/named
tcp 0 0 server1.******.com:domain *:* LISTEN 1518/named
tcp 0 0 *:ftp *:* LISTEN 30747/proftpd: (acc
tcp 0 0 server1.*****.com:ipp *:* LISTEN 29460/cupsd
tcp 0 0 server1.*****.com:5335 *:* LISTEN 1739/mDNSResponder
tcp 0 0 server1.*****.com:rndc *:* LISTEN 1518/named
tcp 0 0 *:smtp *:* LISTEN 373/master
tcp 0 0 *:http *:* LISTEN 2381/httpd
tcp 0 0 *:ssh *:* LISTEN 1822/sshd
tcp 0 0 ::1:rndc *:* LISTEN 1518/named
tcp 0 0 *:https *:* LISTEN 2381/httpd
tcp 0 148 ::ffff:82.129.14*.25*:ssh ::ffff:82.129.14*.24*:3631 ESTABLISHED 26342/1
tcp 0 0 ::ffff:82.129.141.239:http rndgw1.beelinegprs.ru:6023 TIME_WAIT -
--------------------------------------------------------------------------
"/etc/my.cnf"
[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

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

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
--------------------------------------------------------------------------
Note: i'm very new to linux

i'm using Fedora Core 4 with tow real ip's
thanx....

[falko]

Is maybe your firewall blocking requests to port 3306 (MySQL)?

[EL7oot]

firstly thank you for interesting ....

but no i have already created rule to accept the port 3306 and this is my firewall rules from ispconfig managment section

FTP 21 tcp yes
SSH 22 tcp yes
SMTP 25 tcp yes
DNS 53 tcp yes
DNS 53 udp yes
WWW 80 tcp yes
ISPConfig 81 tcp yes
POP3 110 tcp yes
SSL (www) 443 tcp yes
Webmin 10000 tcp yes
Mysqld 3306 tcp yes

NOTE: i have tried to log in with root account,
the program returned with this error
"1045 - access denied for user 'root@82.129.14*.24*' (using password:Yes )"

*this ip is for the client machine

have you any idea aboute this problem?

sorry aboute my bad english..,

[till]

Originally Posted by EL7oot

NOTE: i have tried to log in with root account,
the program returned with this error
"1045 - access denied for user 'root@82.129.14*.24*' (using password:Yes )"

If you want to access a database from outside which you created in ISPConfig, you must use the username and password you set in ISPConfig for this database, not the root user.

If you want to connect with root from outside, you will have to change the permissions for the root user in the mysql user database table and reload mysql.

[madlew]

I to get the same problem when trying to use mySQL-Front even on my internal networ.

[brainz]

Only a suggestion but if your in a NAT enviroment...

Usually wouldnt you need to either port forward port 3306 to the servers internal ip address and (im thinking rather then connecting to root@82.129.14*.24* the connection should be to something like this root@localhost or root@192.168.*.*) in your router and also if the router has a firewall to allow for external connections to port 3306

regards
brainz

[EL7oot]

Originally Posted by brainz

Only a suggestion but if your in a NAT enviroment...

Usually wouldnt you need to either port forward port 3306 to the servers internal ip address and (im thinking rather then connecting to root@82.129.14*.24* the connection should be to something like this root@localhost or root@192.168.*.*) in your router and also if the router has a firewall to allow for external connections to port 3306

regards
brainz

thanx braniz for ur suggestion but i'm using real ip address and i'm already connected with other db's on another servers on same port .

thanx every body for helping me

i have solved the problem ...

and i don't know how