[rt-users] Default password

John Oliver joliver at john-oliver.net
Thu Aug 2 16:41:16 EDT 2007

On Thu, Aug 02, 2007 at 01:44:41PM -0500, James Moseley wrote:
> Well, sounds like you have a mysql problem now.  While logged into your RT
> host, and assuming you have a mysql client installed, can you successfully
> connect the mysqld instance on  What happens when you do:
> mysql -u root -p -h
> What about:
> mysql -u root -p -h rt3
> In the examples above, you will be prompted for the password.

There is no MySQL running on .164  MySQL is on .149  I'm absolutely sure
that this is a MySQL issue... it appears that "root" on .164 doesn't
have the correct privileges on .149  I tried to at least temporarily
give root at full access on .149 but it didn't work as

My first guess is that rt-setup-database is trying to be too selective
in the permissions it's granting... we can see that it's trying to give
it creates the rt3 database it is using something other than ALL for

> Access denied for user 'root'@'' to database 'rt3' at
> /usr/sbin/rt-setup-database line 346.

Since 'root'@'' created rt3, that's the only reason I can
think of that it's failing... the creator doesn't have enough
privileges, or is assuming that the database is on localhost, if that
makes a difference.

> On Thu, Aug 02, 2007 at 02:39:18AM +0400, Ruslan Zakirov wrote:
> > Here is the DatabaseRTHost option in the config that comes into play.
> > Set it to '' before running `make initdb`. As well you can
> > use --with-db-rt-host option of the configure script to set it, note
> > that you MUST run `make install` again before `make initdb` in this
> > case.
> Ahh!
> Now I'm getting closer.
> [root at rt3 ~]# /usr/sbin/rt-setup-database --action init --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 as root.
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
> Password:
> Now creating a database for RT.
> Creating mysql database rt3.
> Now populating database schema.
> Creating database schema.
> readline() on closed filehandle SCHEMA_LOCAL at
> /usr/sbin/rt-setup-database line 192.
> Done setting up database schema.
> Now inserting database ACLs
> DBD::mysql::st execute failed: Access denied for user
> 'root'@'' to database 'rt3' at /usr/sbin/rt-setup-database
> line 345.
> Problem with statement:
> rt_user@'' IDENTIFIED BY '***********';
> Access denied for user 'root'@'' to database 'rt3' at
> /usr/sbin/rt-setup-database line 346.
> On the MySQL server, I did:
> grant all on *.* to 'root'@'' identified by '********'
> but am still getting that error.
> Thanks!

* John Oliver                             http://www.john-oliver.net/ *
*                                                                     *

More information about the rt-users mailing list