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"
Server version: 5.5.46 - MySQL Community Server (GPL)
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
Uninstall your current MySQL version, and then run:
sudo yum install mysql56-server