How to secure MySQL connections with SSL on Ubuntu

By | 2019-10-20T22:00:34+00:00 October 20th, 2019|

MySQL does not require any introduction. It is one of the most popular database management systems available right now. It is open source and many popular websites use MySQL. Do you know that Wikipedia also uses MySQL as a database management system? MySQL is popular because the functions and features it is providing to the [...]

How to set up High Availability WordPress with HyperDB

By | 2019-10-19T22:38:14+00:00 October 19th, 2019|

WordPress is the most popular content management system available in the market. From top 1 million websites in this world, more than 25% use WordPress to manage the content. It means, WordPress is a scalable content management system. When you are getting more than 100k visitors in a month, you need High availability WordPress instance. [...]

How to manage MySQL users via Command line

By | 2019-10-10T06:06:29+00:00 October 10th, 2019|

In the guide we published before, we discussed how to manage MySQL databases via command line. But managing MySQL databases is not everything in the field of MySQL Database administration. It is because databases are individual databases and you cannot manage databases without creating a MySQL user with appropriate privileges to perform actions on databases. [...]

How to manage MySQL databases with command line

By | 2019-10-08T13:25:26+00:00 October 8th, 2019|

MySQL is no doubt one of the most popular and loved Relational Database Management system in the world. Majority of the websites you have visited till now stores the data in MySQL database. And you too are here to learn how to manage databases in MySQL via command line in Ubuntu. In this guide, I [...]

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