Upgrading MySQL

[scott9824]

Hi,

I have a new DA server. I'm testing it out vs. cPanel (which I have used for years), and I must say I'm loving DirectAdmin.

I've reached a problem. How should I go about upgrading MySQL from 4.0 to 4.1? Is there a script similar to building Apache, or should I do it manually?

rpm -qa | grep mysql returns nothing, so it's not as easy as a few RPM's.

Thanks,
Scott

 

[scott9824]

look in /usr/local/directadmin/scripts for building.

Also, it's rpm -qa | grep MySQL.

Thanks, didn't realize it was case sensitive.

 

[scott9824]

I upgraded to the latest 4.1 version using mysql.sh, but I'm getting the following error.

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Any ideas?

Thanks!

 

[nobaloney]

What client is giving you the error?

Jeff

 

[scott9824]

Sorry, I should have mentioned I got this fixed by updating the root password using OLD_PASSWORD instead of PASSWORD.

There's plenty on Google, just takes time to find what works in your situation.

Scott.

 

[nobaloney]

It appears you've run into the same issue I ran into when upgrading MySQL.

I've written a few posts about it.

Jeff