[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