Hi Tom, 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 ~]$ The first connection failed when I specified localhost but connecting directly and specifying no host worked fine. Just to verify it was connecting to localhost I deliberately typed the password wrong and it showed me using rt_u...@localhost -Josh -----Original Message----- From: Tom Lahti [mailto:t...@bitstatement.net] Sent: Monday, November 16, 2009 5:25 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 > Connect Failed Access denied for user 'rt_user'@'localhost' (using > password: YES) > So basically, it appears that my password is incorrect, HOWEVER, I can > connect to mysql using the exact user and password. Its almost like the > perl script is NOT taking the prompts. Connecting at localhost? In MySQL, the user 'rt_user'@'something-else' is not the same user as 'rt_user'@'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