Atomicorp

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
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

What version of mysql were you using before?

Highland wrote: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

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.

You could always use a bathtub.

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

Faris.

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

Just ask archimedes...