Tag: MySQL

How to List All Databases in MySQL

  We will show you how to list all databases in MySQL. MySQL is an open-source relational database management system commonly used with web based applications like WordPress, Magento etc. In this tutorial we will show you how to list all databases in MySQL on a …

Install phpMyAdmin on Ubuntu 16.04

  phpMyAdmin is one of the most popular and widely used web-based database management tools. It a free and open source PHP application that allows the users to manage single or multiple SQL database servers locally or on a remote server using a web browser (GUI). …

How to reset your WordPress admin password

  WordPress is a free and open-source content management system (CMS) based on PHP and MySQL which you can use to create a beautiful website. As of April 2016, WordPress is used by more than 26.4% of the top 10 million websites worldwide. Sometimes WordPress webmasters …

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, …

Install XWiki on an Ubuntu 16.04 VPS

XWiki is a free and open source advanced wiki software platform written in Java. It runs on servlet containers like JBoss, Tomcat etc. which uses a database such as MySQL or PostgreSQL to store its information. There are several methods of installing XWiki. In this tutorial, …

How to Install and Configure MongoDB on Ubuntu 16.04

How to Install and Configure MongoDB on Ubuntu 16.04 MongoDB is a NoSQL database that offers a high performance, high availability, and automatic scaling enterprise database. MongoDB is a NoSQL database, so you can’t use SQL (Structured Query Language) to insert and retrieve data, and it …

Install Cockpit CMS on Ubuntu 16.04

  In this article, we will show you how to install Cockpit CMS on an Ubuntu 16.04 VPS with PHP-FPM 7.0 and Nginx. Cockpit is open source self-hosted API-driven content management system (CMS) application written in PHP. Cockpit stores the data in an SQLite database so …

How to setup MySQL replication on CentOS

In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servers, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses: …

How to Setup MySQL Master-Master Replication

How to Setup MySQL Master-Master Replication This article consolidates information from several sources into the format I use to setup MySQL Master/Master Replication. The beauty of Linux and open source is that there are many different ways to do this. Please take a look at my …

Install WordPress with Nginx on openSUSE

As you already know WordPress is a free and open-source content management system (CMS) based on PHP and MySQL which you can use to create a beautiful website, blog, or app. In this article we will install WordPress with Nginx on a openSUSE VPS. So follow …

How to install WikkaWiki on an Ubuntu VPS

In this tutorial we will show you how to install WikkaWiki on an Ubuntu 14.04 VPS. WikkaWiki is a flexible, standards-compliant and lightweight wiki engine software written in PHP, which uses a MySQL database to store pages. It is easy to set up and easy 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 …

Install Habari with Nginx on Debian 8

In this tutorial we will cover the steps needed for installing Habari with Nginx on a Debian 8 VPS. Habari is a free and open source blog engine written in PHP that currently supports MySQL, SQLite and PostgreSQL for the database backend. It is a publishing …