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 ![]() ![]() |
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. ![]() 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/ |