
How to install phpMyAdmin on a Laravel Forge Server
Background Installing phpMyAdmin on a Laravel Forge server can be an enormous challenge. One would image you can just specify phpmyadmin/phpmyadmin as the repo and
Background Installing phpMyAdmin on a Laravel Forge server can be an enormous challenge. One would image you can just specify phpmyadmin/phpmyadmin as the repo and
Background After installing a new server, or doing a server migration, you find you can’t suddenly can’t log into PHPMyAdmin as root anymore. The errors
Background You might experience the following MySQL error whilst trying to restore a Virtualmin database: #3 – Error writing file ‘./DB_NAME/TABLE_NAME.frm’ (Errcode: 122) Solution Check
Background Microsoft has made massive strides in supporting PHP on Linux in the last few years. A common need in a PHP application might be
This can be done by disabling index checks. Yes you can: SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table1; TRUNCATE table2; SET FOREIGN_KEY_CHECKS = 1; With these
Background Issue the following command if you want to see in Megabytes the size of all MySQL tables from the command line: SELECT table_name AS
Background Under certain circumstances you might want to trash all the databases you have on a server. This article explains how to do it. Please
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():