How to create Master-Slave replication in MySQL Server 5.7

By | 2019-05-21T20:19:02+00:00 May 20th, 2019|

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. MySQL is a really powerful database management system that supports almost all the websites based on WordPress. By default, WordPress uses MySQL RDBMS to manage and operate [...]

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

How to Change MySQL Server Time Zone

By | 2018-08-07T12:11:52+00:00 February 1st, 2017|

In this article, we can discuss about how to change the MySQL server time zone. To change the time zone of your MySQL server, please follow the below steps.   1) Login to your server via SSH as root user. 2) You can find current MySQL server time zone via executing the following command. $ [...]

Easy steps to setup and install Moodle

By | 2017-02-01T17:38:30+00:00 February 1st, 2017|

Moodle (Modular Object-Oriented Dynamic Learning Environment) is a free and open source software written in PHP for learning management system. Moodle is used to create private websites with online courses for educators and trainers. Moodle is the leading virtual learning environment and it can be used in many environments such as education, training and development. [...]

Load More Posts