Distinguish between MariaDB and MySQL in Kernel::Modules::Installer

[bschmalhofer]

When creating the otobo database user it is advisable to explicitly set the authentication plugin mysql_native_password . This avoid surprises when the default authentication plugin changes. E.g. when MySQL 5.7 was upgraded to MySQL 8.

For MySQL 5.7 and MySQL 8 the following statement seems to work.

CREATE USER test1@localhost IDENTIFIED WITH mysql_native_password BY 'xxxx';

However this fails for MariaDB 10.5.3, There the statement:

CREATE USER test1@localhost IDENTIFIED WITH mysql_native_password AS PASSWORD( 'xxxx' );

works.
TODO: Look at $dbh->{'mysql_serverinfo'};and use the appropriat SQL statement.

See also #37.

[bschmalhofer]

No complaints so far. Closing the issue.