phpMyAdmin navigation frame not resizable

If you have long database table names you may find it frustrating to use phpMyAdmin, having the end portion of many long tables names truncated. There is really no easy way to widen the navigation frame either… Your last option is to horizontally scroll right… Nooooooooooo….

OK, here is a little fix. The problem here is, there is nothing for you to grab to widen the left frame. That’s due to the fact that the frame border is set to 0. So to fix that, open up the index.php file, search for the first occurrence of frameborder, then change the frameborder variable to 1, or anything but 0.

     <frame frameborder="1" id="frame_navigation"
         src="navigation.php"
         name="frame_navigation" />

Now you will have a vertical bar to hold onto to do your resizing. You can probably make the bar skinner with css, but this is already good enough for me.

One more thought, you can also hard code the frame width if you want.

phpMyAdmin timeout after 1440 seconds

I keep getting this timeout error from phpmyadmin: “No activity within 1440 seconds; please log in again“. @#%@#$@$@ So I decided to change that setting. Open up your config.inc.php file and add the following line: (If you don’t have config.inc.php, copy from config.sample.inc.php)

$cfg['Servers'][$i]['LoginCookieValidity'] = 60 * 60 * 12;

The above setting sets the timeout value to 12 hours in phpMyAdmin.

If your server crashed and cannot load your phpmyadmin page, check your apache log at /var/log/apache2/error.log. If you got PHP Fatal error: Call to a member function get() on a non-object in /path/to/phpmyadmin/libraries/Header.class.php on line 135, then do a chmod 644 config.inc.php. that should take care of the error.

You will then get another warning: “Your PHP parameter session.gc_maxlifetime is lower that cookie validity configured in phpMyAdmin, because of this, your login will expire sooner than configured in phpMyAdmin.“. That makes sense because php’s session will time out first anyways. So we will need to change /etc/php.ini .

session.gc_maxlifetime = 43200

That’s 12 hours in seconds. Restart your apache server and you are done!