How to reset root MySQL/MariaDB password on Ubuntu 20.04 Focal Fossa Linux

In this guide we will reset the lost root MySQL/MariaDB mariadb password on Ubuntu 20.04 Focal Fossa. This can be achieved by disabling the root authentication and longing in without the password.

In this tutorial you will learn:

  • How to reset root administrator password on MySQL 8 or higher
  • How to reset root administrator password on MariaDB 10.3 or higher
  • How to disable root authentication and login without password

Read more

How to reset root MariaDB password on Ubuntu 18.04 Bionic Beaver Linux

Objective

The objective is to reset lost root mariadb password on Ubuntu 18.04 Bionic Beaver Linux.

Please note that if you have just installed your MariaDB server and are unable to login as root user with:

$ mysql -u root
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

you do not need to reset your password. Instead, to login as root amend the above command to:

$ sudo mysql

Operating System and Software Versions

  • Operating System: – Ubuntu 18.04 Bionic Beaver
  • Software: – mysql Ver 15.1 Distrib 10.1.25-MariaDB or higher

Requirements

Privileged access to your Ubuntu System as root or via sudo command is required.

Difficulty

EASY

Conventions

Read more

How to Install etcd on Ubuntu

Etcd is a free and open-source distributed and secure key-value store used to store the most critical information of a given distributed system. Etcd is written in Go making it extremely fast in distributed systems without incurring a performance overhead from clustered machines. In this guide, you discover the basics of installing and setting up an etcd cluster on Ubuntu systems.

Read more

Ubuntu Bionic Nginx Configuration LEMP

How To Install Nginx, MariaDB, PHP (LEMP stack) on Ubuntu 18.04 Bionic Beaver Linux

Objective

Install Nginx Web Server (LEMP) on Ubuntu 18.04. In particular, this Linux web server install guide shows you how to install nginx, how to install MariaDB and how to install PHP.

Distributions

Ubuntu 18.04 Bionic Beaver

Requirements

A working install of Ubuntu 18.04 with root privileges

Difficulty

MEDIUM

Conventions

  • # – requires given linux commands to be executed with root privileges either directly as a root user or by use of sudo command
  • $ – requires given linux commands to be executed as a regular non-privileged user

Introduction

If you want to run PHP-based websites on Linux, Apache isn’t your only option. Nginx is a faster, lighter weight, web server that’s fairly easy to configure and get running. Plus, it’s excellent at handling other tasks like load balancing, server optimization, and acting as a reverse proxy. Actually, Nginx is a top choice among startups for hosting their web applications.

Setting Nginx up to host PHP on Ubuntu 18.04 is very simple, and you only need a few packages installed to get started.

Read more

How linux write cache works

Let’s start by explaining what write-back caching is and how it works to better understand the Linux write cache. Write caching is a feature available on most hard drives that allows them to collect all data into the drive’s cache memory, before being permanently written to disk. Once a certain amount of data is collected in the hard drive’s cache memory, the whole data chunk is transferred and stored with a single writing event.

Read more

How to reset MySQL root password on your Linux server

How to reset MySQL root password on your Linux server

Resetting the MySQL root password on a Linux server can be a critical task when access to the MySQL server is lost or when setting up a new server. This process involves several steps, including stopping the MySQL service, starting MySQL in a safe mode, and updating the root password. This guide will walk you through each step in detail to ensure you can reset your MySQL root password successfully.

Read more

How to install redmine on RHEL 8 / CentOS 8 Linux

Redmine is a popular open source project management web application. It supports mayor databases like MySQL and PostgreSQL as backend, and you can also change the frontend to Apache from the WEBrick (recommended for production use) webserver shipped with the installation. In this article we will install the latest Redmine on RHEL 8 / CentOS 8, using PostgreSQL as backend, but we will leave the default WEBrick as frontend, which will serve our tests perfectly.

Do not expect this process to be an easy one, nor error-free. Even following these steps to the letter, some errors will surely happen, the setup seem to handle sudo steps somewhat inconsistently – but the solutions are also included which will guide trough these errors.

In this tutorial you will learn:

  • How to install required operating system packages
  • How to setup the database
  • How to install the Redmine application
  • How to start and login to the application

Read more

How to install WordPress on RHEL 8 / CentOS 8 Linux

This article covers an installation of WordPress, free and open-source content management system, on RHEL 8 Linux Server. In this instance the installation is based on the well-know LAMP stack comprising the RHEL 8, MariaDB, PHP and Apache webserver.

In this tutorial you will learn:

  • How to Install LAMP Stack on RHEL 8 / CentOS 8.
  • How to configure MariaDB database.
  • How to install Wordpress on RHEL 8 / CentOS 8.
  • How to open HTTP and HTTPS firewall ports.

Read more

MySQL: Allow all hosts

If you wish to access your MySQL server remotely, it will be necessary to configure one or more users to allow access from remote hosts. If you do not know all the IP addresses of the connecting hosts, then you can simply allow connections from all hosts.

Read more

How to install mongodb on RHEL 8 / CentOS 8

MongoDB is a document database, storing data in JSON-like form, which is revolutionary approach in the contrast of traditional relational databases. This does not mean that SQL databases will die out anytime soon; they will be here for a long time when you need to store structured data.

That being said, MongoDB gets more and more use cases; the ability to store data in a form that can change on the fly are things that must be counted with.

In this tutorial we will install the latest community release of this NoSQL database to a RHEL 8 / CentOS 8, using the tarball package. For this to work smoothly we’ll set up the minimal environment, and test our configuration and running service.

In this tutorial you will learn:

  • How to download & extract MongoDB tarball
  • How to set up environment for the service
  • How to manage mongod service
  • How to login to mongo shell, insert and query sample data

Read more