How to update mySQL to version 5.6?

[jeremyotten]

How to update mySQL to version 5.6?

[Me.B]

You can use different repos like remi but you can get a lot of issues later in packages.

M B

[jeremyotten]

You can use different repos like remi but you can get a lot of issues later in packages.

M B

What packages do you mean? I only use it for 1 application... our Servicedesk

[Me.B]

If you use Ubuntu you get MySQL 5.5.

See here how to upgrade using remi

http://myeasywayout.blogspot.fr/2013/06/...os-64.html

You will find more if you google it.

M B

[TGates]

  According to your profile you are still using 1.0.0! You should seriously look into updating to 1.0.3! See the Announcements section for more info.

[jeremyotten]

  According to your profile you are still using 1.0.0! You should seriously look into updating to 1.0.3! See the Announcements section for more info.

i am at 1.03 but that still runs mysql 5.1.27 i need 5.6 @ least..

I think Sentory should update this ASAP..

[jeremyotten]

If you use Ubuntu you get MySQL 5.5.

See here how to upgrade using remi

http://myeasywayout.blogspot.fr/2013/06/...os-64.html

You will find more if you google it.

M B

I am on Centos 6.6

[Me.B]

It's almost the same but you must google it and test before doing it on live server.

M B

[jeremyotten]

It's almost the same but you must google it and test before doing it on live server.

M B

i am just going to do that.. will the sentory GUI still work after upgrade?
Can i create mySQL databases and stuff?

[jeremyotten]

Ok here are the steps that I used.
First you have to update from 5.1 to 5.5

//Add Remi Repo
# wget http://rpms.famillecollet.com/enterprise...ease-6.rpm
# rpm -Uvh remi-release-6*.rpm


// Update to PHP 5.6.8
# yum --enablerepo=remi-php56,remi update php\*

Update to Mysql 5.5.43
# yum --enablerepo=remi install mysql mysql-server

Works like a charm.

Then you have to use this to update 5.5 to 5.6
update naar 5.6
wget https://repo.mysql.com/mysql-community-release-el6.rpm
rpm -Uvh mysql-community-release-el6*.rpm
yum update
N
yum update mysql
Y

chkconfig --level 345 mysqld on
reboot

My servicedesk app worked.. and could be updated to latest version.
Sentora panel also worked.

And I was able to create a database through the interface.
Only thing that did not work was creating a Mysql user.

I got an Internal server error. Please assist in solving this.