#Create database mysql digitalocean install
#Create database mysql digitalocean update
#Create database mysql digitalocean password

and you should be able to login using your username and password from the migration.You can buy managed database from Digital Ocean that have ready to serve database.

#Create database mysql digitalocean update

Paste in the following line – replace your domain (this will update your timeline every five minutes): */5 * * * * wget -O /dev/null We’ll use cron to configure a background task to regularly run the background actions: crontab -e Paste in the following – replace your sub-domain or domain name: Īctivate the site and reload Apache: a2ensite nf Next, we’ll create an Apache configuration file for the console website: nano /etc/apache2/sites-available/nf Yii will then go ahead and build the database for you. You’ll be prompted to create your web user login credentials you’ll use these to log in to the website – important, use admin for the username: Admin login : adminĪdmin email password : supereasy99 app/protected/yiic migrate -migrationPath=user.migrations To build the MySQL database, we’ll run Yii ActiveRecord migrations : cd /var/www/ocean Then, change the database settings for your MySQL server and add your Digital Ocean API access key: mysql_host='localhost'ĭo_access = 'your-digital-ocean-api-access-token' Copy the /app/docs/sample-config.ini to a secure directory on your server. You’ll have to provide these database settings in twitter.ini file. Grant all privileges on ocean.* TO identified by 'your-password' mysql -u root -pĬreate a database for Ocean and grant permissions: create database ocean The password for your MySQL Server is usually shown when you login to your Droplet. Set the file privileges and permissions for Ocean’s directories: chown -R www-data:www-data ocean Sign in to your Droplet via SSH as shown above. Installing the console is relatively straightforward.

#Create database mysql digitalocean install

You might also wish to install PHPMyAdmin as I’ve described in Installing and Using PHPMyAdmin for Web Development. It’s also best to run through the script for securing your MySQL server installation: mysql_secure_installation There are a few things you’ll want to do to get your droplet ready for installing the Ocean console. ssh can also use your IP address until your domain name is active: ssh your password when prompted, or use: passwd Wait until your DNS changes propagate (sometimes up to 24 hours or more – check them here), try to connect via SSH using your domain and the password provided in the Digital Ocean email. Visit your domain registrar’s DNS settings and change the A record for your to the new IP address e.g. Once you have your IP address, you can begin the process of mapping your domains and subdomains e.g. Digital Ocean will email you your IP address and root password. Under Select Image, choose Applications: LAMP on Ubuntu 14.04 LTS.Ĭreating a droplet only takes a minute. You can also select any region closest to you or your typical reader e.g. You’ll want to have a hostname (domain or sub-domain name) chosen for your readers in mind. Once you sign up, you can create your first Droplet using the selections below. Sign up at Digital Ocean now, the process is simple and only requires your email and password:ĭigital Ocean’s cloud instances are called Droplets. If you don’t have a registrar or need more information, I recommend NameCheap. You may want to have a domain name or sub-domains registered for the app, e.g.