[rt-users] RT Upgrade failing from 3.6.6 to 3.8.6

[Barron, Josh]

Hi Tom,

Yes I tried connecting to mysql directly from localhost and that worked:

[jbarron at help01 ~]$ mysql -u rt_user at localhost -p
Enter password: 
ERROR 1045 (28000): Access denied for user
'rt_user at localhos'@'localhost' (using password: YES)
[jbarron at 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
[jbarron at 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_user at localhost

-Josh

-----Original Message-----
From: Tom Lahti [mailto:toml at bitstatement.net] 
Sent: Monday, November 16, 2009 5:25 PM
To: Barron, Josh
Cc: rt-users at 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/
--