Control Web Panel

WebPanel => MySQL => Topic started by: Nagataka on December 01, 2015, 06:17:45 PM

Title: MySQL 5.6
Post by: Nagataka on December 01, 2015, 06:17:45 PM

Hi all,

Currently running: CWP version: 0.9.8.10
Want to mess around with magento 2.0.
This requires MySQL 5.6.
Currently i am running: MySQL version: 5.1.73

Is there a safe way to upgrade to MySQL 5.6?

[edit]
Found some other questions about this on here.
Seems with centos 6 it doesn't go any further as MySQL 5.5?
The other option is to update MariaDB till version 10?

Title: Re: MySQL 5.6
Post by: Nagataka on December 01, 2015, 08:14:29 PM

Alright.. do not use this:
http://mysqlserverteam.com/mysql-yum-repositories/

Or CWP will be full with errors like:

Code: [Select]

Warning: mysql_connect(): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php(1) : eval()'d code(1) : eval()'d code on line 2
mysqld is stopped

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory

:D

Title: Re: MySQL 5.6
Post by: Nagataka on December 02, 2015, 08:36:36 PM

No clue how, but managed to upgrade mysql 5.1 till 5.7 as i said before (was 5.7, i went a bit to high)..
This update totally failed.
Took a bit of time, but got mysql 5.5 running now.
Only 1 database totally got corrupted.
Will try to upgrade to 5.6/5.7 later on =]

Title: Re: MySQL 5.6
Post by: ehstbr on December 05, 2015, 09:23:10 PM

I have the same problem... =(

I need a solution to update MySQL to 5.6... or 5.7.

Title: Re: MySQL 5.6
Post by: Nagataka on December 21, 2015, 08:15:04 AM

What problem you are facing now?
I managed to upgrade to 5.6 without any major problems (except pure-ftpd is not working anymore)

Title: Re: MySQL 5.6
Post by: vdshub on December 22, 2015, 01:06:06 AM

same problem
How made correct update?

Title: Re: MySQL 5.6
Post by: Igor S. on January 07, 2016, 06:39:10 AM

Hi all.

Could somebody provide us what exactly problem do you have? The CWP does not have officially support MySQL higher 5.5.x .

Title: Re: MySQL 5.6
Post by: Administrator on January 15, 2016, 06:28:36 AM

also don't forget to upgrade phpmyadmin to appropriate version to work with mysql you have installed.

Title: Re: MySQL 5.6
Post by: WebDux on January 16, 2016, 02:11:30 AM

Please support MySQL5.6 because we are using Magento 2 also

Title: Re: MySQL 5.6
Post by: Igor S. on January 22, 2016, 08:41:56 AM

Hello.

Try to use MariaDB 10.1 .