Steps to resolve PhpMyAdmin redirecting issue

Steps to resolve PhpMyAdmin redirecting issue

PhpMyAdmin redirecting due to read-only /tmp – Hope, this is mainly because of the MySQL which works directly or indirectly to bring errors.

Sometimes, PhpMyAdmin figures out the loop again and again by giving the warning message “The system will redirect you in a moment”. Why because MySQL fails to process temporary users who will operate phpMyAdmin.

You will get a error reflection in the 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”))
To cross-check the filesystem status of /var/tmp and /tmp , take a look on the below part:

# mount -l | grep -i "tmpDSK"
/usr/tmpDSK on /tmp type ext4 (ro,nosuid,noexec,relatime,seclabel,discard,data=ordered)
/usr/tmpDSK on /var/tmp type ext4 (ro,nosuid,noexec,relatime,seclabel,discard,data=ordered)
You have a situation only to mount the filesystem that too in Read-Only stats.

The filesystem is defined with the stats Read-Only by the operating system. Whenever, disk or filesystem figures error, automatically operating system starts setting up the Read-Only stats.

By setting Read-Only, you will never allow writing so, it will secure the problem.

Here’s the code to run for mounting the filesystem:

mount -o remount,rw /tmp
/tmp – This helps to mount the filesystem
In the conclusion, mounting the filesystem can help you to deal with resolving PhpMyAdmin redirecting due to read.
First release
Last update
0.00 star(s) 0 ratings

More resources from kumkumsharma