[mythtv-users] mysql 8 grant statements syntax change (just info not a problem)
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...
More information about the mythtv-users