linux howto's for Server System Administrations

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. …

auth_socket / caching_sha2_password / Database / LAMP Stack / Linux / MySQL / MySQL authentication method / MySQL authentication plugin / MySQL root user / mysql_native_password / Ubuntu

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 …

Database / Install MySQL / LAMP Stack / Linux / MySQL / Oracle / Ubuntu

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 …

Database / Environment Variable / Linux / MySQL / PostgreSQL / PROGRAMMING / Ruby on Rails / Tips and Tricks

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. …

Database / Linux / PostgreSQL / PROGRAMMING / Ruby on Rails / use postgresql with rails

How To Use PostgreSQL With Ruby On Rails Application

Even though the default database SQLite3 works great with Ruby on Rails, we shouldn’t be using it in some cases. For instance, if your Rails application is being concurrently accessed …

Database / Linux / MySQL / PROGRAMMING / Ruby on Rails / SQLite / Unix/Linux Beginners

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, …

Database / FAQ / Linux / Linux Admnistration / MariaDB / MySQL / Reset mysql root password / Tips and Tricks / Trouble shooting / troubleshooting

How To Reset MySQL Root User Password In Linux

Let’s imagine this. You setup a LAMP or LEMP stack with MySQL 8. After a few days, you forgot the MySQL root user password. You vaguely remember the password and …

Database / Database management tools / Focal Fossa / LEMP Stack / Linux / MySQL / Nginx / PHP / Phpmyadmin / PROGRAMMING / Ubuntu / Ubuntu 20.04 / Webserver

Install phpMyAdmin With LEMP Stack On Ubuntu 20.04 LTS

We already know how to install phpMyAdmin with LAMP stack on Ubuntu 20.04. Today, let us see how to install phpMyAdmin with LEMP stack on Ubuntu 20.04 LTS edition. And …

Database / FAQ / Linux / MySQL / Mysql password policy / security / Trouble shooting / Validate password component

Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

As you might have noticed, you will be prompted to enable “VALIDATE PASSWORD” component while setting up password for MySQL root user. If enabled, the Validate Password component will automatically …

Apache / Database / Database management tools / Focal Fossa / LAMP Stack / Linux / Linux Admnistration / MySQL / Opensource / PHP / Phpmyadmin / Ubuntu / Ubuntu 20.04 / Webserver

Install phpMyAdmin With LAMP Stack On Ubuntu 20.04 LTS

PhpMyAdmin is a free and open source web-based database management tool written in PHP programming language. Using phpMyAdmin, the database administrators can easily manage single and/or multiple database servers either …

Category: Database