2 ways to Remove ONLY_FULL_GROUP_BY in mysql server Temporary & Permanently. with phpmyadmin and by modifying the server configuration file
Simple steps to Install and MySQL, PHP 8.0, phpMyAdmin with Nginx on an Ubuntu 20.04 Server
Just like you, I was having problems with this error When $cfg['blowfish_secret'] is set, the configuration file will now require a secret passphrase. It should be 32 bytes long.
A 413 Nginx error occurred while uploading the database through phpMyAdmin. the requested entity was too large as per the error.
While Importing SQL dump ERROR 3554 (HY000) at line 318: Access to system table 'mysql.innodb_index_stats' is rejected.
Error in processing request Error code: 413 Error text: Request Entity Too Large (rejected) It seems that the connection to server has been lost.
(HY000): Can't connect to localhost MySQL server through socket, ERROR 2002 (HY000): '/var/run/mysqld/mysqld.sock' (2), the best solution online right now here.