[mythtv] a MySQL problem (was: Ticket #12259: Unable to play recordings on my TV set (Philips 32PFL5007K/12 TV))

Janusz S. Bien jsbien at mimuw.edu.pl
Tue Sep 30 14:28:55 UTC 2014


Quote/Cytat - Tom Lichti <tom at redpepperracing.com> (Tue 30 Sep 2014  
02:42:04 PM CEST):


> If you've completely removed (dropped) the database, the above won't do
> anything.  If you installed from source, then run:
>
> mysql -u mythtv -p < /path/to/mythtv/src/mythtv/database/mc.sql
>
> and enter the mythtv database password. This will create the shell of the
> database again.

Thank you very much for your suggestion. I try to follow you advice,  
but have a strange problem:

--------------------------------------
user at sid4OCR:~$ mysql -uroot -psid
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 133
Server version: 5.5.39-1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant all privileges on mythconverg.* to 'mythtv'@'localhost'  
identified by 'mythtv';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye
user at sid4OCR:~$ mysql -umythtv -pmythtv <mythtv/mythtv/database/mc.sql
ERROR 1044 (42000) at line 2: Access denied for user  
'mythtv'@'localhost' to database 'mythconverg'
user at sid4OCR:~$
--------------------------------------------------


Am I making some stupid mistake?

Best regards

Janusz



-- 
Prof. dr hab. Janusz S. Bień -  Uniwersytet Warszawski (Katedra  
Lingwistyki Formalnej)
Prof. Janusz S. Bień - University of Warsaw (Formal Linguistics Department)
jsbien at uw.edu.pl, jsbien at mimuw.edu.pl, http://fleksem.klf.uw.edu.pl/~jsbien/


More information about the mythtv-dev mailing list