Access denied for user root; remote database host

I have RT running one one VM (192.168.2.9) and MySQL (192.168.2.5)
running on another. I’ve granted permissions on all databases to
root@192.168.2.9. When I run make initialize-database it creates the
database and attempts to grant access to rt_user@localhost (MySQL
server), but fails with the error “Access denied for user
’root’@‘192.168.2.9’”.

My MySQL chops aren’t up to what they used to be. No password is set
which shouldn’t be an issue anyway since the initial connection is
made that allows the database to be created. Only after it that is
done and it attempts to grant access to rt_user does it throw the
error. Anyone know what’s going on?

-Mathew

“When you do things right, people won’t be sure you’ve done anything
at all.” - God; Futurama

Hi,

You should set DatabaseRTHost in the config or with ./configure
argument before initializing DBs.

Also, which permissions have you granted and how?On Wed, Jun 22, 2011 at 12:14 AM, Mathew Snyder mathew.snyder@gmail.com wrote:

I have RT running one one VM (192.168.2.9) and MySQL (192.168.2.5)
running on another. I’ve granted permissions on all databases to
root@192.168.2.9. When I run make initialize-database it creates the
database and attempts to grant access to rt_user@localhost (MySQL
server), but fails with the error “Access denied for user
’root’@‘192.168.2.9’”.

My MySQL chops aren’t up to what they used to be. No password is set
which shouldn’t be an issue anyway since the initial connection is
made that allows the database to be created. Only after it that is
done and it attempts to grant access to rt_user does it throw the
error. Anyone know what’s going on?


-Mathew

“When you do things right, people won’t be sure you’ve done anything
at all.” - God; Futurama


2011 Training: http://bestpractical.com/services/training.html

Best regards, Ruslan.