Grant remote access to MySQL database

remote-my-sql-ec2-etc.txt

# UPDATE AWS EC2 SECURITY GROUPS FIRST TO ALLOW MySQL CONNECTION VIA IP

---

# Edit /etc/mysql/my.cnf, and change the binding address to 0.0.0.0
bind-address = 0.0.0.0

# then restart mysql server
$ sudo /etc/init.d/mysql restart

# Create a new user for any host in MySQL
CREATE USER 'your_user'@'%' IDENTIFIED BY 'your-unique-password';

# grant privileges to table(s)
GRANT ALL PRIVILEGES ON database_name.* TO 'your_user'@'%' WITH GRANT OPTION;