Last Updated: 17 April 2018
By Maynard Paton
Welcome to Part 13 of Installing Sendy and Virtualmin on Amazon Web Services (AWS).
This page describes how to configure MySQL to ensure Sendy runs correctly on your AWS server. (Source: Sendy)
Here are the steps to follow
1) If you have just completed Part 12, 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:
2) At the command line, enter:
3) You should now be able to edit the file, although the file may seem empty:
4) Use the downward arrow key to scroll through the file until you reach the end:
(Note: the text in your file may differ to that shown in the screenshot above. Simply scroll through the file until you reach the end.)
5) Paste in the following code at the end of the file:
sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Your file may now look like this:
If need be, use the left arrow key to scroll to see the full pasted line:
6) Press CTRL + O
File Name to Write: should appear. Press Enter.
7) Press CTRL + X and you should return to the command line:
8) At the command line, enter:
service mysql restart
The command line should re-appear:
9) At the command line, enter:
The connection to your AWS server should now close:
Now close the Terminal window.
10) All done!
If you have any questions or comments about this page, please let me know so I can keep this website as helpful as possible.
(Want to learn more? Click here to visit the full website index.)
We usually send about 10,000 emails a month for our clients, so our costs are about $1. That is not a typo — that’s a single digit for sending email via Sendy and Amazon SES!
MailChimp 'Disruptor'. $59 One-Off Fee. Full Refund Available.