HOW-TO:Share libraries using MySQL: Wiki Edition
#56
On the MySQL server open a command prompt and type
Code:
netstat –a –n | findstr 3306

You should see a line similar to
Code:
192.168.0.3:3306 or
0.0.0.0:3306

if you only see
Code:
127.0.0.1:3306
then you did not configure your mysql server to offer the service on the network, but only local. This is set by default and needs to be changed in the mysql config as explained in the wiki.

From any machine you can test by opening a command prompt and
Code:
telnet 192.168.0.3 3306
and after that press <enter> a few times.
This will connect you to the mysql server and should give back a line stating the version of the server.

source: http://dev.mysql.com/doc/refman/5.5/en/c...erver.html
Reply


Messages In This Thread
RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - by Kib - 2013-06-20, 15:34


Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2
This forum uses Lukasz Tkacz MyBB addons.