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