Tag: MySQL

8 Best MySQL/MariaDB GUI Tools for Linux Administrators

MySQL is one of the most widely-used open-source relational database management systems (RDBMS), that has been around for a long time. It is an advanced, fast, reliable, scalable, and easy-to-use RDBMS intended for mission-critical, heavy-load

How to Install dbWatch to Monitor MySQL Performance in Linux

dbWatch is a powerful, multi-platform, fully-featured, and enterprise-grade SQL database monitoring and management tool that gives you full control over your database instances and system resources. It is highly scalable, secure, and designed for managing

How to Setup MySQL Replication in RHEL, Rocky and AlmaLinux

Data replication is the process of copying your data across multiple servers to improve data availability and enhance the reliability and performance of an application. In MySQL replication, data is copied from a database from

How to Install MySQL 8.0 on RHEL/CentOS 8/7 and Fedora 35

MySQL is an open-source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database.

How to Install MySQL 8.0 on Rocky Linux 8

Written in C, MySQL is an open-source, cross-platform, and one of the most widely used Relational Database Management Systems (RDMS). It’s an integral part of the LAMP stack and is a popular database management system

How to Setup MySQL Master-Slave Replication on RHEL 8

MySQL Replication is a process where data from one server is automatically copied or replicated onto another backup server in real-time. Replication provides redundancy and fault tolerance and gives the user peace of mind that

How To Create a New User and Grant Permissions in MySQL

MySQL is a popular and widely used database management system that stores and organizes data and allows users to retrieve it. It comes with a vast array of options that grant users certain permissions to

How to Fix “MySQL ERROR 1819 (HY000):” in Linux

When creating a MySQL user with a relatively weak password, you might encounter the error ‘MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements’. Technically, this is not an error, but

How to Fix ERROR 1130 (HY000): Host is not allowed to connect to this MySQL server

In this quick article, you will learn how to solve the “ERROR 1130 (HY000): Host x.x.x.x is not allowed to connect to this MySQL server” error in MySQL/MariaDB database deployment on a Linux system. This