Remote connection to mysql database

[Eck HongG]

I'm using Plesk 8.6 and am finding it difficult to connect remotely to a mysql database. I've been looking at various literature online (e.g. http://kb.odin.com/1134, http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html etc) but do not understand how to go about doing this... The literature all leads to a point where I have to go "mysql>" prompt and I have no idea how to get there... I'm not sure whether this is relevant but I'm actually connecting remotely to mysql database via a php script that I wrote. Would greatly appreciate any assistance here.

 

[Eck HongG]

Some clarifications - I checked the privileges for the mysql user account for the remote connection and it actually already allows connection from a remote server. Here's my my.conf file - there's no bind-address or skip-networking...


[mysqld]
set-variable=local-infile=0
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

 

[Eck HongG]

My firewall is also not blocking port 3306.

 

[atomicturtle]

so from the remote system, try telneting to port 3306 (this is the mysql port). That would confirm that there is no network issue preventing you from accessing the host.