SQL Database

[Ladsrack]

Hello

I am running plesk 12.5.30 - when creating sql databases its creating them in version 5.5.44

I need to be running a higher version to run Magento 2.0

Not sure how to amend or change version - can anyone help? I cannot see anything in Plesk

 

[abdi]

Hello Lad,

Isn't that the MySQL version you are running on your server?

 

[Ladsrack]

Yes but unable to upgrade to the latest version of SQL

 

[abdi]

Which version of MySQL do you need to upgrade to?

 

[Ladsrack]

Need 5.6 or higher

 

[UFHH01]

Hi Ladsrack,

it would help, if you provide informations about your current operating system and as well, WHICH MySQL - version you would like to upgrade to.

For a start, please note that these MySQL - versions are supported with Plesk 12.5:

MySQL 5.0.x-5.6

... and please have a closer look at the official MySQL documentation, as for example:

http://dev.mysql.com/doc/refman/5.6/en/upgrading.html​

 

[Ladsrack]

I'm running Centos 7.1 with plesk 12.5.30 current sql version is 5.5.44 - as per new installation from Plesk
I need to upgrade to 5.6 but all upgrades links dont work or there is a conflict from the origianl installation from Odin

 

[UFHH01]

Hi Ladsrack,

but all upgrades links dont work or there is a conflict from the origianl installation from Odin

Could you please answer in detail, WHAT you did and what the output on the command line was, which lead to errors/failures/issues? There are various reasons / causes and we really can't guess them all.

 

[abdi]

Need 5.6 or higher

http://www.hipstersaurus.com/2014/03/how-to-upgrade-plesk-mysql-to-percona.html

 

[Ladsrack]

Installed from wget -O - https://autoinstall.plesk.com/one-click-installer | sh
As instructed from https://docs.plesk.com/en-US/12.5/d...ion/installation-from-the-command-line.65780/

tried
mysql Ver 15.1 Distrib 5.5.44-MariaDB, for Linux (x86_64) using readline 5.1

# yum update mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.clouvider.net
* extras: centos.hyve.com
* updates: centos.serverspace.co.uk
No Match for argument: mysql-server
No package mysql-server available.
No packages marked for update


tried following
http://sharadchhetri.com/2014/07/31/how-to-install-mysql-server-5-6-on-centos-7-rhel-7/
which gives me


Requires: mariadb-server >= 5.0.60
Removing: 1:mariadb-server-5.5.44-1.el7_1.x86_64 (@updates)
mariadb-server = 1:5.5.44-1.el7_1
Obsoleted By: mysql-community-server-5.6.27-2.el7.x86_64 (mysql56-community)
Not found
Available: 1:mariadb-server-5.5.40-2.el7.art.x86_64 (atomic)
mariadb-server = 1:5.5.40-2.el7.art
Available: 1:mariadb-server-5.5.41-2.el7_0.x86_64 (base)
mariadb-server = 1:5.5.41-2.el7_0
Available: 1:mariadb-server-5.5.41-3.el7.art.x86_64 (atomic)
mariadb-server = 1:5.5.41-3.el7.art
Available: 1:mariadb-server-5.5.42-4.el7.art.x86_64 (atomic)
mariadb-server = 1:5.5.42-4.el7.art
Available: 1:mariadb-server-5.5.43-5.el7.art.x86_64 (atomic)
mariadb-server = 1:5.5.43-5.el7.art
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

 

[bulent]

Hello,
if you have clean install, try first ot install mysql 5.6 repo.
After that start installing Plesk. It will automatically download and install mysql 5.6.
It's not easy to upgrade mysql on top of plesk.
I did it with MariaDB 10.0 and it workes perfectly for me.

Check my post here:
https://talk.plesk.com/threads/ppp-...sy-way-to-replace-mariadb-5-5-with-10.334758/

 

[Ladsrack]

tried installing 5.6 first then plesk doesnt seem to like it got errors stating there was a clash

 

[bulent]

tried installing 5.6 first then plesk doesnt seem to like it got errors stating there was a clash

Install only the Repo for 5.6, not the mysql server.
The server shoud be installed by Plesk itself.