While this was tested using a TurnKey LAMP Server build (Debian Linux), it applies to any Debian/Ubuntu server with MySQL.
Top-Level View of Tutorial
- Enable MySQL access through server’s firewall (Amazon AWS-EC2 Security Groups)
- Create non-root MySQL user with % (any) Host permissions
- Alter the bind-address in the MySQL configuration file (my.cnf) file
- Restart MySQL