« Solving “Fatal error: Exception thrown without a stack frame in Unknown on line 0” | Home | Solving svn: /opt/lampp/lib/libcrypto.so.0.9.8: no version information available »
MySQL Query Browser – a standalone MySQL administration tool
By admin | August 3, 2009
Online MySQL administration tools such as phpMyAdmin are great for administering MySQL databases, but unfortunately it is not so great if you work with large databases or have to mass manipulate records. By using an offline MySQL administration tool, you can remove the overhead of the HTTP(S), (X)HTML and the web browser by communicating directly with your database. MySQL Query Browser is an official tool developed by MySQL AB and Sun Microsystems in order to adminster MySQL databases remotely. It is usually faster that using something like phpMyAdmin because it does not have a “browser overhead” unlike other server-run tools. It is also official and supported by the developers of MySQL meaning that it will always be compatible with MySQL, which third-party products tend to lack. A disadvantage of MySQL Query Browser is that is requires the database to listen on the network.
Installation
- Windows – Download MySQL Query Browser from MySQL and install.
- Linux – Install the package “mysql-query-browser” along with any depenencies specified by your package manager (sudo apt-get install mysql-query-browser in a terminal)
If you found this article helpful or useful, please help Compdigitec spread the word. Don’t forget to subscribe to Compdigitec Labs for more useful or interesting articles!
If you found this article helpful or interesting, please help Compdigitec spread the word. Don’t forget to subscribe to Compdigitec Labs for more useful and interesting articles!
Topics: Linux, Windows | No Comments »