Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpMyAdmin configuration

Tags:

php

phpmyadmin

  • How do I increase phpmyadmin session timeout?
  • How do I increase phpmyadmin import file size limit(currently it says Max: 2,048KiB). I tried changing upload_max_filesize in php.ini but it didn't make any difference.
like image 690
Caner Avatar asked Dec 05 '10 21:12

Caner


People also ask

How configure phpMyAdmin in SQL?

Step 2: Downloading And Installing PHPMyAdminOnce the file has been downloaded, run the following command to unzip it. Wait for the command to finish its process. Once done, run the following command to delete the zip. Let's rename the folder so that we can access it easily by running the following command.

What is phpMyAdmin configuration storage?

phpMyAdmin settings are stored in a MySQL database to retain them between browser sessions. Setting up the storage requires minor updates to a MySQL database and the phpMyAdmin confic. inc. php file. MySQL CREATE TABLE.

How do I find my phpMyAdmin IP address?

How do you find IP address in phpMyAdmin? The SQL query SHOW VARIABLES WHERE Variable_name = 'hostname' will show you the hostname of the MySQL server which you can easily resolve to its IP address. SHOW VARIABLES WHERE Variable_name = 'port' Will give you the port number. Show activity on this post.


2 Answers

config.inc.php > $cfg['LoginCookieValidity'] = 3600 * 9; // 9 hours

edit from the link posted by ajreal: LoginCookieValidity

for the second question , after changing upload_max_filesize in php.ini did you restart apache ( or whatever webserver you use ) ?

like image 178
Poelinca Dorin Avatar answered Sep 21 '22 14:09

Poelinca Dorin


How to set phpMyAdmin default 1440 second timeout higher:

  1. locate php.ini

    el@apollo:/var/lib/phpmyadmin$ locate php.ini /etc/php5/apache2/php.ini 
  2. open the file as root to edit, find this line:

    session.gc_maxlifetime = 1440 
  3. Change it to this (500000 seconds is 5.7 days)

    session.gc_maxlifetime = 500000 
  4. Restart apache.

Doing this decreases security because then it increases opportunity for cross site scripting and man in the middle attacks. It's all fun and games until you find your server is part of a botnet farming for credit cards.

like image 44
Eric Leschinski Avatar answered Sep 20 '22 14:09

Eric Leschinski