Make initialize database fails

I’m trying to build an RT system with a database server…

Here’s is what I get when I run make initialize database:

Working with:

Type: mysql

Host: rttest3

Name: rt4

User: rt_user

DBA: root

Now creating a mysql database rt4 for RT.

Done.

Now populating database schema.

Done.

Now inserting database ACLs.

Granting access to rt_user@‘localhost’ on rt4.

DBD::mysql::st execute failed: Access denied for user
‘root’@‘rttest2.rmtc.fedex.com’ to database ‘rt4’ at
/root/rt-4.0.11/sbin/…/lib/RT/Handle.pm line 439.

DBD::mysql::st execute failed: Access denied for user
‘root’@‘rttest2.rmtc.fedex.com’ to database ‘rt4’ at
/root/rt-4.0.11/sbin/…/lib/RT/Handle.pm line 439.

make: *** [initialize-database] Error 255

I am able to connect to the mysql server on rttest3 on rttest2 as user root.

I also ran Grant all on . to ‘root’@‘rttest2.rmtc.fedex.com

What am I missing?

Now inserting database ACLs.

Granting access to rt_user@‘localhost’ on rt4.

DBD::mysql::st execute failed: Access denied for user ‘root’@‘rttest2.rmtc.fedex.com’ to
database ‘rt4’ at /root/rt-4.0.11/sbin/…/lib/RT/Handle.pm line 439.

DBD::mysql::st execute failed: Access denied for user ‘root’@‘rttest2.rmtc.fedex.com’ to
database ‘rt4’ at /root/rt-4.0.11/sbin/…/lib/RT/Handle.pm line 439.

make: *** [initialize-database] Error 255

I am able to connect to the mysql server on rttest3 on rttest2 as user root.

I also ran Grant all on . to `root’@‘rttest2.rmtc.fedex.com

Does the rt4 database exist with a schema? It appears that part of
the process succeeded, which means that it is unlikely to be a simple
user/pass mismatch. I suspect the error message is just misleading.

rt_user@‘localhost’ tells me you probably need to set DatabaseRTHost so
that permissions are granted properly.

You can also always look in the mysql error logs.

-kevin