Mailing List Archive: MythTV: Users

question regarding mythtv connect to database

Index | Next | Previous | View Threaded

a.brand5 at chello

Aug 28, 2003, 5:53 AM

Post #1 of 2 (627 views)
Permalink

question regarding mythtv connect to database

Hi,

I'm new with mythtv (seems to be great) but I get stuck with the
following:

mythtv
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv[at]localhost' (Using password: YES)

couldn't open db

Mysql is running fine and even after restarting I got the same message.
Please can you help me?

Thanks.

--
Andre Brand
RedHat 9.0, kernel 2.4.20-20.9
14:45:00 up 18:27, 5 users, load average: 1.30, 1.35, 1.30
Join the Seti[at]home project, join our team:
search_for_secondary_intelligence[at]hotmail.com
Units done:
7343
Linux counter: 168032 see http://counter.li.org

debian at nc

Aug 28, 2003, 8:03 AM

Post #2 of 2 (620 views)
Permalink

Re: question regarding mythtv connect to database [In reply to]

On Thu, 2003-08-28 at 08:53, andre wrote:
> Hi,
>
> I'm new with mythtv (seems to be great) but I get stuck with the
> following:
>
> mythtv
> Unable to connect to database!
> Driver error was [1/-1]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user: 'mythtv[at]localhost' (Using password: YES)
>
> couldn't open db
>
I had the same problem. The cause is that the password that Mythtv is
using and the one that mysql is expecting are not the same.

Now to fix it. The password the Mythtv uses is stored in a file called
mysql.txt... note that there are several of this files ($ locate
mysql.txt), one of them is under your /etc/ directory and it is
encoded. Now look into one of the other files (which are not encoded)
and you'll find out what the password is.

Next go into mysql as root and change the password for user mythtv to
the correct value. (I don't remember what the syntax is but you can
look it up...)

Another thing that could be causing you problems is that you may (as I
did) have more than one user named mythtv under mysql, but with diferent
"host" values. Run this as root and see:

mysql> use mysql;
mysql> select * from user;

if you have more than one user named mythtv then I recommend you delete
them all and then insert just one with the correct values...

hope this helped,

-jose-

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com