Showing entries 1 to 10 of 32
10 Older Entries »
Displaying posts with tag: Tutorials (reset)
How to set up MySQL Cluster on Ubuntu

The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). In this tutorial, we will show you how to set up MySQL Cluster on an Ubuntu 16.04 VPS. We will use a total of 4 virtual servers, one for the management, one SQL node and two data nodes: 172.16.1.1 – management VPS 172.16.1.2 – SQL VPS 172.16.1.3 – data1 VPS 172.16.1.4 – data2 VPS Install and Configure MySQL Cluster on the Management VPS Download the latest version of MySQL Cluster available at http://dev.mysql.com/downloads/cluster/ to a directory of your virtual server and […]

Optimizing and repairing MySQL databases with mysqlcheck

In this post, we will talk about mysqlcheck which is a maintenance command line tool that allows you to check, analyze, repair, and optimize MySQL/MariaDB tables and databases. Check one table in the database The following command will check the table posts in the database blog: $ mysqlcheck -c blog posts blog.posts OK If your database is protected by a password add -u root -p at the end of the command: $ mysqlcheck -c blog posts -u root -p Enter password: blog.posts OK Analyze all tables in a database The following command will check the table posts in the database […]

How to install MySQL on Ubuntu 16.04

MySQL is the world’s most popular open-source relational database management system (RDBMS). It is widely used for building web applications and is an important part of the LAMP open-source web application software stack. In this tutorial we are going to show you how to install MySQL on a Linux VPS running Ubuntu 16.04 as an operating system. The first thing you need to do is to connect to your server via SSH and update all your system software to the latest version available. Go ahead and run the following command: sudo apt-get update && sudo apt-get -y upgrade Once your […]

Create a MySQL Database and User through 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 process of creating a MySQL database and user, and assigning the user to […]

How to Show All Users in MySQL

This is a common question most beginner MySQL users ask. We notice it all over the internet and on our blog too. It’s frequently asked because there are other MySQL commands for displaying information about the database, for example: SHOW DATABASES will list out all the databases, SHOW TABLES will display all the tables in your MySQL database etc. It’s not unusual for people to assume that there should be a “SHOW USERS” command in MySQL. Well, there isn’t one. Luckily there’s a way to list MySQL users and in this tutorial we’ll explain how do that. We’ll assume that […]

Install Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu

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 […]

How to install LEMP (Linux, nginx, MySQL, PHP) stack on openSUSE

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 […]

Install LiteCart on Ubuntu 14.04 with Nginx, PHP-FPM and MySQL

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 […]

Install GLPI on Debian 7

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 […]

How to install and configure AutoMySQLBackup

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 […]

Showing entries 1 to 10 of 32
10 Older Entries »