linux howto's for Server System Administrations

Install MongoDB Using Vagrant In Linux

Vagrant is an open source software that provides a clean, easy to configure, reproducible, and portable development environment. Using Vagrant, we can easily and quickly build and maintain different virtual …

Database / NoSQL / Tutorials / Ubuntu

How to Install Apache CouchDB 3.1 on Ubuntu 20.04 LTS

Apache CouchDB is a NoSQL open-source document-oriented database system written in Erlang, JavaScript, C, and C++. It uses JSON to store data. Documents can be accessed with your web browser. …

Database / LAMP Stack / Linux / MySQL / MySQL 8 / MySQL database / MySQL server / Reset mysql root password / Ubuntu

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 …

Category: Database