/phpminiadmin

extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases

Primary LanguagePHP

other screenshots

How to Install

  • Download phpminiadmin.php file
    • example: wget https://raw.github.com/osalabs/phpminiadmin/master/phpminiadmin.php
  • Copy/Upload it to your webserver public directory (www or public_html or whatever...)
  • Open in your browser http://yoursite.com/phpminiadmin.php

Recommended: For additional security you may edit phpminiadmin.php file and set some password (see $ACCESS_PWD variable)

Dependencies

The only required php extension is mysqli. Therefore if you got a white screen install it:

sudo apt-get install php-mysql on Debian or enable extension=php_mysqli.dll in php.ini on Windows

Config file (optional)

You can also create phpminiconfig.php in the same directory as phpminiadmin.php with database credentials or password. This way you can easily install future releases of phpminiadmin.php

In the directory samples you'll find phpminiconfig.php for known OpenSource packages

  • See phpminiconfig.php for an empty example
  • See phpminiconfig.magento.php to read Magento its app/etc/local.xml ($ACCESS_PWD is required)
  • See phpminiconfig.sugarcrm.php to read SugarCRM its config.php ($ACCESS_PWD is required)
  • See phpminiconfig.wordpress.php to read Wordpress its wp-config.php ($ACCESS_PWD is required)
  • See phpminiconfig.vtiger.php to read Vtiger its config.inc.php ($ACCESS_PWD is required)

Links

Change Log

changes in phpMiniAdmin 1.9.190822 (latest)

  • added ability to set socket for db connection

changes in phpMiniAdmin 1.9.170730

  • fixed potential XSS in database names and fields #28
  • db NULLs now displayed in italic to distinguish from "NULL" text
  • misc formatting adjustments

changes in phpMiniAdmin 1.9.170203

  • added "compact view" option. If checked - width/height of grid cells limited, so you can see more rows/columns in case your data is large. And in this mode you can double-click on cells to "expand" just that particular cell.

changes in phpMiniAdmin 1.9.170117

  • greatly optimized memory usage for large result sets (especially in export)

changes in phpMiniAdmin 1.9.161116

  • added ability to dump exports right on server, without need to download
  • added ability to import from .sql or .gz file right on server, without need to upload one
  • fixed export, now it won't dump data for VIEWs

see older changes in changelog