[MacPorts] #73971: mariadb-11.4-server gives wrong recommendations

[MacPorts]

#73971: mariadb-11.4-server gives wrong recommendations
-----------------------+---------------------------------
 Reporter:  ballapete  |      Owner:  (none)
     Type:  defect     |     Status:  new
 Priority:  Normal     |  Milestone:
Component:  ports      |    Version:  2.12.5
 Keywords:             |       Port:  mariadb-11.4-server
-----------------------+---------------------------------
 After installation the port recommends to perform:

 {{{
 $ sudo mkdir -p /opt/local/var/db/mariadb-11.4
 $ sudo chown _mysql:_mysql /opt/local/var/db/mariadb-11.4
 $ sudo -u _mysql /opt/local/lib/mariadb-11.4/bin/mariadb_install_db
 }}}

 but

 {{{
 root 929 /\ sudo -u _mysql
 /opt/local/lib/mariadb-11.4/bin/mariadb_install_db
 }}}

 leads to

 {{{
 sudo: /opt/local/lib/mariadb-11.4/bin/mariadb_install_db: command not
 found
 }}}

 The correct command is:

 {{{
 root 930 /\ sudo -u _mysql /opt/local/lib/mariadb-11.4/bin/mariadb-
 install-db
 Installing MariaDB/MySQL system tables in '/opt/local/var/db/mariadb-11.4'
 ...
 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 at localhost, it has no password, but you need to
 be system 'root' user to connect. Use, for example, sudo mysql
 The second is _mysql at 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-11.4/bin/mariadbd-safe
 --datadir='/opt/local/var/db/mariadb-11.4'

 You can test the MariaDB daemon with mariadb-test-run.pl
 cd '/opt/local/share/mariadb-11.4/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 931 /\
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/73971>
MacPorts <https://www.macports.org/>
Ports system for macOS