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.
Help with Backend connection
Re: Help with Backend connection
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.)
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
Thank you very much for support.bill6502 wrote: ↑Tue Oct 09, 2018 6:41 pmHi,
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.)
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
Finally got fixed my problem with macports and the wiki.
Now i cannot find my tunner, open another thread.
Now i cannot find my tunner, open another thread.