Mysql upgrade

[Blondie63]

I've plesk 10.4.4 #26
Is it possible to upgrade Mysql from 5.1.41-3ubuntu12.10 to 5.5.23 ?

Blondie

 

[IgorG]

You can but if you have Ubuntu 8.04 - look at article http://kb.parallels.com/en/113620

 

[Blondie63]

Maybe this is a wrong article... talking about memory allocation error !
I've Ubuntu 10.04 !
I'd like to upgrade Mysql version to latest, if it's possible..

 

[IgorG]

I'm not sure that this version exists in official Ubuntu repository, but if yes - why not?

 

[Blondie63]

I don't know, i've asked you because sometimes there's some incompatibility with Plesk or other software..
Someone has tested it ?
To upgrade i need to do manually by command line ?

 

[IgorG]

What is a necessity for this MySQL upgrade? If everything works well, ask yourself - why would I want any possible problems? It should be done with ubuntu package manager in command line and if you have not enough expirience I recommend you leaving it as is or ask help of experienced Linux/Plesk administrator.

 

[Blondie63]

yes you're right ! i've seen that mysql 5.5 has some new features about SQL and for that reason i think to upgrade it but this is not important !
i'll wait that Parallels upgrade it with future Plesk..

 

[IgorG]

Yes, but mysql package is not shipped with Plesk but it only downloads it from original OS vendor repo and it is quite likely it may be outdated there (especially for older OS). If your OS comes with fresh version of mysql, then Plesk would run this mysql.

 

[pohyonghwang]

Hi,

Sorry to use your post.

I have a customer who mention about the following security flaw of MySQL 5.1:
http://www.theregister.co.uk/2012/06/11/mysql_mariadb_password_flaw/

And insist that we need to upgrade the MySQL to 5.5 or higher. Any way to do it? I am using CentOS 5.

thanks!