[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
people
-------------- 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