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

[Bill Meek]

On 10/31/19 1:25 PM, Dan Wilga wrote:
> On 10/31/19 1:24 PM, Gary Buhrmaster wrote:
>> On Thu, Oct 31, 2019 at 4:57 PM Mike Bibbings <mike.bibbings at gmail.com> wrote:
>> ....
>>> So anyone using *ubuntu 19.10  for a clean install of mythtv
>>> (frontend/backend) would be well advised to install mariadb-server
>>> before installing mythtv
>> Just a bit of a reality check.....
>>
>> FD: I have been using MariaDB for quite some time now
>> (I was involved in some early discussions on this list
>> regarding the (new and improved?) MariaDB offering).
>> *But* the last formal statement that I recall by a MythTV
>> elder was that MySQL is the officially supported solution,
>> and while MariaDB will be tolerated, and if possible
>> compatibility will be made to support either, if there is
>> a conflict, MySQL wins in the projects process.
>>
>> There have been random proposals to flip that to be
>> MariaDB first, and tolerate MySQL (if possible), given
>> the reality of the current distro world, but AFAIK that
>> has not gained traction among the decider class.
>>
>> As for the OP.  If you identified issues with the docs,
>> please update the wiki (it is, after all, a user contributed
>> effort, and it is only as good as people make it).
> Forgive me if I'm not seeing the issue fully, but if the only file that is affected by the MariaDB/MySQL 8 split is database/mc.sql, might it 
> not make sense to simply include a slightly different version of this one file, named something like "mc-MySQL8-or-newer.sql"? The file mc.sql 
> hasn't changed since 2008, so it's not as though adding a variant would lead to an undue maintenance cost.

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-server-changes

The NO_AUTO_CREATE_USER sql_mode has been removed.

In mysql v5.7/mariadb 10.3, HELP GRANT; already suggests this:

     CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password';
     GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

I'm looking into simply changing the existing mc.sql to the proper format
that should work in all versions of MariaDB and MySQL. Haven't found a
reason not to, yet.

-- 
Bill