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

OwnCloud: The Private Cloud-Installation Guide

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

OwnCloud is a file sharing server like drop box. You can store our documents, private contents like pictures, videos safely in our own server and can share it with our friends, colleagues etc. OwnCloud is free and open source, allowing anyone to install and operate without any cost. OwnCloud is a client server software for [...]

MySQL Error – The Server Quit Without Updating PID File

By | 2017-01-28T11:34:38+00:00 January 28th, 2017|

The MySQL error "Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/yourservername.pid)” is thrown when MySQL fails to start. This occurs when MySQL is upgraded to a later version or due to insufficient permission and ownership issue in MySQL data directory. The PID file in the MySQL data directory is gone and MySQL [...]

Load More Posts