Skip to content

Instantly share code, notes, and snippets.

@vaibhav9392
Last active April 12, 2020 19:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vaibhav9392/046c0517a4eff84358ab to your computer and use it in GitHub Desktop.
Save vaibhav9392/046c0517a4eff84358ab to your computer and use it in GitHub Desktop.
Connecting cyfe with aws ec2 database
# By default aws does not allow remote connection to database
# So we will need to enable it to connect with cyfe
# **Step 1: Create new database user**
# For two reasons
# i. We don't want to give root access to any application
# ii. By default root has access from localhost only
# Don't define host for this user(wildcard)
# Step 2: Allow access from remote server
# Edit my.cnf located at /etc/mysql/my.cnf
# Make sure line skip-networking is commented
# Change Bind address to 0.0.0.0 (this is less secure but required here)
# Step 3: Restart mysql
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment