NEW: Full Featured Reports & Dashboards Builder Tool for MySQLAvailable now, free trial version available for downloading:
MySQL Database Navigation and Pagination
IntroductionIf you are working with hosting MySQL databases, and pick up data from them frequently, this script may make your life easy working with them.
- navigate and paginate to your databases tables;
- Filter table data on the fly without coding SQL;
- export table data(may contains filter conditions) to csv etc. format;
- SQL Editor helps you fire queries from database and export the resultset;
- Web based MySQL shell emulator for the command-enthusiast;
- download, uncompress and use it. no configuration needed.
This is a drag-drop to use script. Just download the zip and uncompress it to your web directory, than start to use.
This script will populate all databases with your account, you can choose to hide some database by chaning the configuration.
Setting IP whitelist
In most cases, you just want to allow accessing the item at some ips(at home or at work), in this case, please configure the whitelist. All ip addresses not in the whitelist will be denied to access the service. Please go to the installation directory, and open the application/config/config.php file, and find the following line:
$config[‘white_list’]=; i.e. Edit it to $config[‘white_list’]=’192.168.0.1-192.168.0.24;22.214.171.124’;’‘
you may have known, only 192.168.0.1 ~ 192.168.0.24 and 126.96.36.199 allowed to access the service.
SupportAny question about me and my scripts, please let me know. I’d like to help
Postgre, Oracle, SQL Server Support versionPostgreSQL, Oracle, SQL Server version available soon at https://www.dbface.com/, You can contact me to get a beta version now.
I would like your comments, new feature request (i will implement it), also new design requests / suggestions.
Live demo: https://www.dbface.com