#mysql

Change MySQL 8 root user password
Privileges in MySQL
Fix MySQL error: SELECT list is not in GROUP BY clause and contains nonaggregated column incompatible with sql_mode=ONLY_FULL_GROUP_BY
Do not pass MySQL DB server credentials directly but pass them using a file
Fix MySQL/MariaDB error "Got a packet bigger than 'max_allowed_packet' bytes"
Change max_user_connections without restarting the MySQL server
Get MySQL table data by a query using mysqldump
Get all MySQL tables from a target database to a bash variable
Get all MySQL databases except the system ones to a bash variable
docker-compose.yaml files for MySQL and MariaDB with shared volumes
Force MySQL client to connect by TCP instead of a unix socket
Dump only database structure with mysqldump
Fix mysqldump error “Access denied while using LOCK TABLES“
Find users and hosts logged into MySQL
MySQL/MariaDB in Docker - allow access from all hosts
Another fix for error "Authentication plugin 'caching_sha2_password' cannot be loaded"
Troubleshooting MySQL Master/Slave replication
Reset MySQL root password in Linux
MySQL allow root remote login
Fix error of cannot login to phpMyAdmin due plugin changes
Install MariaDB with phpmyadmin and secure the access to it with .htaccess
Quick way to create a dababase and user with password for MySQL/MariaDB
MySQL basics after installation
Crontab for MySQL backup
Uninstall validate_password plugin for MySQL
Fix MySQL error "Plugin caching_sha2_password could not be loaded"