[mythtv] a MySQL problem

[John Pilkington]

On 30/09/14 15:28, Janusz S. Bien wrote:
> 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
>
>
>
In my case I *think* it would be

mysql -umythtv -pmythtv <  /usr/share/doc/mythtv-docs-master/database/mc.sql

HTH

John