Koozali.org: home of the SME Server

MySQL Server Access

steidley

MySQL Server Access
« on: July 21, 2005, 07:12:16 PM »
I've been trying to acces my MySQL server by ODBC, Rekall and other apps but I keep getting a refused connection. I tried to find out which port, I was assuming the default of 3306. But telneting to 3306 on all of my servers gets me a refused connection. What am I missing? Is it on a different port?

psykoben

MySQL Server Access
« Reply #1 on: July 21, 2005, 10:01:54 PM »
You need to modify your configuration to connect from a lan client because mysql is set to serve on localhost only by default on sme server.
To do this you must connect in a rootshell on the sme server and enter this 3 command lines

Code: [Select]
[root@sme root]# /sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no

[root@sme root]# /sbin/e-smith/expand-template /etc/my.cnf

[root@sme root]# /sbin/service mysqld restart


and all may work fine :-D

steidley

MySQL Server Access
« Reply #2 on: July 22, 2005, 02:29:18 AM »
That fixed it! Thank you!