RTFM make initdb needs superuser rights to assign ACLs

Make initdb fails. It seems to want to assign rights, which would
require an admin login not the user login.

$ /usr/bin/perl -Ilib -I/d/u/rtweb/rt38/local/lib -I/u/rtweb/rt38/lib /
d/u/rtweb/rt38/sbin/rt-setup-database --action acl --datadir etc --dba
rtweb_tickets --prompt-for-dba-password
In order to create or update your RT database, this script needs to
connect to your mysql instance on localhost as rtweb_tickets
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
(snip)
Now inserting database ACLs
Granting access to rtweb_tickets@‘localhost’ on rtweb_tickets.
DBD::mysql::st execute failed: Access denied for user
’rtweb_tickets’@‘localhost’ to database ‘mysql’ at /d/u/rtweb/rt38/
sbin/…/lib/RT/Handle.pm line 430, line 1.
DBD::mysql::st execute failed: Access denied for user
’rtweb_tickets’@‘localhost’ to database ‘mysql’ at /d/u/rtweb/rt38/
sbin/…/lib/RT/Handle.pm line 430, line 1.

Changing the command line to use the admin login solved this:
$ /usr/bin/perl -Ilib -I/d/u/rtweb/rt38/local/lib -I/u/rtweb/rt38/lib /
d/u/rtweb/rt38/sbin/rt-setup-database --action acl --datadir etc --dba
root --prompt-for-dba-password
In order to create or update your RT database, this script needs to
connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rtweb_tickets
User: rtweb_tickets
DBA: root
Now inserting database ACLs
Granting access to rtweb_tickets@‘localhost’ on rtweb_tickets.
Done.

Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness