{"id":7145,"date":"2017-11-28T08:42:52","date_gmt":"2017-11-28T00:42:52","guid":{"rendered":"http:\/\/rmohan.com\/?p=7145"},"modified":"2017-11-28T08:42:52","modified_gmt":"2017-11-28T00:42:52","slug":"setting-up-mysql-server-on-aws-ec2-instance","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=7145","title":{"rendered":"Setting up MySQL server on aws EC2\u00a0instance"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n

Launch an EC2 instance of type Amazon Linux AMI from your aws console.<\/p>\n

SSH into your ec2 instance
\nssh -i ec2-user@my_ec2_ip_address<\/code><\/p>\n

Update the instance
\nsudo yum update -y<\/code><\/p>\n

Install the mysqld server
\nsudo yum install -y mysql55-server<\/code><\/p>\n

start the mysqld instance
\nsudo service mysqld start<\/code><\/p>\n

the following command ensure launches mysqld on server restart
\nsudo chkconfig mysqld on<\/code><\/p>\n

run the following command to set password for root user and delete test databases.
\nsudo mysql_secure_installation<\/code><\/p>\n

make a note of the root password ????<\/p>\n

Let\u2019s try to create a user and database. This way we can control the database access levels.
\nmysql -uroot -pmy_root_password<\/code><\/p>\n

I\u2019m going to create a db_demo<\/em> with demo_user<\/em> having password demo123<\/em>.
\nCREATE DATABASE db_demo;
\nUSE db_demo;
\nCREATE USER 'demo_user'@'localhost' IDENTIFIED BY 'demo123';
\nGRANT ALL PRIVILEGES ON *.* TO 'demo_user'@'localhost' WITH GRANT OPTION;
\nCREATE USER 'demo_user'@'%' IDENTIFIED BY 'demo123';
\nGRANT ALL PRIVILEGES ON *.* TO 'demo_user'@'%' WITH GRANT OPTION;
\nFLUSH PRIVILEGES;
\n<\/code><\/p>\n

That\u2019s it. You are all set.<\/p>\n

Note: <\/strong><\/p>\n