How to Install Magento 1.9
If you have connected your server to ServerPilot, this tutorial will show you how to install Magento Community Edition 1.9 on your DigitalOcean server using SFTP.
Creating an App in ServerPilot
An app is a web application, such as Magento.
In ServerPilot, click Create App; this can be done immediately after connecting a server or by going to the Apps page.
Give your app a name and select the server you want this app to be on (probably the one you just set up).
You may also select the system user you want to run this app.
Click Create App to submit the form. You'll be shown some details about the app.
Creating a Database
Magento requires a MySQL database to be created before you run its installer. Let's do this now.
Open your app in ServerPilot and go to the Databases tab. Click Create Database.
Choose a database name. A database username and password will be generated for you. Write these down so you can enter them into the Magento Installer, and then submit the form in ServerPilot to create the database.
If you forget to write down the database password and need to reset it, just click on the database user in ServerPilot to see the change password form.
Installing Magento Using SFTP
After logging in or creating an account at www.magento.com, open the Release Archive tab on the Magento Community Edition page.
In the Downloader box, select magento-downloader-MOST.RECENT.VERSION.zip from the drop-down menu. Click Download.
When the download completes, decompress the ZIP file.
Now, log in to your server through Cyberduck (or your preferred SFTP client) as the system user your app belongs to. (If you followed our tutorials on uploading files and configuring Cyberduck, then your server may already be displayed under Cyberduck's History tab, and you can double-click it.)
Follow this path to your app's web root directory:
apps/APPNAME/public
In this example, we named our app "magento".
Next, find the new downloader.php file in your computer's Downloads folder and drag it into your app's web root directory in Cyberduck.
In your browser, visit YOUR.I.P.ADDRESS/downloader.php. Follow the instructions in the Magento Installer and, when asked, use the MySQL username and password you created in ServerPilot. Leave the default settings as they are for the download and installation screens.
After you complete the setup, be sure to install all critical security patches.
You can also install phpMyAdmin to manage your database.
That's It
When finished, you'll be able to log in to your brand new, blazingly fast Magento dashboard.
ServerPilot will keep your server's system packages updated with security updates. ServerPilot also configured a firewall on your server so you don't have to worry about that.
We've taken the pain out of server management so you can focus on your apps.
Happy eCommercing!