{"id":49,"date":"2010-05-09T22:32:22","date_gmt":"2010-05-09T17:02:22","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=49"},"modified":"2010-05-09T22:32:22","modified_gmt":"2010-05-09T17:02:22","slug":"install-mysql-and-query-browser-in-ubuntu","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/others\/linux\/install-mysql-and-query-browser-in-ubuntu\/","title":{"rendered":"Install MySQL and Query Browser in Ubuntu"},"content":{"rendered":"<p><!-- \t\t@page { margin: 2cm } \t\tP { margin-bottom: 0.21cm } --><span style=\"font-family: Verdana;\"><span>To open the Terminal, go to<\/span><\/span><strong><span style=\"font-family: Verdana;\"><span> Application &gt; Accessories &gt; Terminal<\/span><\/span><\/strong><\/p>\n<figure id=\"attachment_50\" aria-describedby=\"caption-attachment-50\" style=\"width: 300px\" class=\"wp-caption alignnone\"><strong><strong><span><span><a href=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/1.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-50\" title=\"1\" src=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/1-300x245.jpg?resize=300%2C245&#038;ssl=1\" alt=\"Open terminal in ubuntu\" width=\"300\" height=\"245\" \/><\/a><\/span><\/span><\/strong><\/strong><figcaption id=\"caption-attachment-50\" class=\"wp-caption-text\">Open terminal in ubuntu<\/figcaption><\/figure>\n<p><strong> <\/strong><\/p>\n<p><!-- \t\t@page { margin: 2cm } \t\tP { margin-bottom: 0.21cm } --><strong> <\/strong><span style=\"font-family: Verdana;\"><span>Type the following command at terminal.<\/span><\/span><\/p>\n<ul>\n<li><strong> <\/strong><strong><span style=\"font-family: Verdana;\"><span>$sudo \tapt-get install mysql-server<\/span><\/span><\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_51\" aria-describedby=\"caption-attachment-51\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/MySql.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-51 \" title=\"console screen look like during downloading the mysql in Ubuntu\" src=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/MySql-300x211.png?resize=300%2C211&#038;ssl=1\" alt=\"console screen look like during downloading the mysql in Ubuntu\" width=\"300\" height=\"211\" \/><\/a><figcaption id=\"caption-attachment-51\" class=\"wp-caption-text\">console screen look like during downloading the mysql in Ubuntu<\/figcaption><\/figure>\n<p><!-- \t\t@page { margin: 2cm } \t\tP { margin-bottom: 0.21cm } --><\/p>\n<ul>\n<li><span style=\"font-family: Verdana;\"><span>mysql comes with no root \tpassword. To set the root password, type:<\/span><\/span><\/li>\n<\/ul>\n<p><strong><span style=\"font-family: Verdana;\"><span> $mysqladmin -u <span style=\"color: #ff0000;\">root<\/span> password <span style=\"color: #ff0000;\">your-new-password<\/span><\/span><\/span><\/strong> <strong> <\/strong><strong><span style=\"font-family: Verdana;\"><span> <\/span><\/span><\/strong><\/p>\n<p><strong><span style=\"font-family: Verdana;\"><span>$sudo \/etc\/init.d\/mysql restart<\/span><\/span><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: Verdana;\"><span>Install mysql query browser<\/span><\/span><\/li>\n<\/ul>\n<p><strong><span style=\"font-family: Verdana;\"><span> $sudo apt-get install mysql-query-browser<\/span><\/span><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: Verdana;\"><span>After installing, go to <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>Applications<\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span> &gt; <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>Programming <\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span>&gt; <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>MySQL \tQuery Browser <\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span>to \tconnect to mysql as shown below.<\/span><\/span><\/li>\n<\/ul>\n<figure id=\"attachment_52\" aria-describedby=\"caption-attachment-52\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/MySQLQueryBrowser.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-52\" title=\"open mysql query browser in ubuntu\" src=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/MySQLQueryBrowser-300x291.jpg?resize=300%2C291&#038;ssl=1\" alt=\"open mysql query browser in ubuntu\" width=\"300\" height=\"291\" \/><\/a><figcaption id=\"caption-attachment-52\" class=\"wp-caption-text\">open mysql query browser in ubuntu<\/figcaption><\/figure>\n<p><!-- \t\t@page { margin: 2cm } \t\tP { margin-bottom: 0.21cm } --><span style=\"font-family: Verdana;\"><span>Enter <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>Server Hostname<\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span>, <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>Username<\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span> and <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>Password<\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span>. Click on <\/span><\/span><strong><span style=\"font-family: Verdana;\"><span>Connect <\/span><\/span><\/strong><span style=\"font-family: Verdana;\"><span>and MySQL is now installed on Ubuntu.<\/span><\/span> <span style=\"font-family: Verdana;\"><span> <\/span><\/span><\/p>\n<figure id=\"attachment_53\" aria-describedby=\"caption-attachment-53\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><span><span><a href=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/ConnectMySQL.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53\" title=\"Connect to MySQL using Query Browser in Ubuntu\" src=\"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/ConnectMySQL-300x270.jpg?resize=300%2C270&#038;ssl=1\" alt=\"Connect to MySQL using Query Browser in Ubuntu\" width=\"300\" height=\"270\" \/><\/a><\/span><\/span><figcaption id=\"caption-attachment-53\" class=\"wp-caption-text\">Connect to MySQL using Query Browser in Ubuntu<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>To open the Terminal, go to Application &gt; Accessories &gt; Terminal Type the following command at terminal. $sudo apt-get install mysql-server mysql comes with no root password. To set the root password, type: $mysqladmin -u root password your-new-password $sudo \/etc\/init.d\/mysql restart Install mysql query browser $sudo apt-get install mysql-query-browser After installing, go to Applications &gt; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[27],"tags":[70,339,148,162,205],"class_list":["post-49","post","type-post","status-publish","format-standard","hentry","category-linux","tag-database","tag-linux","tag-mysql","tag-query-browser","tag-ubuntu"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":287,"url":"https:\/\/www.jitendrazaa.com\/blog\/java\/install-sun-java-6-on-ubuntu-10-04\/","url_meta":{"origin":49,"position":0},"title":"How to Install java on Ubuntu 10 and Ubuntu 11","author":"Jitendra","date":"June 13, 2010","format":false,"excerpt":"Run below command on the terminal of ubuntu to install the JAVA. Ubuntu 10 : Ubuntu 11:","rel":"","context":"In &quot;JAVA&quot;","block_context":{"text":"JAVA","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":58,"url":"https:\/\/www.jitendrazaa.com\/blog\/others\/linux\/install-avast-antivirus-in-ubuntu\/","url_meta":{"origin":49,"position":1},"title":"Install Avast Antivirus in Ubuntu","author":"Jitendra","date":"May 9, 2010","format":false,"excerpt":"avast! Home Edition is a complete anti-virus package, that is is free for registered home non-commercial users. It contains an on-demand scanner with two interfaces (simple for novices and advanced for experienced users), an on-access scanner with Standard Shield (which protects against execution and opening malware programs) and an embedded\u2026","rel":"","context":"In &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/others\/linux\/"},"img":{"alt_text":"Open Avast Antivirus in ubuntu","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/1-256x300.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2293,"url":"https:\/\/www.jitendrazaa.com\/blog\/webtech\/free-up-mysql-space-in-wordpress-delete-akismet-logs\/","url_meta":{"origin":49,"position":2},"title":"Free up MySQL Space in WordPress &#8211; Delete Akismet Logs","author":"Jitendra","date":"June 28, 2011","format":false,"excerpt":"Free up MySQL Space in Wordpress - Delete unused Akismet Logs","rel":"","context":"In &quot;Web Technology&quot;","block_context":{"text":"Web Technology","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/webtech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":603,"url":"https:\/\/www.jitendrazaa.com\/blog\/others\/linux\/remove-ubuntu-from-dual-boot\/","url_meta":{"origin":49,"position":3},"title":"Remove Ubuntu from Dual boot","author":"Jitendra","date":"July 7, 2010","format":false,"excerpt":"How to remove ubuntu from system and use previously installed Windows XP\/ Vista.","rel":"","context":"In &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/others\/linux\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6759,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/docker-cheat-sheet\/","url_meta":{"origin":49,"position":4},"title":"Docker Cheat sheet","author":"Jitendra","date":"January 25, 2019","format":false,"excerpt":"Frequently used docker commands and cheatsheet","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Docker cheat sheet","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Docker-cheat-sheet.png?fit=1200%2C553&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Docker-cheat-sheet.png?fit=1200%2C553&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Docker-cheat-sheet.png?fit=1200%2C553&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Docker-cheat-sheet.png?fit=1200%2C553&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Docker-cheat-sheet.png?fit=1200%2C553&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":1643,"url":"https:\/\/www.jitendrazaa.com\/blog\/java\/jsp\/servlet-hibernate-jquery-and-ajax-based-google-like-chat\/","url_meta":{"origin":49,"position":5},"title":"Servlet, Hibernate, jQuery and Ajax based google like chat","author":"Jitendra","date":"March 14, 2011","format":false,"excerpt":"Servlet, Hibernate, jQuery and Ajax based google like chat with source code","rel":"","context":"In &quot;Hibernate&quot;","block_context":{"text":"Hibernate","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/java\/hibernate\/"},"img":{"alt_text":"Servlet, Hibernate, jQuery and Ajax based google like chat","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2011\/03\/Servlet-Hibernate-jQuery-and-Ajax-based-google-like-chat.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}