MySQL Check All Databases
Background Having a broken MySQL / MariaDB database is no fun. Broken tables can also lead to half complete backups really compounding the situation. If
Background Having a broken MySQL / MariaDB database is no fun. Broken tables can also lead to half complete backups really compounding the situation. If
Background If you have a server with sufficient RAM but you are running out of MySQL connections, you might want to look at two easy
Whilst trying to install or use PHPMyAdmin, you might encounter the following errors: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect():
Symptoms You’re looking at a database table in PHPStorm but all the records are not showing. The only clue you have is the words 930.44
Port Number The port number for MySQL is TCP port 3306. See where it’s listening How can you see if it’s listening on more than
Backing Up To backup a MySQL database from the command line, use the mysqldump command and pip the output to a file. For example: mysqldump
Background You have some sticky queries but you can’t see what’s happening. On certain website actions pages are just slow and you fully suspect the
You might encounter a situation (e.g. on AWS) where you have a new CentOS 7 server, but an old version of MariaDB 5.5 on the
Background A MySQL server stop working. You’re confused as this is a new Virtualmin installation and everything went smooth. You start troubleshooting: # service mariadb
Update February 2022 Resetting MySQL password remains a nightmare due to all the differences between MySQL 7 and 8, and MariaDB. If you’re running the