Skip to content

Instantly share code, notes, and snippets.

@freitzzz
Created June 16, 2018 19:07
Show Gist options
  • Save freitzzz/31e0c90bcdbcccadd4c54d75b9db8528 to your computer and use it in GitHub Desktop.
Save freitzzz/31e0c90bcdbcccadd4c54d75b9db8528 to your computer and use it in GitHub Desktop.
Setup Simple MySQL Server
Links used:
- https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql
- https://stackoverflow.com/a/34040197
- First setup server (see digital ocean tutorial)
- Secondly allow any trafic incoming to port 3306 (port 3306 is by default where MySQL is being listened on)
- Thirdly create a super user granting all permissing from a certain host (see StackOverflow post for more info), or from any host (@'%')
- Finally try to connect to the MySQL server using the super user
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment