Tagged: best linux cloud server hosting

April 15th, 2014 Linux Basics, Linux Hosting, mySQL No Comments »

Linux Cloud Server Hosting with ASPHostPortal.com :: How To Create a New User and Grant Permissions in MySQL

About MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial will give a short overview of a few of the many options.

How to Create a New User

However, in the cases where more restrictions may be required, there are ways to create users with custom permissions.

Let’s start by making a new user within the MySQL shell:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
 Read more »
March 5th, 2014 Linux Basics, Linux Hosting, MariaDB, Ubuntu No Comments »

Cloud Linux Server Hosting with ASPHostPortal.com :: How To Create and Manage Databases in MySQL and MariaDB on a Cloud Server

What are MySQL and MariaDB?

MySQL and MariaDB are relational database management systems. These tools can be used on your server to manage the data from many different programs. Both implement forms of the SQL querying language, and either can be used on a cloud server.

This guide will cover how to create a database using these tools. This is a fundamental skill needed to manage your data in an SQL environment. We will also cover several other aspects of database management.

For the purposes of this guide, we will be using an Ubuntu 12.04 server on a small server instance. However, everything should translate directly to other distributions.

Read more »

January 17th, 2014 Linux Basics, Linux Hosting No Comments »

Linux Cloud Server 2014 Hosting – ASPHostPortal.com :: Installing and Using the Vim Text Editor on a Cloud Server

Introduction

One of the most powerful text editors accessible from the command line is the vim editor. Built on the foundation of “vi”, an editor dating back to 1976, vim adds additional functionality and power, while maintaining the editing style of its predecessor.

Installation

Due to vim’s wide-spread use on the Linux command line, it is available in almost every distribution’s default repositories.

On Ubuntu and Debian, use apt-get to install:

sudo apt-get install vim

On Fedora and CentOS, install with yum:

Read more »

December 23rd, 2013 CentOS, mySQL, Ruby on Rails, Ubuntu No Comments »

Linux Cloud Hosting with ASPHostPortal.com :: How To Install Rails, Apache, and MySQL on Ubuntu with Passenger

Intro

Installing Ruby on Rails and MySQL on an apache virtual private server is the first step toward getting Ruby applications live and online. Three useful installers make the task of building this server easier than ever before.

Setup

This tutorial requires you to have a  server up and running. Additionally, the rails ready script needs to be performed by a user with sudo privileges. If you don’t have a user like that on your server, you can check out how to do that in steps 3 and 4 of this tutorial.

Step One—Install Rails Ready

Once you are logged in on your virtual server with your user with root privileges, type in the command to install Rails Ready:

wget --no-check-certificate https://raw.github.com/joshfng/railsready/master/railsready.sh && bash railsready.sh

Rails Ready can be installed either from the source or with RVM, the Ruby Version Manager. I would recommend using RVM—it’s an easy installation and will later let you to switch between multiple versions of Ruby if needed.

Read more »

photo linux-125_zps0bb67a6b.gif photo cloud3_zps2d4c8104.gif