Hi Tom, There is only one my.cnf and it doesn't contain those sections with that line. From what I can determine mysql is set to listen to any address. When I forced a localhost connection, I was able to connect as both root and rt_user.
-Josh -----Original Message----- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Monday, November 16, 2009 5:38 PM To: Barron, Josh Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT Upgrade failing from 3.6.6 to 3.8.6 Try> Yes I tried connecting to mysql directly from localhost and that worked: > > [jbar...@help01 ~]$ mysql -u rt_u...@localhost -p > Enter password: > ERROR 1045 (28000): Access denied for user > 'rt_u...@localhos'@'localhost' (using password: YES) > [jbar...@help01 ~]$ mysql -u rt_user -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 138 > Server version: 5.0.77 Source distribution > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> exit; > Bye > [jbar...@help01 ~]$ On *nix, mysql programs read startup options from the following in order: /etc/my.cnf SYSCONFDIR/my.cnf $MYSQL_HOME/my.cnf The file specified with --defaults-extra-file, if any ~/.my.cnf If any of these exist, and there is a [mysql] or [client] section that contains a "host=..." line, then "mysql -u rt_user -p" will connect to that host, not localhost. To force a localhost connection, do: mysql -h localhost -u rt_user -p What I'm getting at is: are you sure your MySQL instance for RT is on localhost? -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com