Databases
What is NewSQL? Bridging SQL and NoSQL
Hey there! If you’ve ever heard about databases and wondered what the deal is with NewSQL, you’re in the right…
Category: Databases
MySQL, MariaDB, PostgreSQL, MongoDB, Redis and SQL Server: install, manage, back up and tune.
Databases
How to Fix the “Access Denied: SUPER Privilege Required” Error in Databases
When you work with databases, you might see the error message: “Access denied; you need (at least one of) the…
Databases
How to Create a User with Socket Authentication in MySQL/MariaDB
In MySQL and MariaDB, you can create users that connect to the database using socket authentication instead of traditional username…
Databases
How to Install MariaDB on Ubuntu 24.04
MariaDB is a popular, open-source relational database management system that is a fork of MySQL. It is widely used for…
Databases
How to Install MySQL Server on Ubuntu 24.04
This guide will show you how to install MySQL on Ubuntu 24.04 using official PPA. MySQL is a popular database…
Databases
How to Install and Configure PostgreSQL on Ubuntu 24.04
PostgreSQL is a powerful and popular open-source database management system. It is known for its reliability, robustness, and excellent performance.…
Databases
Creating MySQL User with GRANT OPTION
This guide will show you how to create a new user in MySQL and give them the ‘GRANT OPTION’ privilege.…
Databases
Changing PostgreSQL Database Owner
Changing the owner of a PostgreSQL database can be necessary for various reasons, such as transferring responsibilities or updating user…
Databases
How to Resolve ERROR 1040 (08004): Too many connections in MySQL
MySQL is one of the most popular open-source relational database management systems. It is still very common database among the…
Databases
mysql: [Warning] Using a password on the command line interface can be insecure.
When working with MySQL from the command line, users often encounter the warning message “mysql: [Warning] Using a password on…