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.