On Mon, 16 Mar 2009 02:26:59 am Jake Anderson wrote: > 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
Hi Jake, > mysql -u mythconverg -p -h localhost but mythconverg is the database not the user? > what do you mean by changed the permissions on mysql? I use the webmin module to change the settings for MYSQL. I told it allow user mythtv to connect from any port > 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 got me: /usr/bin/mysql: unknown variable 'bindaddress=0.0.0.0' what do you mean by change the user? I did notice that sometimes for some weird reason when I typed int the network IP of my server 192.... it came up as 'myth' '@' ' ' in the log window, which I thought was weird. Cheers Jon -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
