5.5.1 Administration

6 entries match these filters

• 0214 MySQL users and privileges: CREATE USER, GRANT and authentication plugins A MySQL account is a user name plus the host it connects from. You create it with CREATE USER, give it rights… Beginner · How-to · Linux Article Administration · Security & access 15 Oct 2026
• 0215 mysql command-line client cheat sheet The connection options, built-in commands and everyday SQL you need in the mysql (and mariadb) command-line client, on one page. Beginner · Reference · Any system Article Administration · Queries 15 Oct 2026
• 0218 Setting up MySQL source-replica replication with GTIDs Step by step: configure a MySQL 8.4 source and replica with GTIDs, create the replication account, copy the data, connect the replica… Advanced · How-to · Linux Article Administration · Replication 15 Oct 2026
• 0219 mysqldump nightly backup with rotation (bash) A cron-ready bash script that dumps each MySQL or MariaDB database to its own compressed file with --single-transaction, verifies it and deletes… Intermediate · How-to · Linux Script Administration · Backup & restore 15 Oct 2026
• 0220 Fix: ERROR 1045 (28000): Access denied for user ‘appuser’@’localhost’ (using password: YES) The server rejected the user, host and password combination. Usually it is a wrong password, a host part that does not match,… Beginner · Fix · Linux Article Administration · Security & access 15 Oct 2026
• 0258 Build a MySQL 8.4 source-replica pair with GTIDs and rehearse a manual failover Set up GTID replication between two MySQL 8.4 servers, provision the replica with the clone plugin, then stop the source, promote the… Advanced · Tutorial · Linux Article Administration · Replication 15 Oct 2026