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-06-03T08:48:53+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. [...]

Upgrade MariaDB from 10.0 to 10.3 on Ubuntu 16.4

By | 2019-02-25T19:33:36+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 [...]

How to Optimize MySQL Database Using phpMyAdmin in Plesk?

By | 2018-11-08T00:13:36+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 | 2018-11-05T20:32:00+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 Enable Remote MySQL Connection in WHM?

By | 2017-04-16T21:46:21+00:00 April 16th, 2017|

By default, remote MySQL connections are disabled for all cPanel servers. The server hosted with large websites faces a big issue that because MySQL consumes large amount of resources. This will lead to high server load and always slow down the server. So, the best option is to setup a remote MySQL connection. It will [...]

Size of MySQL Databases Shown as 0MB in cPanel

By | 2017-04-16T21:41:25+00:00 April 16th, 2017|

Sometimes, when you log into cPanel, you’ll see non-empty MySQL databases showing 0MB as its size. Those databases actually contain tables and details, but the size is always shown as 0MB.     Steps to fix this issue from command line 1) Logon to server using SSH. 2) Reset the value of disk_usage_include_sqldbs from 0 [...]

MediaWiki Installation on cPanel Server

By | 2018-08-10T12:07:34+00:00 February 27th, 2017|

This documentation is about the MediaWiki installation on a cPanel Server. We all have used Wikipedia website in order to search for information. MediaWiki is the webserver software behind Wikipedia, Wiktionary and Wikimedia. MediaWiki is open source wiki software licensed under the GNU General Public License (GPL). It is completely written in Hypertext pre-processor language [...]

Load More Posts