Last Updated: 17 April 2018
By Maynard Paton


Configuring MySQL For Sendy


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:

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:

nano /etc/mysql/mysql.conf.d/mysqld.cnf


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:

exit


The connection to your AWS server should now close:


Now close the Terminal window.

10) All done!

Click here to start Part 14. 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

Our Costs Are About $1!

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!

Kevin Muldoon, kevinmuldoon.com , Sendy customer

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