Digital Ocean

... by Bittle in Cookbook August 23, 2018


DigitalOcean provides developers cloud services that help to deploy and scale applications that run simultaneously on multiple computers.

Connecting URL

Go to namecheap and buy URL. To link to digital ocean go to "manage domains" in namecheap, then click manage to the domain you want to manage. Scroll down to nameservers, click the dropdown and select "custom DNS". Type in ",," in the 3 inputs, then click the green checkmark to save.

Creating a droplet/server

Change to the team droplets by clicking on your avatar on the top right. To create a new droplet click the green "Create" button next to avatar, and select droplets. Under "Choose an image" click "One-click apps" and select "LAMP on vv.vv". Choose size (1 GB default), and choose a datacenter (San Francisco default). Create an SSH key and add it: run the command


and don't enter a phrase when prompted, then cat the contents of the public key and paste it in the new ssh key input in digital ocean. Change the host name to something simple, and finalize by clicking long green create button.

Connecting droplet to URL

Click the 3 dots on the far right the droplet and click "add a domain". Fill in the domain and submit. When creating new record, type the "@" symbol in hostname. "Will redirect to" must be changed to the url ip, and then submit by pressing "create record". Once that's done, go to the url to verify when a blue shark thing.

Accessing the server (SSH)

Copy IP-address from droplet. Open the terminal and cd into the directory where your ssh keys are located. Type ssh -i key_name root@ip_address. Get your SQL root password run cat /root/.digitalocean_password copy it and run mysql_secure_installation which will prompt you to enter the password. After entering the password a set of prompts will appear:

  • Change the Password for root? : no
  • Remove anonymous users? : yes
  • Disallow root login remotely? : no
  • Remove test database and access to it?: yes
  • Reload privilege tables now? Yes
  • cd into /var/www/html and delete info.php (rm info.php)

FTP into server (FILEZILLA)

Install Filezilla. To connect to server you need to import the private ssh key: Open Filezilla settings, and navigate to SFTP (settings -> connection -> FTP -> SFTP). Click Add key file and import private key file, and click Ok. On Filezilla main page file in the inputs as followed:

  • Host = sftp://ip_address
  • username: root
  • Click Quickconnect
  • Trust it
  • Html directory = /var/www/html

Connecting to MySQL in the server

Install Sequel PRO. SSH into server. Open Sequel PRO and click the SSH tab, then fill in the following information:

  • MySQL Host: ip_address
  • Username: root
  • Password: get from /root/.digitalocean_password
  • SSH host: Same as MySQL Host
  • SSH User: Same as Username
  • SSH Password: Click Key icon and import private key
  • Test connection 
  • Add to favorites
  • Connect

To import SQL:

  • Click dropdown "Choose Database" on top left corner and select "Add Database" File -> import -> select SQL file

Composer usage in server

Download the latest composer.phar from (Scroll down to manual download and click latest version). Once the file is downloaded, remove the .phar extension. Make sure FileZilla is up and connected, and drag the new composer file into /usr/local/bin. Try running composer on the server, if permission denied run chmod 777 /usr/local/bin/composer.

Uploading website

Make sure to run

apt-get update
sudo apt-get install php7.0-curl
sudo apt install zip unzip php7.0-zip

in the server. Delete vendor folder. Drag and drop folder items into /var/www (html folder should be part of items you drop in). Once it's done, run composer install in the directory where composer.json is located. If you encounter an error in which Classes can't be found make sure your composer.json file has the namespace app\\ connected to "app/" (don't forget the /). If internal error 500, make sure to run

sudo tail /var/log/apache2/error.log

to view error log. If error log shows "invalid command 'RewriteEngine'" as the error run

sudo apt-get install apache2
sudo a2enmod rewrite
sudo apache2 restart


Go to and select "Apache" and "Ubuntu version", and follow along.

Common Errors

1364 Field 'display_name' doesn't have a default value (also happens with GROUP_BY)

  • Sign into MySQL: mysql -u username -p
  • Enter password
  • Type: SET GLOBAL sql_mode=''; here

Cannot insert a value for auto-increment primary key

  • Put allowPkInsert="true" in desired table
<table name="table_name" idMethod="native" phpName="TableName" allowPkInsert="true">

Comments (0)

Search Here