Plesk 12, mysql 5.6 or higher

[christiano1203]

Hello,

is there a way to install mysql 5.6 or higher with plesk 12. My OS is Cent OS 6.5.

Can somebody show me how to do it ?

Thank you.

 

[IgorG]

Plesk doesn't ship MySQL, 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 MySQL 5.6, then Plesk would run MySQL 5.6 for clients.
You may use alternative repositories for your OS, Atomic, for example.

 

[Azurel]

Is here maybe a tutorial for upgrade mysql 5.5 to 5.6 on CentOS6.x with Plesk12? Its my first time to upgrade mysql to a new release series.

I have backup all databases

install repo
# yum localinstall mysql-community-release-el6-5.noarch.rpm

and tried
# yum update

but get

Transaction Check Error:
file /usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of mysql-community-libs-compat-5.6.23-2.el6.x86_64 conflicts with file from package mysqlclient16-5.1.59-2.el6.a rt.x86_64
file /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of mysql-community-libs-compat-5.6.23-2.el6.x86_64 conflicts with file from package mysqlclient16-5.1.59-2.el6 .art.x86_64

disable mysql-community.repo and enable atomic its will only update to 5.5.42-28.el6.art

What can I do?

 

[IgorG]

Here is conflict between official and Atomic repos. Looks like Atomic repo contains only 5.5 version. Try to use official instead.

 

[Azurel]

Solution (for me):

# rpm --nodeps -e mysqlclient16-5.1.59-2.el6.art.x86_64

after this

# yum update mysql

working now. I must only new install all needed php versions, because:

/usr/local/php-5.5.21/bin/php-cgi: /usr/lib64/mysql/libmysqlclient.so.18: version `libmysqlclient_16' not found (required by /usr/local/php-5.5.21/bin/php-cgi)

Is here another solution? I don't need now, but interest me.

 

[johnrdorazio]

I am also trying to upgrade mysql to 5.6 on Ubuntu 14.04. If I issue

# apt-get install mysql-server-5.6

I receive the message :

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies.
mysql-server-5.6 : Depends: mysql-server-core-5.6 (= 5.6.19-0ubuntu0.14.04.1) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

If I issue

# apt-get install mysql-server-core-5.6

I receive the message:

Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED
cloudflare-servershield libpam-plesk mysql-server mysql-server-5.5
mysql-server-core-5.5 plesk-base plesk-config-troubleshooter plesk-core
plesk-l10n plesk-mail-pc-driver plesk-management-node plesk-roundcube
plesk-service-node-utilities plesk-web-hosting pp-sitebuilder
pp12.0.18-bootstrapper psa-drweb-configurator psa-fileserver psa-firewall
psa-health-monitor psa-horde psa-imp psa-ingo psa-kronolith psa-libxml-proxy
psa-mail-driver-common psa-mailman-configurator psa-mnemo psa-passwd
psa-php5-configurator psa-phpmyadmin psa-phppgadmin psa-pylibplesk psa-turba
psa-updates psa-vpn psa-watchdog wpb-core wpb-headers
The following NEW packages will be installed
mysql-server-core-5.6
0 to upgrade, 1 to newly install, 39 to remove and 0 not to upgrade.
Need to get 4,761 kB of archives.
After this operation, 603 MB disk space will be freed.
Do you want to continue? [Y/n] n
Abort.

Would it be safe to have all those plesk packages removed? How would they be restored if they are removed?

 

[johnrdorazio]

I was able to upgrade from mysql 5.5 to mysql 5.6 without touching any psa packages by following the steps on this page: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/index.html#repo-qg-apt-upgrading. I used wget to download the correct repo package for my server, and "dpkg -i #repo-package-here#" gave me the setup screen to choose which version of mysql I wanted the repo to install. After applying the changes, it still wasn't enough to just "apt-get update" and "apt-get upgrade", some packages were updated but update was not completed. I was receiving this message:

The following packages have been kept back:
mysql-server
0 to upgrade, 0 to newly install, 0 to remove and 1 not to upgrade.

Issuing "apt-get install mysql-server" gave me the choice to continue:

Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
mysql-client mysql-community-client mysql-community-server
The following packages will be REMOVED
mysql-client-5.5 mysql-client-core-5.5 mysql-server-5.5
mysql-server-core-5.5
The following NEW packages will be installed
mysql-client mysql-community-client mysql-community-server
The following packages will be upgraded:
mysql-server
1 to upgrade, 3 to newly install, 4 to remove and 0 not to upgrade.
Need to get 23.0 MB of archives.
After this operation, 71.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y

I hope it hasn't created any problems with plesk, because there were a few messages:

Unpacking mysql-server (5.6.26-1ubuntu14.04) over (5.5.44-0ubuntu0.14.04.1) ...
dpkg: mysql-server-5.5: dependency problems, but removing anyway as you requested:
psa-horde depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mysql-server-5.5 which provides virtual-mysql-server is to be removed.
Package mysql-server is not configured yet.
psa-fileserver depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mysql-server-5.5 which provides virtual-mysql-server is to be removed.
Package mysql-server is not configured yet.
psa-vpn depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mysql-server-5.5 which provides virtual-mysql-server is to be removed.
Package mysql-server is not configured yet.
psa-imp depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mysql-server-5.5 which provides virtual-mysql-server is to be removed.
Package mysql

At least now in phpmyadmin I see that I am running mysql server 5.6.