MySql Server Setup On Amazon Linux

yum install mysql-server
    
chkconfig mysqld on
    
service mysqld start

Update password on your local MySQL server if you want,

    mysqladmin -u root password [your_new_pwd]
    
    mysql -uroot -p
    
    type new pwd
    
Troubleshooting

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
    
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;