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 and
mysql
PHPMyAdmin error requested authentication method unknown to the client [caching_sha2_password]
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():
How to detach/release and re-attach a database in Virtualmin
How to detach/release and re-attach a database in Virtualmin Sometimes a database gets orphaned in Virtualmin. It’s still there, but it’s not attached to a
How to setup SSH, Nginx, UFW, and MySQL on a new Ubuntu Server
This quick guide will show you how to set up an NGINX and UncomplicatedFirewall on an Ubuntu Server Update Packages to bring your system up
What is the listen port network interface for MySQL and how can you change it?
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
How to backup and restore a MySQL database from the command line
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
How to log queries in real time using MariaDB/MySQL
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
Communication link failure: 1153 Got a packet bigger than ‘max_allowed_packet’ bytes (SQL: update…
Whilst updating a Trix Editor field box with many images, you get the following error: [2019-01-18 10:12:07] local.ERROR: SQLSTATE[08S01]: Communication link failure: 1153 Got a
How to install LAMP (Linux, Apache, Mysql (MariaDB) and PHP on Debian
Here is a link on how to install LAMP on a Debian server: Solution: Follow this article straight from the Debian website: https://wiki.debian.org/LaMp#Installation
How do you rename a MySQL table?
rename table t1 to t2; Reference: https://blog.marceloaltmann.com/en-how-to-rename-table-in-mysql-pt-como-renomear-tabelas-no-mysql/