Last Updated: 17 April 2018
By Maynard Paton


Securing MySQL On Your AWS Server


Welcome to Part 12 of Installing Sendy and Virtualmin on Amazon Web Services (AWS).

This page describes how to secure MySQL on your AWS server. MySQL is the database system used by Sendy. (Source: Tharindu Kumara)

Here are the steps to follow

1) If you have just completed Part 11, you should already have a Terminal window open and be logged in to your AWS server as root.

Otherwise, open a new Terminal window and at the command line, enter:

ssh root@12.34.56.78

...replacing 12.34.56.78 with the Elastic IP created within Part 4. Enter the server root password set in Part 3.


2) At the command line, enter:

mysql_secure_installation


3) You should be asked about Validate Password Plugin


Enter n to continue.

4) You should then be asked to set the password for root:


Enter the MySQL root password you set within the Virtualmin post-installation wizard during Part 8 (note: the cursor may not move when you type the password).

You will be asked to retype the password.

5) You should then be asked whether you wish to remove anonymous users.


Enter y to continue.

6) You should then be asked whether you wish to disallow root login remotely:


Enter y to continue.

7) You should then be asked whether you wish to remove test database and access:


Enter y to continue.

8) You should then be asked whether you wish to reload privilege tables:


Enter y to continue.

9) The All done! message should now appear:


10) All done!

Stay logged in to the Terminal window, and click here to start Part 13. Alternatively, click here to return to the Introduction.

If you have any questions or comments about this page, please let me know so I can keep this website as helpful as possible.

Happy installing!

Maynard Paton

(Want to learn more? Click here to visit the full website index.)


profile-pic

Sendy and Amazon SES are a much better option!

Compared to paying $30 a month to MailChimp, Sendy and Amazon SES are a much better option. Especially for a low volume list — and for a year for free with Amazon, too.

David Pascoe, digitaldavo.wordpress.com , Sendy customer

MailChimp 'Disruptor'. $59 One-Off Fee. Full Refund Available.