Knowledge base category
MySQL
69 practical guides in MySQL.
How to Configure WordPress with External Database
You can actually set up wordpress with external database. There are many benefits to it, follow this guide to set up a wordpress site with remote database.
MySQLAllow MySQL remote connections and Secure them on Ubuntu 16.04
MySQL is the second most popular DBMS in the market with awesome features. Follow this guide to allow and secure mysql remote connections with ease.
MySQLSet up Master-Slave replication in MySQL Server 5.7
MySQL is one of the most popular RDBMS in the market. Follow this step-by-step guide to set up master-slave replication in MySQL server 5.7.
MySQLNexusCore and SQL Server 2017 Installation in WHM
WHM servers are not supported .NET platform by default. However, this can be enabled using a third party plugin called NexusCore. The respected plugin
MySQLUpgrade MariaDB from 10.0 to 10.3 on Ubuntu 16.4
Here are the steps to upgrade MariaDB from 10.0 to 10.3 Upgrading repo on Ubuntu 16.04You will need to add required repository source to /etc/apt/source
MySQLReset MySQL Installation in cPanel
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
MySQLHow to Optimize MySQL Database Using phpMyAdmin in Plesk?
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
MySQLUpgrade MariaDB or MySQL Version in Linux
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
MySQLHow to Increase the Upload Size of MySQL Database in PhpMyAdmin on a cPanel Server?
How to Increase the Upload Size of MySQL Database in PhpMyAdmin on a cPanel Server? The cPanel server imposes a limit for the database which can be uploaded
MySQLHow to Optimize MySQL Database Using phpMyAdmin in cPanel?
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
MySQLHow to Replace MySQL With MariaDB on a cPanel Server?
How to Replace MySQL With MariaDB on a cPanel Server? MariaDB is one of the globally accepted database servers in the world. It is made by the MySQL
MySQLHow to Fix the Common MySQL Errors?
In this tutorial, we can discuss the most common MySQL errors that can be happened on your server and the possible fixes.