Im building from scratch, made it to the `make initialize-database` / `PATH/rt-server` option, but trying to populate the database get this error:
HTTP::Server::PSGI: Accepting connections at http://0:80/
[32095] [Fri Jul 24 01:28:20 2026] [warning]: DBD::mysql::st execute failed: You are not allowed to create a user with GRANT at /usr/sbin/../lib/RT/Handle.pm line 480. (/usr/sbin/../lib/RT/Handle.pm:480)
[32095] [Fri Jul 24 01:28:20 2026] [error]: DBD::mysql::st execute failed: You are not allowed to create a user with GRANT at /usr/sbin/../lib/RT/Handle.pm line 480.
Stack:
[/usr/sbin/../lib/RT/Handle.pm:480]
[/usr/share/html/Install/Initialize.html:117]
[/usr/share/html/Install/autohandler:60] (/usr/sbin/../lib/RT/Interface/Web/Handler.pm:216)
I am not using the “root” user, because the database is on another host, and dont want to expose the root user. Ive prepared the mariadb instance thus:
MariaDB [(none)]> create database rt;
Query OK, 1 row affected (0.000 sec)
MariaDB [(none)]> grant all privileges on rt.* to ‘rt_user’@‘%’ with grant option;
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> grant create on rt.* to ‘rt_user’@‘%’;
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.000 sec)
Searching the problem, the suggestion seems to be that the create user with grant is a deprecated statement format. My mariadb is:
mariadb Ver 15.1 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
not sure how to proceed, save make a dedicated, downgraded sql server, which ideally would avoid, would welcome any insight.