Kodi Community Forum
Win New router, now can't connect to MySQL - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Win New router, now can't connect to MySQL (/showthread.php?tid=205408)



New router, now can't connect to MySQL - crunchymetal - 2014-09-29

Hello,

I've had MySQL up and running on my FreeNAS machine for a few weeks now with no problem, I have 2 different machines that were able to connnect no problem. Now after upgrading to a new router neither of them will connect. Any ideas? Here's the log if it helps: http://xbmclogs.com/show.php?id=303970

Thanks for any help!


RE: New router, now can't connect to MySQL - Ned Scott - 2014-09-29

Because all of your IP addresses have changed...


RE: New router, now can't connect to MySQL - crunchymetal - 2014-09-29

Well the machines running XBMC as well as the server are all on static IPs, so that's not it. Looking into it a bit further I've run:

mysqladmin -u root -p status

And I get:

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


Checked and the file is now gone. Not sure why or how, and what to do to get it back.


RE: New router, now can't connect to MySQL - Kib - 2014-09-29

So the mysqld is running ?
What does service mysqld status say ?