Page 1 of 1

Configure VestaCP on Ubuntu 14.04 to use MySQL 5.6

Posted: Mon Jun 15, 2015 1:42 am
by smissingham
On this forum somewhere I found that VestaCP install script uses the default MySQL version for the OS that it is being installed on.

The OS I'm using in a VM is Ubuntu 14.04 Server, which means the default MySQL version is 5.5, however due to somebody else's configuration of one of our databases, I need it to use MySQL 5.6. I know I can manually install MySQL 5.6 without a cpanel but am unsure as to how to install it through VestaCP as I do so love this control panel.

Any help is much appreciated.

Sean

EDIT: To elaborate a little more, I suppose upgrading from 5.5 to 5.6 post-install is an option as well if that doesn't pose any problems to VestaCP's configuration.

Re: Configure VestaCP on Ubuntu 14.04 to use MySQL 5.6

Posted: Tue Jun 16, 2015 12:21 am
by smissingham
As it turns out, it was as simple as installing MySQL 5.6 manually after a fresh Ubuntu + VesaCP installation.

Installed VestaCP as normal after doing apt-get update and upgrade.

Rebooted and ran:

Code: Select all

apt-get install mysql-server-5.6 mysql-client-5.6 mysql-client-core-5.6
Rebooted again and happy days, VestaCP seems to be fine with the upgrade, user still works.

Thanksfully I don't have any schemas in the database before upgrading, but from what I've read, that would still work as well as MySQL performs the upgrade automagically.

Re: Configure VestaCP on Ubuntu 14.04 to use MySQL 5.6

Posted: Thu Jun 16, 2016 5:40 pm
by tAALz
Were you already running a website on the server?

I currently have wordpress running on it, and its in production/live website with good amount of traffic.
I don't want to risk doing something stupid. Can you guide me if everything went smooth?

Also I need to learn about the PHP version. By default with VestaCP install command I got "5.5.9-1ubuntu4.17" where as wordpress is now asking to upgrade this to ver5.6 as well.

Any help?