Question
How to increase or modify the timeout limit of a login session in phpMyAdmin?
Answer
-
Plesk for Linux:
For Plesk Obsidian 18.0.30 and above
-
Connect to the server via SSH
-
Go to the file path
/usr/local/psa/phpMyAdmin/
:# cd /usr/local/psa/phpMyAdmin/
-
Create the file
config.inc.php
if it doesn't exist copying the template filelibraries/config.default.php
:# if [ ! -f config.inc.php ]; then cp -a {libraries/config.default.php,config.inc.php}; fi
-
Edit the file
config.inc.php
with a text editor:# vi config.inc.php
-
Change the value of the parameter
LoginCookieValidity
:$cfg['LoginCookieValidity'] = 1800;
-
Save the changes and close the file
For Plesk Onyx and Plesk Obsidian below 18.0.30
-
Connect to the server via SSH
-
Go to the file path
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/
:# cd /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/
-
Create the file
config.inc.php
if it doesn't exist copying the template filelibraries/config.default.php
:# if [ ! -f config.inc.php ]; then cp -a {libraries/config.default.php,config.inc.php}; fi
-
Edit the file
config.inc.php
with a text editor:# vi config.inc.php
-
Change the value of the parameter
LoginCookieValidity
:$cfg['LoginCookieValidity'] = 1800;
-
Save the changes and close the file
-
Plesk for Windows:
For Plesk Obsidian 18.0.30 and above
-
Connect to the server via RDP
-
Go to the following folder path:
%plesk_dir%phpmyadmin
-
Create or edit the file
config.inc.php
with a text editor -
Add or change the value of the parameter
LoginCookieValidity
and save the changes:<?php
declare(strict_types=1);
// ...
$cfg['LoginCookieValidity'] = 1800; -
Edit the Plesk PHP.ini file
%plesk_dir%adminconfphp.ini
with a text editor -
Add or edit the parameter
session.gc_maxlifetime
in the[Session]
section with the same value configured inLoginCookieValidity
and save the changes:...
[Session]
session.gc_maxlifetime = 1800
... -
Log out from phpMyAdmin and Plesk to start a new PHP session
For Plesk Onyx and Plesk Obsidian below 18.0.30
-
Connect to the server via RDP
-
Go to the following folder path:
%plesk_dir%adminhtdocsdomainsdatabasesphpMyAdmin
-
Create or edit the file
config.inc.php
with a text editor -
Add or change the value of the parameter
LoginCookieValidity
and save the changes:<?php
declare(strict_types=1);
// ...
$cfg['LoginCookieValidity'] = 1800; -
Edit the Plesk PHP.ini file
%plesk_dir%adminconfphp.ini
with a text editor -
Add or edit the parameter
session.gc_maxlifetime
in the[Session]
section with the same value configured inLoginCookieValidity
and save the changes:...
[Session]
session.gc_maxlifetime = 1800
... -
Log out from phpMyAdmin and Plesk to start a new PHP session