[mythtv-users] i need some myth-database sql help

[Bill Bradley]

Hmmm...are you running this on the frontend or the backend?

It looks like the install script is trying to connect as root to your mysql 
server with a password.  Unless you have changed it, mysql ships with no 
password set on the root account.  Meaning if you try and connect as root 
using a password it wont work.

rpGMQkKk is the encrypted password (of "mythtv' i believe).  Dont reinstall 
mysql, just check out your mythtv directories and look for the sql scripts 
that build the database.  If you cant find them do a <find / -name "*.sql"> 
or just download the source from mythtv.org and the sql scripts are in there.  
Once you have the scripts you can rebuild the db from scratch:

mysqladmin create mythconverg

then

mysql mythconverg < scriptname.sql...etc for each part of myth.

You will have to rerun mythsetup after doing this btw because this will blow 
out any setting you had before...

You may also want to check your privileges and grant privileges to all users 
on your subnet. not good security practice..but what the hey, you can lock it 
down after you get it working.

One final note...If you already have a working mythconverg db, you will want 
to do a mysqldump -c mythconverg > myth.sql to get all your db info backed 
up.

Hope this helps somewhat.

On Wednesday 18 February 2004 07:12 pm, bassem wrote:
> Hello,
> I've been struggling with this issue, my sql knowledge is pretty weak.
> Here's the problem:
> I've been using myth CVS and decided the easier way to use the Debian 0.14
> packages to match my frontend.
> For the life of me i can't get myth-database to install correctly.
> Here's the error that i get when i try to install:
> dpkg-reconfigure --force mythtv-database
>
> Failed to connect to database: Access denied for user: 'root@<domainname>'
> (Using password: YES) at -e line 5, <> line 1. Failed to create database
> (incorrect admin username/password?)
> If you supplied incorrect information, try:
> dpkg-reconfigure --force mythtv-database
>
> I have tried all the passwords that i ever used and i still can't get it to
> work.
>
> Now, my mysql.txt specifies :
> DBHostName=localhost
> DBUserName=mythtv
> DBPassword=mythtv
> DBName=mythconverg
>
> # Set the following if you want to use something other than the
> # machine's real hostname for identifying settings in the database.
> # This is useful if your hostname changes often, as otherwise
> # you'll need to reconfigure mythtv (or futz with the DB) every time.
> # TWO HOSTS MUST NOT USE THE SAME VALUE
> #
> #LocalHostName=my-unique-identifier-goes-here
> LocalHostName=10.15.71.102
>
> When i try mythtv/mythtv user/password i get the following:
> Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO
> mythtv at localhost IDENTIFIED BY 'rpGMQkKk'\nAccess denied for user:
> 'mythtv@%' to database 'mythconverg' at -e line 8, <> line 1.
>
> I have no idea what rpGMQkKk is ? and i don't know how to change it.
>
> Can someone please show me the errors of my way ? My last resort to to
> reinstall mysql from scratch which will be painfull.
>
> Any help will be greatly appreciated,
> Bassem