Help with MySQl remote connections after .art upgrade

[gteh]

Hi,

I am on a Plesk 9.3 Centos 5 VPS - fresh install.

I successfully upgraded php from 5.1.6 to 5.2.12 via the atomic installer script and repo.

Since doing so I am unable to connect remotely to a MySQL databases hosted on another server.

I have not made any changes to the firewall except adding a rule to allow outgoing traffic on port 3306


When I attempt to connect to a database remotely I get this error: (obviously <host> <username> etc were replaced with real info

Code: Select all

-bash-3.2$ mysql -h<host> -P3306 -u<username> -p<password> dbname
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0

I noticed that upgrading PHP to 5.2.12 also upgraded MySQL to a version supplied by the atomic repo.

Is this error caused somehow by the upgrade, as Im pretty sure these connections were working prior to the ugprade?

thanks

[Highland]

What version of mysql were you using before?

[gteh]

What version of mysql were you using before?

not sure which exact version but it was 5.x

I ended up figuring the problem out. Ive been dealing with so much crap/troubleshooting these last few days that I overlooked something very simple

The remote server assigns database usernames beginning with the letter 'u' so a database user is 'u1234567' .. well when connecting via ssh to that database, i was doing -u1234567 instead of -uu1234567

[faris]

Arrgh! I'll bet you felt good once you figured that one out though. I can only imagine it was a real Eureka moment. I had one yesterday. I think I'm getting addicted. I just wish I didn't have to go through the horrible bits between "its broken" and "fixed it" in order to get my "Eureka!" though

Faris.

[scott]

You could always use a bathtub.

[faris]

Nah. There would be water all over the floor - In a server room?

Faris.

[gteh]

Damn right it felt good lol. Only to be followed by more problems without the easy solution but such is life

[scott]

Just ask archimedes...