[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