The Ultimate guide on mysqldump – A Database backup program

By | 2019-09-07T12:38:43+00:00 September 7th, 2019|

Every application needs a database to store information. It does not matter if it is a web application or a mobile application. And the information a database holds is very important for an individual or a company that owns the database. For example, if you are a blogger, you don't want to lose the content [...]

Setup Master-Master replication in MySQL on Ubuntu

By | 2019-09-06T11:00:35+00:00 September 6th, 2019|

MySQL is no doubt one of the most used database management system in this world. The first rank goes to Oracle, but unlike Oracle, MySQL is open source. It means that individual developers can help build and maintain MySQL so that everyone can simply use it for free. One of the best features of MySQL [...]

Import and Export Databases in MySQL using Command Line

By | 2019-08-26T12:33:22+00:00 August 1st, 2019|

MySQL is open-source relational database management system. It is one of the most popular RDBMS that ranks #2 on the list of most popular databases in the world. It has a very rich set of features that allows you to start from the small databases easily. And you can scale your database according to your [...]

Set up DirectAdmin to Use a Remote MySQL Server

By | 2019-08-26T05:59:20+00:00 July 29th, 2019|

We can set up MySQL to be run on an external server when we have a large database that would require management and monitoring of its own. The best way to do so is to host MySQL on a different server. Then we can connect our application to our Remote MySQL database which is pretty [...]

How to Reset MySQL root password in Ubuntu

By | 2019-08-26T14:12:27+00:00 July 25th, 2019|

While installing the MySQL for the first time on your server, you have to set the password for the root user. The user root is kind of a superuser in MySQL. The root user can perform all the tasks and has all the privileges. It can create new users and grant them privileges on a specific [...]

Setup Nginx, MySQL, PHP (LEMP stack) on Ubuntu 16.04

By | 2019-08-24T12:39:31+00:00 July 11th, 2019|

The first step to configure any Virtual Private Server or Virtual Machine is to configure a stack your application can run on. And there are some common stacks in the market, Like LAMP stack, LEMP stack, MEAN stack and many more. In this guide, I will demonstrate how you can set up a LEMP stack [...]

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

Load More Posts