How to Configure WordPress with External Database

By | 2019-06-24T16:31:12+00:00 June 18th, 2019|

WordPress, the content management system that does not require any introduction. But here is the fact, There are 313,050 million sites built on WordPress. And it has a 59.7% of market share in content management. With WordPress, you can host files and database on different servers/machines very quickly as it uses MySQL as a database [...]

Allow MySQL remote connections and Secure them on Ubuntu 16.04

By | 2019-06-07T15:36:17+00:00 June 7th, 2019|

MySQL is the second most popular database management system in the world! The reason why it is so popular is, It allows us to scale our databases very easily and effectively. More than that, It's open source (With name "MariaDB"). In this tutorial, I will show you how you can allow and secure MySQL remote [...]

Set up Master-Slave replication in MySQL Server 5.7

By | 2019-08-26T05:16:34+00:00 May 20th, 2019|

In this guide, I will show you how you can set up master-slave replication in MySQL. However, Let's first understand what exactly is MySQL and it's capabilities. MySQL is one of the most popular relational database management system. It is used on small applications like a personal time tracker to gigantic web applications like Wikipedia. [...]

NexusCore and SQL Server 2017 Installation in WHM

By | 2019-08-26T07:17:14+00:00 March 8th, 2019|

  WHM servers are not supported .NET platform by default. However, this can be enabled using a third party plugin called NexusCore. The respected plugin is compatible with Apache as well as Litespeed. Here, we can discuss about the installation and configuration tips regarding the plugin on WHM servers.   Installation 1) ssh to your [...]

Upgrade MariaDB from 10.0 to 10.3 on Ubuntu 16.4

By | 2019-08-24T11:31:20+00:00 February 25th, 2019|

  MariaDB Server is one of the most popular database servers in the World and it's made by the original developers of MySQL and guaranteed to stay open source. In this tutorial, we will show how to upgrade MariaDB from 10.0 to 10.3 on Ubuntu 16.4. The first part is you have to verify that [...]

Reset MySQL Installation in cPanel

By | 2019-08-26T05:39:37+00:00 February 19th, 2019|

  There is a way to reset MySQL installation on a cPanel server without reinstalling, but it is not recommended, because doing this will make all databases inaccessible. However, we can do this in a critical situation such as catastrophic InnoDB corruption.  In such situations, the stated goal is to reset mysql and restore from [...]

How to Optimize MySQL Database Using phpMyAdmin in Plesk?

By | 2019-08-26T14:15:44+00:00 November 8th, 2018|

How to Optimize MySQL Database Using phpMyAdmin in Plesk? In this tutorial, we are going to discuss about how to optimize a database table from phpMyAdmin in Plesk. Table optimization can be used if you have deleted a part of the table, or you have made many changes to the rows or columns of the [...]

Upgrade MariaDB or MySQL Version in Linux

By | 2019-08-24T11:32:36+00:00 November 5th, 2018|

Upgrade MariaDB or MySQL Version in Linux In this tutorial, you are going to upgrade your MariaDB version from 5.5 to 10.0/10.1/10.2 or MySQL from 5.5 to 5.6/5.7 on Linux and Plesk control panel.   For Ubuntu 12.04 and 14.04, Debian 7: Ubuntu 14.04 it is already equipped with MySQL 5.5 by default. 1) Create [...]

How to Optimize MySQL Database Using phpMyAdmin in cPanel?

By | 2019-08-26T14:15:32+00:00 September 4th, 2018|

In this tutorial, we are going to discuss about how to optimize a MySQL database table from phpMyAdmin in cPanel. Table optimization can be used if you have deleted a part of the table, or you have made many changes to the rows or columns of the table with variable length rows etc... The deleted [...]