When running 'sudo -u _mysql /opt/local/lib/mariadb-10.11/bin/mariadb-install-db' the recommended test command fails

[ballapete (Peter "Pete" Dyballa)]

root 621 /\ sudo -u _mysql /opt/local/lib/mariadb-10.11/bin/mariadb-install-db
Installing MariaDB/MySQL system tables in '/opt/local/var/db/mariadb-10.11' ...
OK

To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is _mysql@localhost, it has no password either, but
you need to be the system '_mysql' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/opt/local' ; /opt/local/lib/mariadb-10.11/bin/mariadbd-safe --datadir='/opt/local/var/db/mariadb-10.11'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/local/share/mariadb-10.11/mysql-test' ; perl mariadb-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

root 648 /\ pd '/opt/local/share/mariadb-10.11/mysql-test'
/opt/local/share/mariadb-10.11/mysql-test /opt/local/var/macports/build /opt/mports/macports-ports /Users/pete 
root 649 /\ top -l 1 | egrep -i 'sql|maria'
40362  mariadbd         0.0  00:00.22 7      0    28     78M   0B    0B    40362 1     sleeping *0[1]        0.00000 0.00000    74  23108     778     83         31         12699      250        2996       1       668       0.0   0      0      40     _mysql             N/A    N/A   N/A   N/A   N/A   N/A  
root 650 /\ perl mariadb-test-run.pl
Logging: mariadb-test-run.pl  
VS config: 
mysql-test-run: *** ERROR: Could not find any of /opt/local/share/mariadb/charsets /opt/local/share/mysql/charsets /opt/local/sql/share/charsets /opt/local/share/charsets

[ballapete (Peter "Pete" Dyballa)]

The proper way to initialise the db is:

sudo -u _mysql /opt/local/lib/mariadb-<version>/bin/mariadb-install-db  --auth-root-authentication-method=normal

See #73977.