I have this file in my backend server in: /home/mythtv/.mythtv/mysql.txt and I already have DBHostName=192.168.0.247 which is the ip of my server.
here how it looks like: DBHostName=192.168.0.247 DBUserName=mythtv DBPassword=mythtv DBName=mythconverg DBType=QMYSQL3 stuart-20 wrote: > > > Hi Neeesat... > > Humm, the more I think of it I don't think this is your problem, but, I > didn't see anyone asking if your /etc/mythtv/mysql.txt file had > DBHostName=localhost. I think setting it this way is Debian's way of > securing your mythtv back end's data base (i.e. both back and front ends > are on the same box). If you are using remote front ends (i.e. > mvpmc/mythtv) you need to set DBHostName to the myth backend's real IP > address. > > (assuming your myth back end is a debian distribution of linux) > > Neeesat wrote: >> First of all thank you for your replies. >> >> I gave full access with: >> >> mysql -u root mythconverg >> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv"; >> mysql> flush privileges; >> >> and I already had commented out: >> >> bind-address = 127.0.0.1 >> >> and skip-networking commands. But still I am receiving the access >> message. >> >> Any more ideas please? >> >> >> Neeesat wrote: >>> When I select LiveTV I get a message saying "You must have SQL access >>> enabled on the server to use this feature". >>> >>> On my mythconverg database I gave access to other mythtv clients in my >>> local network with: >>> >>> mysql -u root -p mythconverg >>> grant all on mythconverg.* to mythtv@"192.168.0.%" identified by >>> "mythtv"; >>> flush privileges; >>> quit >>> >>> What other SQL access does mvpmc needs? >>> >>> Thanks for helping >>> >> > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Mvpmc-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mvpmc-users > mvpmc wiki: http://mvpmc.wikispaces.com/ > > -- View this message in context: http://www.nabble.com/Give-SQL-access--tp17559190s24861p17578522.html Sent from the MediaMVP Media Center - Users mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Mvpmc-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mvpmc-users mvpmc wiki: http://mvpmc.wikispaces.com/
