LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   i want to connect mysql server from remote through TCP/IP not by unix socket (https://www.linuxquestions.org/questions/linux-newbie-8/i-want-to-connect-mysql-server-from-remote-through-tcp-ip-not-by-unix-socket-682326/)

dheerajjss 11-10-2008 05:42 AM

i want to connect mysql server from remote through TCP/IP not by unix socket
 
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


All times are GMT -5. The time now is 07:27 AM.