Sandbox not getting created with MariaDB versions 10.4 onwards

[sunnynagra]

In MariaDB versions 10.4 onwards, it looks like all mysqld* scripts have been symlinked to mariadbd* or mariadb-*:

[root@1155792-slave1 bin]# ls -ltr mysql*
lrwxrwxrwx. 1 root root 14 Feb 1 16:21 mysql_plugin -> mariadb-plugin
lrwxrwxrwx. 1 root root 17 Feb 1 16:21 mysql_find_rows -> mariadb-find-rows
lrwxrwxrwx. 1 root root 16 Feb 1 16:21 mysql_embedded -> mariadb-embedded
lrwxrwxrwx. 1 root root 7 Feb 1 16:21 mysql -> mariadb
lrwxrwxrwx. 1 root root 15 Feb 1 16:21 mysql_waitpid -> mariadb-waitpid
lrwxrwxrwx. 1 root root 14 Feb 1 16:21 mysqlbinlog -> mariadb-binlog
lrwxrwxrwx. 1 root root 13 Feb 1 16:21 mysqladmin -> mariadb-admin
lrwxrwxrwx. 1 root root 14 Feb 1 16:21 mysqlaccess -> mariadb-access
lrwxrwxrwx. 1 root root 12 Feb 1 16:21 mysqlshow -> mariadb-show
lrwxrwxrwx. 1 root root 14 Feb 1 16:21 mysqlimport -> mariadb-import
lrwxrwxrwx. 1 root root 12 Feb 1 16:21 mysqldump -> mariadb-dump
lrwxrwxrwx. 1 root root 13 Feb 1 16:21 mysqlcheck -> mariadb-check
lrwxrwxrwx. 1 root root 12 Feb 1 16:21 mysqlslap -> mariadb-slap
lrwxrwxrwx. 1 root root 22 Feb 1 16:21 mysql_fix_extensions -> mariadb-fix-extensions
lrwxrwxrwx. 1 root root 28 Feb 1 16:21 mysql_convert_table_format -> mariadb-convert-table-format
lrwxrwxrwx. 1 root root 21 Feb 1 16:21 mysql_tzinfo_to_sql -> mariadb-tzinfo-to-sql
lrwxrwxrwx. 1 root root 21 Feb 1 16:21 mysql_setpermission -> mariadb-setpermission
lrwxrwxrwx. 1 root root 27 Feb 1 16:21 mysql_secure_installation -> mariadb-secure-installation
lrwxrwxrwx. 1 root root 18 Feb 1 16:21 mysql_install_db -> mariadb-install-db
lrwxrwxrwx. 1 root root 15 Feb 1 16:21 mysql_upgrade -> mariadb-upgrade
lrwxrwxrwx. 1 root root 20 Feb 1 16:21 mysqld_safe_helper -> mariadbd-safe-helper
lrwxrwxrwx. 1 root root 13 Feb 1 16:21 mysqld_safe -> mariadbd-safe
lrwxrwxrwx. 1 root root 14 Feb 1 16:21 mysqld_multi -> mariadbd-multi
lrwxrwxrwx. 1 root root 15 Feb 1 16:21 mysqlhotcopy -> mariadb-hotcopy
lrwxrwxrwx. 1 root root 16 Feb 1 16:21 mysqldumpslow -> mariadb-dumpslow

[root@1155792-slave1 bin]# which mariadbd
/sbin/mariadbd

[root@1155792-slave1 bin]# ls -ltr /sbin/mysqld
lrwxrwxrwx. 1 root root 8 Feb 1 16:21 /sbin/mysqld -> mariadbd

This the generates errors when trying to create a sandbox in 2 ways:

1. ERROR: 1348 Column 'Password' is not updatable

This is because in the bootstrap,sql it issues the following:

UPDATE user SET PASSWORD = PASSWORD('}5/XToM.!*\K`:') WHERE User = 'root';

This isn't allowed in MariaDB as you are now supposed to now use:

ALTER USER @ SET PASSWORD = PASSWORD('');

After fixing this in the bootstrap.sql and running the dbsake script again, you will then be presented with:

220210 02:59:42 mysqld_safe The file /root/sandbox_test/bin/mariadbd
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See https://mariadb.com/kb/en/mysqld_safe for more information

It looks like the mariadbd is not copied to the /bin directory. And the paths listed in the sandbox.sh script don't reflect this either.

Not sure how this can be rectified to identify whether MySQL/Percona or MariaDB is installed and then the specific versions, to drive how binaries are copied etc.