Help with Backend connection

For discussion of topics specific to MythTV on OSX
Post Reply
pacogp
Newcomer
Posts: 5
Joined: Mon Oct 08, 2018 6:58 am
Spain

Help with Backend connection

Post by pacogp » Mon Oct 08, 2018 7:02 am

Hi, i was trying to follow the oficial guide.
Downloaded the latest version of mysql and got a lot of problems with sintax of any command:
GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost' IDENTIFIEDY BY 'mythtv';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIEDY BY 'mythtv'' at line 1

Using MAMP I can login on phpmyadmin and create mythconverg database, mythtv user and grant permission to this table, but with mythbackend I cannot login with mythtv or root.

How can I test my setup is configured correctly?

Best regards.

User avatar
bill6502
Developer
Posts: 1112
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Help with Backend connection

Post by bill6502 » Tue Oct 09, 2018 6:41 pm

Hi,

See this: https://dev.mysql.com/doc/refman/5.7/en ... cteristics
maybe you're using a version where the above syntax is deprecated.

A example test from the command line is: mysql --user=mythtv --host=localhost --password mythconverg

If you mention the source you're using, maybe I can update it (e.g. in a Wiki.)

pacogp
Newcomer
Posts: 5
Joined: Mon Oct 08, 2018 6:58 am
Spain

Re: Help with Backend connection

Post by pacogp » Fri Oct 12, 2018 7:03 am

bill6502 wrote:
Tue Oct 09, 2018 6:41 pm
Hi,

See this: https://dev mysql com/doc/refman/5.7/en/grant.html#grant-other-characteristics
maybe you're using a version where the above syntax is deprecated.

A example test from the command line is: mysql --user=mythtv --host=localhost --password mythconverg

If you mention the source you're using, maybe I can update it (e.g. in a Wiki.)
Thank you very much for support.
I'm using the wiki guide:
mythtv org/wiki/MythTV_on_Mac_OS_X

then all the commands I get error on syntax

Well I have to try it, then :
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv-password";
must be:
GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';

pacogp
Newcomer
Posts: 5
Joined: Mon Oct 08, 2018 6:58 am
Spain

Re: Help with Backend connection

Post by pacogp » Fri Oct 12, 2018 9:07 am

Finally got fixed my problem with macports and the wiki.
Now i cannot find my tunner, open another thread.

Post Reply