When the PHPMyAdmin is stuck with the message “The system will redirect you in a moment,” it may encounter a redirect loop.
When MySQL is unable to create the temporary users, it throws the error, and it can be found at the following path: /usr/local/cpanel/logs/error_log:
Cpanel::Exception::Database::Error/(XID 9a8sak) The system received an error from the “MySQL” database “mysql”: 1 (Can’t create/write to file ‘/tmp/#sql_5a2_0.MAI’ (Errcode: 30 “Read-only file system”))
It may result due to the missing permission of tmp file. therefore check the permission; if we tend to find it in a very false state such as “Ready Only,” we simply have to be compelled to remount this file using the below command.
Command: mount -o remount,rw /tmp