[rt-users] Access denied for user root; remote database host

Ruslan Zakirov ruz at bestpractical.com
Tue Jun 21 16:55:58 EDT 2011


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 at 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 at 192.168.2.9. When I run `make initialize-database` it creates the
> database and attempts to grant access to rt_user at 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.



More information about the rt-users mailing list