Wed. Nov 13th, 2019

Blogvaria

The personal pages

phpMyAdmin Tips and Tricks

1 min read

When dealing with database driven websites you probably (like me) use phpMyAdmin to manage and maintain your database(s). Below is a few useful “one-liners” gathered over the years…

Modifying the configuration settings

By modifying config.inc.php in the root directory where you installed phpMyAdmin you can add numerous additional functions and features. All it takes is adding a line or two.

Default theme

$cfg['ThemeDefault'] = 'some_theme';

Link to phpinfo()

$cfg['ShowPhpInfo'] = TRUE;

“Show all” rows button

$cfg['ShowAll'] = TRUE;

Hide databases from the menu

$cfg['Servers'][$i]['hide_db'] = '(test|mysql|etc...)';

Setting the fontsize

if ( !isset($_COOKIE['pma_fontsize']) ) :
    $_GET['fontsize'] = "80%"; # Whatever size you like
endif;

More options are available by browsing libraries/config.default.php which is very well documented.

Copyright © All rights reserved. | Newsphere by AF themes.
Follow
Get every new post delivered to your inbox
Join millions of other followers
Powered By WPFruits.com