i want to connect mysql server from remote through TCP/IP not by unix socket

dheerajjss · 11-10-2008, 05:42 AM

how can i connect to mysql server from remote using TCP/IP not by unix socket

i am using fadora8
and my.cnf is here

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

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

bathory · 11-10-2008, 06:32 AM

Read this to see how you can do it. Apart from the option "skip-networking" in my.cnf make sure that there is no such option in your startup script.
Running

Code:

netstat -tanpl|grep mysqld

should confirm if mysqld is listening on port 3306. Then you should make sure that there is no firewall blocking that port and at last double-check the permissions you give to the remote user.

Regards