Text Mining, Analytics & More: Mysql

Nov 13, 2013

How to install MySQL on an Amazon EC2 Server Instance?

Being a newbie to server administration especially with Linux, I found myself looking all over the internet on how to install a mysql server instance! Here is what worked for me on the Amazon EC2 instance:

To install a MySQL Server

First step is to of course ssh into the EC2 instance
Then, at a command prompt, use the following command to install MySQL Server:
```
sudo yum install mysql-server
```
When you are prompted, type 'y'.

To start the installed MySQL Server

Start mysql, and configure it to start up automatically on reboot.
```
sudo chkconfig mysqld on
sudo service mysqld start
```
You would see a response like the following.
```
Starting mysqld
```

Configuring newly installed MySQL Server

To update the password of root user do the following:

mysqladmin -u root password [your_new_pwd]

To create a database do the following:
```
mysqladmin -u root -p create [your_new_db]
```
When you are prompted for a password, type [your_new_pwd]. Well that's it. There rest of the MySQL functionality is as usual. For more details on other functionalities please use the MySQL website.

Using MySQL Externally

If you need to access MySQL from another server, then you need to execute these following additional steps.

First off, create a MySQL user who can connect from any type of host using the following SQL:

GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'localhost' 
GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'localhost' 
CREATE USER 'theuser'@'%' IDENTIFIED BY '[your_pwd]' 
GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'%' WITH GRANT OPTION

Next, from the AWS Management Console find the Security Group that you assigned to your instance during set-up and add 'MySQL' to the group. You can also manually add port 3306. Save and whoala ready to go!