How to Install MySQL 8.0 on Rocky Linux 8
Written in C, MySQL is an open-source, cross-platform, and one of the most widely used Relational Database Management Systems (RDMS). It’s an integral part of the LAMP stack and is …
Setup Local WordPress Development Environment In Linux
This detailed tutorial explains what is LocalWP, benefits of using LocalWP, how to install LocalWP to deploy and setup local WordPress development environment in Linux and Unix-like operating systems. 1. …
How To Reset Root Password In MySQL 8 On Ubuntu Linux
Did you forget your MySQL database root user password? No worries! This step by step guide explains how to reset root password in MySQL 8 on Ubuntu 20.04 operating system. …
Change Authentication Method For MySQL Root User In Ubuntu
This guide explains why and how to change authentication method for MySQL root user to Caching SHA-2 Pluggable Authentication or Native Pluggable Authentication method in Ubuntu. Even if you have …
How To Install MySQL In Ubuntu Linux
In this guide, you will learn how to install MySQL in Ubuntu Linux, and then how to set MySQL root user password, and finally how to access MySQL server as …
Configure Database Connection Using Environment Variable In Rails
This guide explains why you need to use an environment variable to connect to a database and how to configure database connection using environment variable in Rails application in Linux. …
How To Use MySQL With Ruby On Rails Application
Ruby on Rails uses SQLite3 as its default database. While Sqlite works great with Rails, some times it may not be sufficient for your Rails application. If you want scalability, …
How to Setup MySQL Master-Slave Replication on RHEL 8
MySQL Replication is a process where data from one server is automatically copied or replicated onto another backup server in real-time. Replication provides redundancy and fault tolerance and gives the …
How to reset WordPress password using MySQL CLI
Author: Vivek Gite Last updated: February 13, 2021 So bizarrely, I forgot my WordPress admin password, including my login name. I did not add my login details to my password …
How To Create a New User and Grant Permissions in MySQL
MySQL is a popular and widely used database management system that stores and organizes data and allows users to retrieve it. It comes with a vast array of options that …