[mythtv] a MySQL problem

[R.G. Newbury]

Interesting. On Fedora 20, it fails with 'mysql -uuser'.
Sorry for the top post.
Geoff

Sent with AquaMail for Android
http://www.aqua-mail.com


On September 30, 2014 4:41:49 PM David Beveridge <dave at bevhost.com> wrote:

> You don't need quotes around the password unless there is a space in it or
> something else than needs quoting
> You don't need to put a space after the -u
>
> You must not put a space after -p
>
> This should work...
> mysql -uuser -hserver -ppassword databasename
> This will also work
> mysql -u user -h server -ppassword databasename
> Although it is customary to enter the password and not put it on the
> command line eg:
> mysql -uuser -hserver -p databasename
>
> if -h is omitted defaults to localhost (/var/lib/mysql/mysql.sock)
>
> dave
>
>
>
> On Wed, Oct 1, 2014 at 6:27 AM, Tom Lichti <tom at redpepperracing.com> wrote:
>
> >
> >
> > 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
> >
> > _______________________________________________
> > mythtv-dev mailing list
> > mythtv-dev at mythtv.org
> > http://www.mythtv.org/mailman/listinfo/mythtv-dev
> > http://wiki.mythtv.org/Mailing_List_etiquette
> > MythTV Forums: https://forum.mythtv.org
> >
>
>
>
> ----------
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-dev
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org