phpMyAdmin can be a bit overkill for small queries on a MySQL database and if the db is 'localhost' and can't be connected to locally then you need something quick to see what's going on, so you need phpminiadmin.
phpminiadmin – extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases.
Instead of installing huge phpMyAdmin (~11Mb) and trying to figure out how to use all it's features,
just upload one ~10Kb file and it's ready to use!
- then access it via the browser (ex. http://yoursite.com/phpminiadmin.php)
- script will ask you for DB login/pwd
- after successfull db login you will see area where you able to enter any SQL commands (select, update, insert, etc.)
- even if you don't know SQL it's still easy to:
- browse tables and see all the data
- manage tables in DB
- export and import data using 'quick links' on the top bar
- see what databases you have permission with
- check server status and statistics
- ability to do CRUD (i.e. insert, select, update, delete)
- and launch any SQL supported by any version of MySQL
And due to it's simplicity script really fast and need just a little server resources! (your hosting provider will be glad ;)
Get it from here: http://phpminiadmin.sourceforge.net/
This is really a great script. Almost a life saver for web developers like us. Often times we have to download a db without phpmyadmin access. It is so small and quick that we find ourselves using it very often. And so many features in such a short file! Fantastic job and my heartfelt thanks!