[mythtv-users] Cannot log into database?

[Mache Creeger]

I just replaced my MBE this past weekend and had a similar problem. 
While I was working with Fedora 9, the solution I found might help you.

I brought the new software load up, including mythtv and mysql. 
Loaded mythtv, and then ran

$ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql

I seemed to have similar problems to the ones you have been seeing. 
Nothing worked. It drove me crazy for a day until...

I erased mysql and deleted /var/lib/mysql.

# yum erase mysql
# rm -f -R /var/lib/mysql

Note** yum also erased 6 other dependent programs.

Then I slowly reloaded the mysql environment.

# yum install mysql <as well as other dependent programs that were erased>

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('<root password>') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

I then installed the empty mythconverg. Because this was a restore of 
an existing environment, I did think I needed not do this before.

$ mysql -u root -p < /usr/share/doc/mythtv-0.20/database/mc.sql
(your path may be a little different depending on distribution also 
enter the password you just set above when prompted)

Then I erased and re-created mythconverge in accordance with the 
database restore documentation 
(http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5)

$ mysql -u root -p
mysql> drop database mythconverg;
mysql> create database mythconverg;
mysql> flush privileges;
mysql> exit

Finally I reloaded the backup of mythconverg

$ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql

Everything worked after that.

-- Mache

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080721/84221f14/attachment.htm