[mythtv-users] Access denied for user `mythtv`@`mymachine` (using password: YES)

Jeffrey J. Kosowsky mythtv at kosowsky.org
Tue Jan 12 11:56:35 UTC 2010


Simon Hobson wrote at about 08:21:42 +0000 on Tuesday, January 12, 2010:
 > Jeffrey J. Kosowsky wrote:
 > >For several years I had the frontend/backend on the same machine and
 > >had set:
 > >    mythtv-setup: [General]
 > >		Local Backend IP address: 127.0.0.1
 > >		Master Backend IP address: 127.0.0.1
 > >    mythfrontend: [Utilities/Setup][Setup][General]
 > >   		Host name: localhost
 > >		Database name: mythconverg
 > >		User: mythtv
 > >		Password: mypasswd
 > >
 > >Now I added a 2nd frontend so I changed to:
 > >    mythtv-setup: [General]
 > >		Local Backend IP address: <IP address of mymachine>
 > >		Master Backend IP address: <IP address of mymachine>
 > >    mythfrontend: [Utilities/Setup][Setup][General]
 > >   		Host name: mymachine
 > >		Database name: mythconverg
 > >		User: mythtv
 > >		Password: mypasswd
 > 
 > 
 > >- Do I need to create a new mysql user: 'mythtv'@'mymachine'?
 > >- Or is this a general mysql config issue to accept connections from
 > >   non-localhost?
 > >- Or is there something else that needs to be opened on my firewall?
 > >- Or is there other mythtv configuration that I need to change?
 > 
 > You need to add privileges to connect from each IP address you have a 
 > frontend at, or you can use % as a wildcard. At the moment, user 
 > 'mythtv' probably only has privileges from localhost. If you use 
 > something like phpmyadmin, you'll be able to do this easily by 
 > editing the user, changing 'localhost' to '%' and selecting the save 
 > a new record option.
 > 
 > Harder to explain than to do - you'll see the user mythtv at localhost 
 > will have privileges on database mythconverg, you need the same 
 > privileges for mythtv@%
 > 
 > 
Thanks that solved the problem!


More information about the mythtv-users mailing list