[mythtv-users] mysql 8 grant statements syntax change (just info not a problem)

jksjdevelop jksjdevelop at gmail.com
Tue Oct 29 11:15:09 UTC 2019

Just for info and save others googling.

The SQL GRANT statement has changed syntax in mysql 8.

So statements like

GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "password";

Have to be done in two steps.

CREATE USER 'mythtv'@'localhost' IDENTIFIED BY 'password';

GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';

As the old syntax is all over MythTV help info expect a lot of confused 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191029/32691e68/attachment.htm>

More information about the mythtv-users mailing list