Tagged: Best linux hosting

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 »

Linux Cloud Hosting 2014 with ASPHostPortal.com :: How To Create, Remove, & Manage Tables in PostgreSQL on a Cloud Server

What is PostgreSQL?

PostgreSQL is a database management system that uses the SQL querying language. It is a very stable and feature-rich database system that can be used to store the data from other applications on your server.

In this article, we will discuss how to create and manage tables within the postgreSQL interface. You will learn how to properly configure tables and use them to store your information.

How to Install and Log Into PostgreSQL on Ubuntu

In this guide, we will install PostgreSQL on Ubuntu 12.04, but it should be available in most other distributions’ default repositories.

Read more »

Ubuntu 12.04 Hosting :: How To Install and Secure phpMyAdmin on Ubuntu 12.04

About phpMyAdmin

phpMyAdmin is an free web software to work with MySQL on the web—it provides a convenient visual front end to the MySQL capabilities.

Setup

The steps in this tutorial require the user to have root privileges on your virtual private server. You can see how to set that up here in steps 3 and 4.

Before working with phpMyAdmin you need to have LAMP installed on your server. If you don’t have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up here.

Once you have the user and required software, you can start installing phpMyAdmin on your server!
Read more »

Linux Cloud Server Hosting-ASPHostPortal.com:: How To Install MediaWiki on Centos 6.4

MediaWiki is a free open source wiki program that allows users to create their own personal wiki sites. Originally built for Wikpedia, it is now used by thousands of other projects due to its scalability and high customization.Install MediaWiki on your server.

At the time of writing, the latest version of MediaWiki is MediaWiki 1.21.2. To check for the latest version of the platform, visit their website and simply alter the code to match the most updated version (if desirable).
Read more »

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 »

Cloud Server Linux Hosting – ASPHostPortal.com :: How To Install and Secure phpMyAdmin on Debian 7

phpMyAdmin

phpMyAdmin is a free web software to work with MySQL on the web. It provides a convenient visual front end to the MySQL capabilities.

Setup

Before working with phpMyAdmin, you need to have LAMP installed on your server. If you don’t have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up here.
Once you have the user and required software, you can start installing phpMyAdmin on your VPS!

Read more »