Skip to content

Instantly share code, notes, and snippets.

@aerobless

aerobless/digital-ocean-new-lamp-site-setup.md

Last active March 4, 2017 16:28
Show Gist options
  • Save aerobless/a593eac418974b8a87b60f3c3c69bc2e to your computer and use it in GitHub Desktop.
Save aerobless/a593eac418974b8a87b60f3c3c69bc2e to your computer and use it in GitHub Desktop.
Download ZIP
Digital Ocean: Setup a new LAMP site
Raw
digital-ocean-new-lamp-site-setup.md

Setting up a new LAMP site on Digital Ocean

1. Database

1.1 Connect via SSH. Mysql root password is shown on login. Run mysql.
1.2 Create a new database with CREATE DATABASE db_name;.
1.3 Create a new user with CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'.
1.4 Grant permissions to user with GRANT ALL PRIVILEGES ON db_name.* TO 'username'@'localhost';.
1.5 When finished run FLUSH PRIVILEGES;.

2. Create apache2 site

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment