phpMyAdmin stops working after upgrade to MySQL version 8
After an upgrade to MySQL version 8 the users can’t login to phpMyAdmin anymore. In troubleshooting the problem, you issue the following command: mysql> grant
After an upgrade to MySQL version 8 the users can’t login to phpMyAdmin anymore. In troubleshooting the problem, you issue the following command: mysql> grant
How to run a MySQL query using the command line: Use -e to execute the command. Here is what that will look like: mysql -u
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