Filter by Category
Filter by Tags
In this article, I will show you how to fix the following MySQL/MariaDB error: Grant MySQL/MariaDB User SUPER Privilege To fix the issue, log in to your MySQL/MariaDB database as root user and grant SUPER privilege to your MySQL/MariaDB user (magento_dev@localhost in this case) using the following SQL statement: For…
In this article, I am going to show you how to create a new MySQL/MariaDB database and configure it to use specific character set and collation. I will also show you how to character the character set and collation of an existing database. Listing Available MySQL/MariaDB Character Sets To list…
In this article, I am going to show you how to create a new MySQL/MariaDB database, create a new MySQL/MariaDB user, and grant the new user access to the newly created database. Connect to the Database To access the MySQL/MariaDB server as root user, run the command below. When prompted,…
Compiling PostgreSQL Tutorial Files on Fedora Install the required PostgreSQL devel packages and build tools with the following command: Download PostgreSQL source file from the official PostgreSQL website and extract it in your desired location. Once the PostgreSQL source file is downloaded and extract, open a Terminal and navigate to…
Installing PostgreSQL 17 on Fedora 42 Update package repository cache Install PostgreSQL 17 client and server packages Initializing PostgreSQL 17 Data Directory Initialize the PostgreSQL database directory Starting PostgreSQL 17 Start PostgreSQL 17 systemd service Add PostgreSQL service to system startup so that it starts automatically at system boot PostgreSQL…