[mythtv-users] mysql 8 grant statements syntax change (just info not a problem)
Stephen Worthington
stephen_agent at jsw.gen.nz
Tue Oct 29 11:53:07 UTC 2019
On Tue, 29 Oct 2019 11:15:09 +0000, you wrote:
>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
Is MariaDB making the same changes?
More information about the mythtv-users
mailing list