General ArticlesHow to Create a User with Socket Authentication in MySQL/MariaDBBy RahulJuly 2, 2024In MySQL and MariaDB, you can create users that connect to the database using socket authentication instead of traditional username…
General ArticlesHow to Install MariaDB on Ubuntu 24.04By RahulJune 27, 2024MariaDB is a popular, open-source relational database management system that is a fork of MySQL. It is widely used for…
Database Administration and SecurityChanging the Default MySQL Data Directory on CentOS & RHELBy RahulMay 21, 2023MySQL is a widely-used open-source relational database management system (RDBMS) that powers countless web applications and services. By default, MySQL…
Database OptimizationOptimizing MySQL Parameters for a 32 GB RAM SystemBy RahulMay 1, 2023Tuning MySQL settings is important for getting the best performance from your server. In this article, we will look at…
Web ServersHow to Install LAMP Stack on CentOS & RHEL 9By RahulFebruary 8, 2023LAMP is a popular open-source web development platform that stands for Linux, Apache, MySQL, and PHP. This acronym represents the…
MariaDBHow to Install MariaDB on Ubuntu 22.04By RahulMay 25, 2022MariaDB is a popular open-source relation database system developed by the original developer of the MySQL server. It is originally…
DatabasesHow To Install MariaDB on Debian 11By RahulSeptember 27, 2021MySQL is a well-liked free database management system and also a prominent component of the LAMP stack. MySQL has been…
General ArticlesHow to Allow Remote Connections to MySQLBy RahulFebruary 8, 2021MySQL is a popular open-source relational database management system that allows users to store, manage, and retrieve data. By default,…
DatabasesHow To Install phpMyAdmin on Ubuntu 20.04By RahulMay 23, 2020phpMyadmin is the best web based client for accessing MySQL servers. It is freely available to download and install on…
MariaDBHow to Install MariaDB 10.7 on Ubuntu 20.04By RahulMay 20, 2020MariaDB is an open-source relational database server. Which is made by the original developers of MySQL. MariaDB intended to maintain…