Page 1 of 1

Help with Backend connection

Posted: Mon Oct 08, 2018 7:02 am
by pacogp
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.

Re: Help with Backend connection

Posted: Tue Oct 09, 2018 6:41 pm
by bill6502
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.)

Re: Help with Backend connection

Posted: Fri Oct 12, 2018 7:03 am
by pacogp
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';

Re: Help with Backend connection

Posted: Fri Oct 12, 2018 9:07 am
by pacogp
Finally got fixed my problem with macports and the wiki.
Now i cannot find my tunner, open another thread.