We’ll show you, how to create a MySQL Database and User in cPanel. There are different ways to create a MySQL database and user. In one of our previous blog articles about MySQL database administration, we described how to create a new MySQL database and user through the command line which is pretty easy. If you have a Linux VPS with cPanel you can create a new MySQL database through the control panel with just few clicks of your mouse.cPanel is one of the most popular and widely used control panels. In this tutorial we will guide you through the […]

In this tutorial we are going to show you how to install Prosper202. Made by Tracking202, Prosper202 is a self-hosted application that lets you track and optimize all your marketing campaigns. It’s open source and easy to install on a Linux VPS. Follow the steps below to install Prosper202 on Ubuntu 14.04. The following are the minimum system requirements for Prosper202: – PHP version 5.4 or greater. – MySQL version 5.6 or greater. – MySQLi extension enabled in PHP Go ahead and connect to your server via SSH. The first thing you need to do is to upgrade all your […]

In today’s simple article we will cover the steps needed for installing and configuring a basic LEMP stack on a openSUSE VPS. A LEMP stack is a synonym of LEMP server or LEMP web server. It refers to a set-up which includes Linux, Nginx, MySQL (MariaDB) and PHP. REQUIREMENTS We will be using our SSD 1 Linux VPS hosting plan for this tutorial. Log in to your server via SSH: # ssh root@server_ip Before starting, enter the command below to check whether you have the proper OS version installed on your machine: # cat /etc/issue which should give you the […]

In this tutorial we will explain how to install LiteCart on an Ubuntu 14.04 VPS with Nginx, PHP-FPM and MySQL. LiteCart is a free e-commerce, feature rich e-commerce solution. The framework is constructed to be lightweight and easy for developers to modify and build upon. LiteCart relies on the latest HyperText standard HTML 5, the latest CSS 3 for styling, the jQuery framework for client-side dynamics, and the popular web scripting language PHP for server-side dynamics. REQUIREMENTS We will be using our SSD 1 Linux VPS Hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully […]

In this article we will show you how to install GLPI with Apache, PHP and MySQL on a Debian 7 VPS. GLPI is an IT software management package developed in PHP. It offers many functionalities one of which is to build up a database with an inventory for your company (computer, monitors, software, printers…). GLPI has enhanced functions to make the daily life for the administrators easier, like a job-tracking-system with mail-notification and methods to build a database with basic information about your network-topology. Below are the functions of this application: Inventory of computers, peripherals, network printers and associated components […]

In this blog article we will show you how to install AutoMySQLBackup on a Linux VPS. AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or more MySQL databases from one of more MySQL servers. It dumps the databases and compress them in to archives.it comes with many features such as:   Email notification of backups   Backup Compression and Encryption   Configurable backup rotation   Incremental database backups As usual, log in to your server as user root ssh root@IP and execute the following command to make sure that all services ar up to […]

In this article we will walk you through the steps on how to install LAMP (Linux, Apache, MySQL and PHP-FPM) on a Debian 8 VPS. A LAMP stack is a synonym of LAMP server or LAMP web server. It refers to a set-up which includes Linux, Apache, MySQL (MariaDB) and PHP. REQUIREMENTS We will be using our SSD 1 Linux VPS hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully up to date using: # apt-get update && apt-get upgrade INSTALL APACHE To install Apache on your Debian 8 server, you need to execute the […]

You can find a ‘Quick Usage Tour’ in our documentation. In this post, I’m going to walk you through that tour and elaborate on a few things. Enjoy! Things to consider I’m assuming you’ve already installed MySQL. Sphinx does not require that you use MySQL, but the following examples do. I’m installing Sphinx on Ubuntu [...]

A Wolf, a Dolphin and a Sphinx walk into a bar… nevermind. We’ll skip the jokes. This post is about using SSL to set up a secure connection between MySQL and Sphinx. Serious stuff! The Idea It simple. We’re going to use Sphinx to index some data from MySQL across a secure connection. So, we’ll [...]

This post walks through some examples of using the geospatial functions provided by MySQL and Sphinx. Enjoy! Getting Started First of all, here are some helpful resources: We wrote about geospatial search with Sphinx in this blog post. It has a more Sphinx-specific focus than this post. Alexander Rubin wrote these helpful articles: “Creating Geo [...]