Upgrade MySQL to 5.6 on ec2

Question

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?

Thanks.

Answer 1

Uninstall your current MySQL version, and then run:

sudo yum install mysql56-server