[mythtv-users] Trying to recover from crash

[Yan-Fa Li]

James,

you forgot to FLUSH PRIVILEGES after granting.  MySQL hasn't changed 
it's internal user state yet.  Try restarting mysql.

service mysql restart

Yan

James Pifer wrote:
> 
> 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]# 
>