devstack cannot enable the db user for mariadb in ubuntu22.04

[Miguel Lavalle]

Since the devstack nodeset was switched in zuul to Ubuntu 22.04 (jammy) by [0], the neutron-ovn-tempest-mariadb-full master branch periodic job has been failing. It fails when executing [1]. This is because in Ubuntu 22.04, mariadb version 10.6 is installed. Per [3] and [4] authentication management was changed in version 10.4. Specifically, the way the db user is created in [5] has to be adapted to the new rules in versions 10.4 and later

[0] https://review.opendev.org/c/openstack/devstack/+/860795
[1] https://github.com/openstack/devstack/blob/fd502fe0527fee0b891135e499e6a745975412da/lib/databases/mysql#L118
[3] https://mariadb.com/kb/en/authentication-from-mariadb-104/
[4] https://mariadb.org/authentication-in-mariadb-10-4/
[5] https://github.com/openstack/devstack/blob/fd502fe0527fee0b891135e499e6a745975412da/lib/databases/mysql#L101-L124

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/devstack/+/866944

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/devstack/+/866944
Committed: https://opendev.org/openstack/devstack/commit/0a40648b3884c374e314105c33c2a20c85ab2f7f
Submitter: "Zuul (22348)"
Branch: master

commit 0a40648b3884c374e314105c33c2a20c85ab2f7f
Author: Miguel Lavalle <email address hidden>
Date: Wed Dec 7 16:51:28 2022 -0600

    Fix the db user for mariadb in ubuntu 22.04

    In Ubuntu 22.04, mariadb version 10.6 is installed. Per [0] and [1]
    authentication management was changed in version 10.4. This change
    adapts the way the db user is created to the new rules in versions
    10.4 and later.

    [0] https://mariadb.com/kb/en/authentication-from-mariadb-104/
    [1] https://mariadb.org/authentication-in-mariadb-10-4/

    Closes-Bug: #1999090
    Change-Id: I77a699a9e191eb83628ad5d361282e66744b6e4a