LinHES Forums
http://forum.linhes.org/

MySQL access from Windows (solved)
http://forum.linhes.org/viewtopic.php?f=17&t=8651
Page 1 of 1

Author:  Ralph [ Wed Feb 22, 2006 1:28 am ]
Post subject:  MySQL access from Windows (solved)

I’ve had this working before so I have no idea why, since upgrading from R5A26 to R5A30.2, I can’t get it working again... I want to be able to see episode, title etc. information from within Windows Explorer. At the moment I can only get durations. I’m using the MythTV DirectShow filter, version 0.10.0 from here http://sourceforge.net/projects/dsmyth

The filter works OK as I can play the .nuv files in Windows, but I can’t get access to any of the file property information from mythconverg.
In case it's relevant, /etc/mythtv/mysql.txt says
Code:
DBHostName=localhost
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg

In the ‘MySQL database’ page of the MythTV Filters Settings screen, I have username, password and host all set to mythtv and database set to mythconverg, but on pressing the ‘Test MySQL connection’ button, the error reports Can’t connect to MySQL server on ‘mythtv’ (10061)

I’ve followed the instructions here www.mythtv.org/docs/mythtv-HOWTO-6.html to allow access from any host (no security) with
Code:
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
mysql> flush privileges;

I have checked Webmin’s ‘User Permissions’ to confirm this has worked, ie. username 'mythtv' has access to database 'mythconverg' from any host, with all permissions (except ‘Grant privileges’)
Webmin’s ‘Database Permissions’ also confirms that mythconverg may be accessed by username mythtv from any host.
There was nothing set for ‘Host Permissions’ so I manually added ‘any’ host to be allowed to access mythconverg.
As far as I can tell, this setup should remove all security – yet I still don’t got no access :roll: I had this working before, without any trouble in R5A26, so I’m probably just forgetting to do something ‘obvious’ – any ideas please :?:

Author:  cesman [ Wed Feb 22, 2006 1:36 am ]
Post subject: 

Perhaps MySQL isn't listening for network connections? I'd suggest reading the phamplet, in particle the frontend section.

Author:  Ep Woody [ Wed Feb 22, 2006 1:55 am ]
Post subject: 

Maybe your windows machine isn't detecting mythtv as a host? What happens if you enter your IP-Address in the HOST?

Author:  Ralph [ Wed Feb 22, 2006 2:20 am ]
Post subject: 

cesman wrote:
Perhaps MySQL isn't listening for network connections? I'd suggest reading the phamplet, in particle the frontend section.

:D Brilliant
pamphlet wrote:
Edit /etc/mysql/my.cnf, comment out 'skip-networking'. The backend will only accept the mythtv user with a password of mythtv.
Before:
skip-networking
After
# skip-networking

Restart MySQL(as root)
# /etc/init.d/mysql restart

All working AOK now - thanks a bunch :!:

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/