{"id":120,"date":"2009-08-03T15:58:12","date_gmt":"2009-08-03T19:58:12","guid":{"rendered":"http:\/\/www.compdigitec.com\/labs\/?p=120"},"modified":"2009-08-03T16:00:52","modified_gmt":"2009-08-03T20:00:52","slug":"mysql-query-browser-a-standalone-mysql-administration-tool","status":"publish","type":"post","link":"http:\/\/www.compdigitec.com\/labs\/2009\/08\/03\/mysql-query-browser-a-standalone-mysql-administration-tool\/","title":{"rendered":"MySQL Query Browser &#8211; a standalone MySQL administration tool"},"content":{"rendered":"<p>Online MySQL administration tools such as <a href=\"http:\/\/www.phpmyadmin.net\/\">phpMyAdmin<\/a> 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 &#8220;browser overhead&#8221; 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.<\/p>\n<div style=\"width: 603px\" class=\"wp-caption aligncenter\"><a href=\"\/images\/labs\/mysql_query_browser.png\"><img decoding=\"async\" loading=\"lazy\" title=\"MySQL Query Browser running on Ubuntu\" src=\"\/images\/labs\/mysql_query_browser.png\" alt=\"MySQL Query Browser running on Ubuntu\" width=\"593\" height=\"466\" \/><\/a><p class=\"wp-caption-text\">MySQL Query Browser running on Ubuntu<\/p><\/div>\n<p><strong>Installation<\/strong><\/p>\n<ul>\n<li><strong>Windows<\/strong> &#8211; <a title=\"Download MySQL Query Browser\" href=\"http:\/\/dev.mysql.com\/get\/Downloads\/MySQLGUITools\/mysql-gui-tools-5.0-r17-win32.msi\/from\/pick\">Download <\/a>MySQL Query Browser from MySQL and install.<\/li>\n<li><strong>Linux<\/strong> &#8211; Install the package &#8220;mysql-query-browser&#8221; along with any depenencies specified by your package manager (<strong>sudo apt-get install mysql-query-browser<\/strong> in a terminal)<\/li>\n<\/ul>\n<p>If you found this article helpful or useful, please help Compdigitec spread the word. Don\u2019t forget to <a href=\"\/labs\/feed\/\">subscribe to Compdigitec Labs<\/a> for more useful or interesting articles!<\/p>","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,4],"tags":[542,862,220,540,541,60],"_links":{"self":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/120"}],"collection":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":0,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}