[EMAIL PROTECTED] ~]# /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 10.12.14.149 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'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database
line 345.
Problem with statement:
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO
rt_user@'10.12.14.164' IDENTIFIED BY '***';
Access denied for user 'root'@'10.12.14.164' to database 'rt3' at
/usr/sbin/rt-setup-database line 346.
On the MySQL server, I did:
grant all on *.* to 'root'@'10.12.14.164' identified by ''
but am still getting that error.
I'm aware that this is almost certainly a MySQL error, but I don't think
I'll get much help from any MySQL forums since I can't tell them exactly
what /usr/sbin/rt-setup-database is doing.
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
