[mythtv-users] Trying to recover from crash

James Pifer jep at obrien-pifer.com
Fri Nov 12 14:22:52 UTC 2004


Hi. I'm trying to recover from a crashed system. Thankfully I have a
mysql backup and all my recordings were on another drive. So, right now
I have the system rebuilt and ready to go. I think my problem is
granting the proper rights in the DB for the mythtv user. 

Here's what I did. 

Connected to mysql as root
mysql> create database mythconverg
mysql> connect mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    10
Current database: mythconverg

mysql> GRANT ALL PRIVILEGES ON mythconverg TO 'mythtv'@'localhost'
IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

Now if I try to import my backup using the mythtv user I get:
[root at mythtv backup]#  mysql -u mythtv -pmythtv mythconverg <
mythtv_backup.sql
ERROR 1142 at line 11: create command denied to user: 'mythtv at localhost'
for table 'callsignnetworkmap'
[root at mythtv backup]# 

Or if I try to start mythbackend I get this in the log:
2004-11-12 09:16:31 Inserting MythTV initial database information.
2004-11-12 09:16:31 Upgrading to schema version 1003
DB Error (Performing database upgrade):
Query was:
CREATE TABLE IF NOT EXISTS recordingprofiles(    id INT UNSIGNED
AUTO_INCREMENT NOT NULL PRIMARY KEY,    name VARCHAR(128),    videocodec
VARCHAR(128),    audiocodec VARCHAR(128),    UNIQUE(name));
Driver error was [2/1142]:
QMYSQL3: Unable to execute query
Database error was:
create command denied to user: 'mythtv at localhost' for table
'recordingprofiles'

What am I missing on this? Is there something else I should do first to
setup the database?

My installation is on Redhat 9 using apt for the installation of ivtv
and mythtv-suite. 

Any help is appreciated. 
James



More information about the mythtv-users mailing list