[mythtv-users] mythfrontend and mythtv-setup cant connect to db

[R. G. Newbury]

Ben Edwards wrote:

> OK, now this is getting really strange.  I have removed all the
> mysql.txt files but one  and I have even changed the mythtv user to
> mythtvx and the Access Demied error changes accordingly.  If rename
> the file mythfrontend says it cant find the mysql.txt, so I it must be
> using the one I think.
> 
> BUT  'DBHostName=192.168.0.95' and the error says to 192.168.0.104
> (which is localhost).
> 
> So i put and entry in /etc/hosts '192.168.0.95 pilger' and pinged it
> to test.  I then tried  'DBHostName=pilger' and guess what error I
> get:
> 
> Access denied for user 'mythtv'@'192.168.0.104' (using password: YES)
> 
> Any idea what is going on?

No but it is clearly munged...
Try looking at the access permissions: Run

mysql -u root -p
Enter password:
 > use mysql;
 > select host,user,password from user;

This will list all users, the hosts they are entitled to access and the 
hash of their password. As root you can:

delete from user where user = 'mythtvx'; etc amd clean out everything.

Then go back and run the mc.sql script ( mysql -u root -p < mc.sql)

That script is in the mythtv/database/ folder of an SVN download. Make 
whatever amendments you want to it and try again.

Geoff



-- 
              R. Geoffrey Newbury			
            Barrister and Solicitor
       Suite 106, 150 Lakeshore Road West
          Mississauga, Ontario, L5H 3R2

         o905-271-9600 f905-271-1638
           newbury at mandamus.org

        Helping with the HTTP issue
<a href="http://www.w3.org/Protocols/">HTTP</a>