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 …
How to create MySQL admin user (superuser) account
How do I create an admin user in MySQL? How can I set up and create a superuser account in a MySQL server running on Linux or Unix-like systems? Can …
How to Fix “MySQL ERROR 1819 (HY000):” in Linux
When creating a MySQL user with a relatively weak password, you might encounter the error ‘MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements’. Technically, this …