Tag: MySQL

How to Install MyWebSQL on Ubuntu 16.04

  In this tutorial we will show you how to set up MyWebSQL on Ubuntu 16.04 server. MyWebSQL is a free and open source web based WYSIWYG client for managing the databases on your server. It provides a simple and intuitive interface with the look and …

How to Configure WordPress to use a Remote Database

WordPress is the most popular content management system (CMS) based on PHP and MySQL. When your WordPress CMS grows in traffic and you have outgrown your current server resources, a professional solution is to host your database on a separate database server. With this solution, you …

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 …