Jonathan wrote:
Hi ALL,
So after a few months at out new home, I eventualy realised that our TV antena
pointed a different direction to everyone else. A bit of a tweak, an wolla! I
had (some) digital TV back on the computer.
So with this new found victory i decided to re-configure my Myth TV so I could
use it over my network.
Here begins the problems
After changing the permisions on MYSQL I can no longer access it from Myth.
Yet I can log into it from KMySQLAdmin.
How can one programme access it and another not?
HELP!!!
this is the only error I could pick up:
driver error 1/1044
Running:
Kubuntu (presumably the latest version, I'm always installing updates)
Card: PVR2000(H?) rev j
Thanks
Jon
try connecting from the command line
mysql -u mythconverg -p -h localhost
to see what usernames and passwords you should be using
cat /etc/mythtv/mysql.conf (i think its a .conf)
what do you mean by changed the permissions on mysql?
Reading between the lines I reckons you might be having a localhost
socket/tcpip mojo problem.
if you want to run other myth front ends you want to change the user
mythconverg to 'mythconverg'@'%' rather than 'mythconverg'@'localhost'
(note the quotes, if you do the grant without the quotes it can all go
pear shaped)
you will also need to edit /etc/mysql/my.conf and change "bind address"
to "0.0.0.0" or to the ip address of your network adaptor
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
