[mythtv] a MySQL problem

[Tom Lichti]

On Tue, Sep 30, 2014 at 1:51 PM, R. G. Newbury <newbury at mandamus.org> wrote:

> On 30/09/14 10:28 AM, 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
>>
>
> Unfortunately, the answer is yes.
>
>
> user at sid4OCR:~$ mysql -umythtv -pmythtv
>                         ^
> You need a space after the '-u'..
>
>
> Even more pedantic than that, you *need* quotes around the password:

mysql -u mythtv -p 'mythtv'  <mythtv/mythtv/database/mc.sql

Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-dev/attachments/20140930/6656906e/attachment.html>