mysql-simple-config

mysql-simple-config.sh

#install
yum install mysql-server

#auto start on rebooting
chkconfig mysqld on

#start
service mysqld start
(service mysqld stop)
(service mysqld restart)

#set users;create database;
mysqladmin -u root password ${your password}
mysqladmin -u root -p create ${database name}

#enter database;
mysql -u root -p

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON mydb.* TO 'awsuser'@'<your public EC2 DNS address>' IDENTIFIED BY 'mypassword';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON mydb.* TO 'awsuser'@'%' IDENTIFIED BY 'mypassword';

FLUSH PRIVILEGES;