driftking9987 driftking9987 - 1 year ago 107
MySQL Question

Upgrade MySQL to 5.6 on ec2

I just started using aws. I had a database on namecheap and when I tried to migrate it on EC2
instance Amazon Linux AMI 2016.03.0 (HVM), I got an error.
On further examining the error, I noticed that, the mysql version is not correct(need to upgrade it in order to import the database).

The error which am getting :

"#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"

Now, my current mysql version is (I copied it from phpmyadmin) :
Server version: 5.5.46 - MySQL Community Server (GPL)
and I need to upgrade it to 5.6

I tried

sudo yum update mysql-server
Loaded plugins: priorities, update-motd, upgrade-helper
963 packages excluded due to repository priority protections
Package(s) mysql-server available, but not installed.
No packages marked for update

I also tried to disable the priority plugin using this, but it's still not working.

Can someone please tell me how to upgrade it?


Answer Source

Uninstall your current MySQL version, and then run:

sudo yum install mysql56-server