{"id":485,"date":"2018-11-30T17:48:42","date_gmt":"2018-11-30T12:18:42","guid":{"rendered":"https:\/\/liai.co.in\/blog\/?p=485"},"modified":"2021-10-27T14:03:17","modified_gmt":"2021-10-27T14:03:17","slug":"how-to-install-mysql-on-linux","status":"publish","type":"post","link":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/","title":{"rendered":"How to install MYSQL on Linux?"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\"><\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">min read<\/span><\/span><div class='epvc-post-count'><span class='epvc-eye'><\/span>  <span class=\"epvc-count\"> 2,911<\/span><\/div><div class=\"h7 \" tabindex=\"-1\" role=\"listitem\">\n<div class=\"Bk\">\n<div class=\"G3 G2\">\n<div id=\":n0\">\n<div class=\"adn ads\" data-message-id=\"#msg-f:1617197681185610902\" data-legacy-message-id=\"167170b906a75c96\">\n<div class=\"gs\">\n<div class=\"\">\n<div id=\":oy\" class=\"ii gt\">\n<div id=\":ox\" class=\"a3s aXjCH \">\n<div dir=\"ltr\">\n<p dir=\"ltr\"><strong><em>MySql is an open-source database management system. It provides tables and fields for storing necessary information. Let&#8217;s see How to Install MYSQL on Linux?<\/em><\/strong><\/p>\n<p dir=\"ltr\">Before we start, let us make sure that the Underlying Ubuntu Server is updated with its latest update. Run the below command on the server.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh6.googleusercontent.com\/KkZubkJP0qckXfEHdI5hIK5vZB-hCw0SEY76ByziR83tBeqFax0i_saCWsWKUaF5wMH7sakf4NJoJInJBSQwCdgt_X7wDWmpnWWlIraRH7mFLB3Szvte_RzWblSYrS3X71UacAqT\" width=\"286\" height=\"22\"><\/p>\n<p dir=\"ltr\">Now, once the Ubuntu server is up and running with the latest updates, now it&#8217;s time to install MySQL on Linux.<\/p>\n<\/div>\n<p dir=\"ltr\"><a href=\"https:\/\/www.liainfraservices.com\/cloud-migration-services\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2737\" src=\"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2021\/02\/To-know-more-about-Cloud-Migration-Services-16-300x37.jpg\" alt=\"\" width=\"535\" height=\"66\" srcset=\"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2021\/02\/To-know-more-about-Cloud-Migration-Services-16-300x37.jpg 300w, https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2021\/02\/To-know-more-about-Cloud-Migration-Services-16.jpg 729w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<div dir=\"ltr\">\n<pre dir=\"ltr\"><strong><span style=\"color: #339966;\">apt install mysql-server<\/span><\/strong><\/pre>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd a6T\" tabindex=\"0\" src=\"https:\/\/lh4.googleusercontent.com\/abNxtg2_lda8UbXTDxOBVdzgAp9rG3xnCVNMcFrldN2gsiWSd_vT47iUoflIFqTz4yYHIG3ylXrqfHsxM6heQbUxZMIcpu38YjTvfjEeqM2xlgai6Trv33haQW2zeIvsdk3k9zdT\" width=\"564\" height=\"326\"><\/p>\n<p dir=\"ltr\">You need to agree to use the space by pressing <span style=\"color: #008000;\">\u201cY\u201d<\/span><\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd a6T\" tabindex=\"0\" src=\"https:\/\/lh6.googleusercontent.com\/dAvBgBHePmblIRD7szJg_EIOTGV8bzCzmzHxQvw7kp6_vRXfUA8VtgBDOZ-KvBnbXiZ1D11WpM8Y_a3iVi3AW8IhW9S_XxX17axS625BPI527kB1ssgFjKFgBHy7BfF_y_o3Bj1N\" width=\"624\" height=\"279\"><\/p>\n<p dir=\"ltr\">You may ignore that by pressing <span style=\"color: #008000;\">\u201cEnter\u201d<\/span> Or you may set the Mysql root user password on this screen. We can do that later anyway.<\/p>\n<p dir=\"ltr\">I think, if you ignore this during installation, the splash screen will come 3 times to input a password.<\/p>\n<p dir=\"ltr\">Now, run the below command to secure your MySQL database.<\/p>\n<blockquote>\n<p dir=\"ltr\" style=\"padding-left: 30px;\"><span style=\"color: #000000;\">mysql_secure_installation<\/span><\/p>\n<\/blockquote>\n<p dir=\"ltr\">This will come up with few questions and that would expect you to Press <span style=\"color: #008000;\">\u201cY\/n\u201d<\/span><\/p>\n<p dir=\"ltr\">It&#8217;s up to each individual, based on your need, you can proceed with the right selection.<\/p>\n<p dir=\"ltr\">Let me put all the questions here So that you know what are they.<\/p>\n<p dir=\"ltr\"><strong><span style=\"color: #ff0000;\">Question 1<\/span><\/strong>: This will ask if you want to Set a Root Password for your MySQL database.<\/p>\n<p dir=\"ltr\">I have selected<span style=\"color: #008000;\"> \u201cn\u201d<\/span> so it skipped.<\/p>\n<\/div>\n<\/div>\n<div id=\":ox\" class=\"a3s aXjCH \">\n<div dir=\"ltr\">\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd a6T\" tabindex=\"0\" src=\"https:\/\/lh4.googleusercontent.com\/04jTn2J_-44EmJ__uwP4hbaurCwVUjwUjtbiNhU_xzQ3qb_AiWgLO7QM_jCN02-CX0lZUecUVVH6PlhYejjA48xAR5kl3o8CWAi74LcTQgkf_oJ-zD2YSFiNJBlzZG39AlcDYvBW\" width=\"489\" height=\"375\"><\/p>\n<p dir=\"ltr\"><strong><span style=\"color: #ff0000;\">Question 2:<\/span><\/strong> This will ask if you want to remove the anonymous user.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh3.googleusercontent.com\/PBXmRJIy-wj3XpulKf5F59XwwVMpP7lpZPzOsY3xYm6dakKJAIPFhQ1AARAyeXVazVaNwFPGPdnZyWjkmuFiaaiygRvxSjJ1d2KhW5ej0W9S0MsQePkoOzdiXJPE3mRu0i8h8f7q\" width=\"521\" height=\"145\"><\/p>\n<p dir=\"ltr\"><strong><span style=\"color: #ff0000;\">Question 3:<\/span><\/strong> Disable remote root login.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh6.googleusercontent.com\/Vivw9pzk2Inons9Qx-rzyrKrX0ruOuDV6ux_oX2Zz-Ue2JWo2kadUy292uNf3CzuQ0cFd2LaO70aZxsOEDkgCOePJK9G8HzOVC_1qG5aPQh1DCO7A9JuryghbnTUNaO1tqFbViL3\" width=\"519\" height=\"99\"><\/p>\n<p dir=\"ltr\">The remaining Questions are below.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd a6T\" tabindex=\"0\" src=\"https:\/\/lh5.googleusercontent.com\/kbGEVjI6SggHGkkn--8yiL2qpGQqjCeDTGM0M8WwHqgw-vxgScmZl879DMb5hMEi7xml91XGx9efuC53antH68TMq3vvHLxizhpoyEmqHsbgqsjtSOt9hRqCYDPo-c1fTak440dk\" width=\"528\" height=\"213\"><\/p>\n<p dir=\"ltr\">Now, your MySQL is installed on Ubuntu. To verify that execute the below command.<\/p>\n<p dir=\"ltr\">Run the command <span style=\"color: #ff0000;\">(1) MySQL<\/span><\/p>\n<p dir=\"ltr\">You will get a blinking line with <span style=\"color: #ff0000;\">(2) mysql&gt;<\/span><\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd a6T\" tabindex=\"0\" src=\"https:\/\/lh4.googleusercontent.com\/7GsQdx9FfGwXNS_R_lygt-uhPcQOOrQlCxEv2Lp10Yu3kTme34fUo0y89L3yM836EtfV-28LTWlCYMJ4gkME99YDJbLmQTFJIur4-4SWb0_sh9vPlL7_5BvCP7-yqQwDKfVPcFrQ\" width=\"590\" height=\"252\"><\/p>\n<p dir=\"ltr\"><strong>Few basic Queries:<\/strong><\/p>\n<p dir=\"ltr\">1. To list all the databases.<\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; show databases;<\/pre>\n<\/blockquote>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh3.googleusercontent.com\/1gmMJZf_yQoDjo1G_TEP5iVnJoUKg7kxNsH6eLw7ke1QHw_O-e3gczIQn_fBpbzeT5nqhPKKIqhORWpX0vO7-kMfJMWq9gUyIqqSFMVpAEqxvCj4zdlPnstyGUhOKVhnO1ESxmqJ\" width=\"183\" height=\"157\"><\/p>\n<p dir=\"ltr\">2. To use any database from above.<\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; use mysql; ( use database_name)<\/pre>\n<\/blockquote>\n<p dir=\"ltr\">3. To see the list of tables<\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; show tables;<\/pre>\n<\/blockquote>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh6.googleusercontent.com\/cfbFauFerrpsTZaN7E0VLsoDwEHVDUDvoP5iOQJs9rt6-Mck6yUhrqJzTGTblvqrIoW81iLE2PBWbl55sEocZKtBdqH-JW0u7LHCnIHhDpmAqH3k_SFB12CsZ1g_1LOuXeoMrmV6\" width=\"208\" height=\"339\"><\/p>\n<p dir=\"ltr\">4. List the fields of any table, I use these two ways. There could be others, please comment and let me know.<\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; describe user;<\/pre>\n<\/blockquote>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh3.googleusercontent.com\/uxEykE9cvAyYC9aGuOX0GJU1pXd5JAgIEp_P2vwCSaL3hGSSXuLx5Vr1KA7U_MxmTyh4cnFkuUjKQX_1sQEvObhhxEAtH2PR7pVM3E6OyqDCz5x5dQ9CdNhQ0Bh64bkjtiA5cbH0\" width=\"624\" height=\"84\"><\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; select * from user limit 1;<\/pre>\n<\/blockquote>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh6.googleusercontent.com\/aAXj5JGPKeS0D4eBB8PWL41gSEESn2Dh1zpWMTEY2reeuS0IU9V05VBX5GcfUpMWQVwr6to9sa30_pPuaHzGIsZssRY2Xx8C5MjL80Z1Z6k5digpo2E_If-8TOjy3Ss1IK5jTsaR\" width=\"263\" height=\"28\"><\/p>\n<p dir=\"ltr\">Delete Table\/Database.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh4.googleusercontent.com\/RbojtTra5p6U_9S9YHB1qHZU-OSGMy8U6Io3CvoE0HIAe_qJ1E7ABifjDOrvWx-1MwqnV4_v6yVsYSvcmD_BYheDlQgMdrzC_OFqtrRsll6Grb6daS0xMDbegPPQ7RyHUL_5a3-K\" width=\"526\" height=\"86\"><\/p>\n<div class=\"adL\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"h7 ie\" tabindex=\"-1\" role=\"listitem\">\n<div class=\"Bk\">\n<div class=\"G3 G2 afm\">\n<div id=\":mv\">\n<div class=\"adn ads\" data-message-id=\"#msg-f:1617200926677119249\" data-legacy-message-id=\"167173acad05b111\">\n<div class=\"gs\">\n<div class=\"gE iv gt\"><span style=\"font-size: 14px;\">Check the user got a password or not.<\/span><\/div>\n<div class=\"\">\n<div id=\":ms\" class=\"ii gt\">\n<div id=\":mt\" class=\"a3s aXjCH \">\n<div dir=\"ltr\">\n<p dir=\"ltr\">You can see, the user <span style=\"color: #008000;\">\u201croot\u201d<\/span> does not have any password.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd a6T\" tabindex=\"0\" src=\"https:\/\/lh4.googleusercontent.com\/NydrqWJehu6RQfi7gzWV4Gj9u3e7GADKGTbbzwOGsQPP508b8f3cgridSvEZUmojQGba6mhidm5-BTTwwuo3Ki-rF5oWZFMdJHRNlxb0PDkkPhoKB_7TUCDdndWrJacAAYLk4Pbv\" width=\"606\" height=\"155\"><\/p>\n<p dir=\"ltr\">Now, To set a password for the root user you can use the below command.<\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');<\/pre>\n<\/blockquote>\n<p dir=\"ltr\" style=\"padding-left: 210px;\"><span style=\"color: #ff0000;\">Or<\/span><\/p>\n<p dir=\"ltr\">ALTER USER <span style=\"color: #008000;\">&#8216;root&#8217;@&#8217;localhost&#8217;<\/span> IDENTIFIED BY<span style=\"color: #008000;\"> &#8216;MyNewPass&#8217;<\/span>; ( I think this is for the latest versions )<\/p>\n<p dir=\"ltr\">To check if the user got any password, you can execute the below command.<\/p>\n<blockquote>\n<pre dir=\"ltr\">mysql&gt; select user,password,host,<wbr>authentication_string from user where user='root';<\/pre>\n<\/blockquote>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh6.googleusercontent.com\/LgwiqIGoOpkYYu-7fzBVKV-_-Ynmkpqs8WIv6JRyxE89Rx4TFml7i0dBMVMapFdbdAO6MTaUTh1eDrobpJq_UYnC27ACHBfLzjbQhbepZgH7u-HQ64NP86Qu7TUcCtUWIy9GZ0Ai\" width=\"450\" height=\"84\"><\/p>\n<p dir=\"ltr\">Now, from next time, when you log in to the SQL server locally.<\/p>\n<p dir=\"ltr\">Most importantly you have to use the below command to log in<\/p>\n<blockquote>\n<pre dir=\"ltr\">MySQL -u root -p;<\/pre>\n<\/blockquote>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"CToWUd\" src=\"https:\/\/lh5.googleusercontent.com\/aa8YTV_8P5GiZR_c8xXMAxaF_P4kkWVDuinD1jUE9VQG7DDdAIEja3XK9a52TdwrOXTLEHpmVaIRgGsOmFwOHnR4kP9i-hG3B0kmqtVXuckJrCxGuH6uy9LexNdwNDzOQqymAuky\" width=\"315\" height=\"32\"><\/p>\n<p dir=\"ltr\">To get more ideas about<a href=\"http:\/\/liainfraservices.com\/blog\/\"> My SQL<\/a>&nbsp; and understand How to install MYSQL on Linux?&nbsp; follow us <a href=\"http:\/\/liainfraservices.com\/\">Lia Infraservices<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\"><\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">min read<\/span><\/span>2,911 MySql is an open-source database management system. It provides tables and fields for storing necessary information. Let&#8217;s see How to Install MYSQL on Linux? Before we start, let us<\/p>\n","protected":false},"author":1,"featured_media":3743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"footnotes":""},"categories":[124],"tags":[314,315,316,317,318,319,320,321,322],"class_list":["post-485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-development","tag-how-to-install-mysql-in-linux-step-by-step","tag-how-to-install-mysql-in-ubuntu","tag-install-mysql-client","tag-install-mysql-client-ubuntu","tag-install-mysql-linux","tag-install-mysql-linux-apt-get","tag-install-mysql-linux-command-line","tag-install-mysql-server-ubuntu","tag-mysql-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to install MYSQL on Linux? - Blog | Liainfraservices<\/title>\n<meta name=\"description\" content=\"This blogs about how to install MYSQL on Linux server and also about few basic Queries in My SQL. To get more ideas about My SQL\u00a0contact Lia Infraservices\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to install MYSQL on Linux? - Blog | Liainfraservices\" \/>\n<meta property=\"og:description\" content=\"This blogs about how to install MYSQL on Linux server and also about few basic Queries in My SQL. To get more ideas about My SQL\u00a0contact Lia Infraservices\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog | Liainfraservices\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-30T12:18:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-27T14:03:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2018\/11\/How-to-install-MYSQL-on-Linux.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Partho\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Partho\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/\"},\"author\":{\"name\":\"Partho\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#\\\/schema\\\/person\\\/b5a729cb152dd3bc7f07550ca9d223e4\"},\"headline\":\"How to install MYSQL on Linux?\",\"datePublished\":\"2018-11-30T12:18:42+00:00\",\"dateModified\":\"2021-10-27T14:03:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/\"},\"wordCount\":415,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/How-to-install-MYSQL-on-Linux.jpg\",\"keywords\":[\"how to install mysql in linux step by step\",\"how to install mysql in ubuntu\",\"install mysql client\",\"install mysql client ubuntu\",\"install mysql linux\",\"install mysql linux apt-get\",\"install mysql linux command line\",\"install mysql server ubuntu\",\"mysql tutorial\"],\"articleSection\":[\"Web Development\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/\",\"url\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/\",\"name\":\"How to install MYSQL on Linux? - Blog | Liainfraservices\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/How-to-install-MYSQL-on-Linux.jpg\",\"datePublished\":\"2018-11-30T12:18:42+00:00\",\"dateModified\":\"2021-10-27T14:03:17+00:00\",\"description\":\"This blogs about how to install MYSQL on Linux server and also about few basic Queries in My SQL. To get more ideas about My SQL\u00a0contact Lia Infraservices\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/How-to-install-MYSQL-on-Linux.jpg\",\"contentUrl\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/How-to-install-MYSQL-on-Linux.jpg\",\"width\":512,\"height\":315,\"caption\":\"How to install MYSQL on Linux\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/how-to-install-mysql-on-linux\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web Development\",\"item\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/category\\\/web-development\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to install MYSQL on Linux?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/\",\"name\":\"Blog | Liainfraservices\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#organization\",\"name\":\"Blog | Liainfraservices\",\"url\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/lia-logo-b-e1635340384244.png\",\"contentUrl\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/lia-logo-b-e1635340384244.png\",\"width\":308,\"height\":96,\"caption\":\"Blog | Liainfraservices\"},\"image\":{\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.liainfraservices.com\\\/blog\\\/#\\\/schema\\\/person\\\/b5a729cb152dd3bc7f07550ca9d223e4\",\"name\":\"Partho\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6c5fc8918cc5dbc844eccbeaaf854eef27d2c79ab17ff0022304f712805d6959?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6c5fc8918cc5dbc844eccbeaaf854eef27d2c79ab17ff0022304f712805d6959?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6c5fc8918cc5dbc844eccbeaaf854eef27d2c79ab17ff0022304f712805d6959?s=96&d=mm&r=g\",\"caption\":\"Partho\"},\"description\":\"Partho Das, founder of Lia Infraservices, has 15+ years of expertise in cloud solutions, DevOps, and infrastructure security. He provides consultation on architecture planning, DevOps setup, Kubernetes, and cloud migrations. Partho holds multiple AWS and Azure certifications, along with CISCO CCNA &amp; CCNP. Connect on LinkedIn\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/partho-dev\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install MYSQL on Linux? - Blog | Liainfraservices","description":"This blogs about how to install MYSQL on Linux server and also about few basic Queries in My SQL. To get more ideas about My SQL\u00a0contact Lia Infraservices","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/","og_locale":"en_US","og_type":"article","og_title":"How to install MYSQL on Linux? - Blog | Liainfraservices","og_description":"This blogs about how to install MYSQL on Linux server and also about few basic Queries in My SQL. To get more ideas about My SQL\u00a0contact Lia Infraservices","og_url":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/","og_site_name":"Blog | Liainfraservices","article_published_time":"2018-11-30T12:18:42+00:00","article_modified_time":"2021-10-27T14:03:17+00:00","og_image":[{"width":512,"height":315,"url":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2018\/11\/How-to-install-MYSQL-on-Linux.jpg","type":"image\/jpeg"}],"author":"Partho","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Partho","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#article","isPartOf":{"@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/"},"author":{"name":"Partho","@id":"https:\/\/www.liainfraservices.com\/blog\/#\/schema\/person\/b5a729cb152dd3bc7f07550ca9d223e4"},"headline":"How to install MYSQL on Linux?","datePublished":"2018-11-30T12:18:42+00:00","dateModified":"2021-10-27T14:03:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/"},"wordCount":415,"commentCount":0,"publisher":{"@id":"https:\/\/www.liainfraservices.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2018\/11\/How-to-install-MYSQL-on-Linux.jpg","keywords":["how to install mysql in linux step by step","how to install mysql in ubuntu","install mysql client","install mysql client ubuntu","install mysql linux","install mysql linux apt-get","install mysql linux command line","install mysql server ubuntu","mysql tutorial"],"articleSection":["Web Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/","url":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/","name":"How to install MYSQL on Linux? - Blog | Liainfraservices","isPartOf":{"@id":"https:\/\/www.liainfraservices.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#primaryimage"},"image":{"@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2018\/11\/How-to-install-MYSQL-on-Linux.jpg","datePublished":"2018-11-30T12:18:42+00:00","dateModified":"2021-10-27T14:03:17+00:00","description":"This blogs about how to install MYSQL on Linux server and also about few basic Queries in My SQL. To get more ideas about My SQL\u00a0contact Lia Infraservices","breadcrumb":{"@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#primaryimage","url":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2018\/11\/How-to-install-MYSQL-on-Linux.jpg","contentUrl":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2018\/11\/How-to-install-MYSQL-on-Linux.jpg","width":512,"height":315,"caption":"How to install MYSQL on Linux"},{"@type":"BreadcrumbList","@id":"https:\/\/www.liainfraservices.com\/blog\/how-to-install-mysql-on-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.liainfraservices.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Web Development","item":"https:\/\/www.liainfraservices.com\/blog\/category\/web-development\/"},{"@type":"ListItem","position":3,"name":"How to install MYSQL on Linux?"}]},{"@type":"WebSite","@id":"https:\/\/www.liainfraservices.com\/blog\/#website","url":"https:\/\/www.liainfraservices.com\/blog\/","name":"Blog | Liainfraservices","description":"","publisher":{"@id":"https:\/\/www.liainfraservices.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.liainfraservices.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.liainfraservices.com\/blog\/#organization","name":"Blog | Liainfraservices","url":"https:\/\/www.liainfraservices.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.liainfraservices.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2021\/10\/lia-logo-b-e1635340384244.png","contentUrl":"https:\/\/www.liainfraservices.com\/blog\/wp-content\/uploads\/2021\/10\/lia-logo-b-e1635340384244.png","width":308,"height":96,"caption":"Blog | Liainfraservices"},"image":{"@id":"https:\/\/www.liainfraservices.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.liainfraservices.com\/blog\/#\/schema\/person\/b5a729cb152dd3bc7f07550ca9d223e4","name":"Partho","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6c5fc8918cc5dbc844eccbeaaf854eef27d2c79ab17ff0022304f712805d6959?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6c5fc8918cc5dbc844eccbeaaf854eef27d2c79ab17ff0022304f712805d6959?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6c5fc8918cc5dbc844eccbeaaf854eef27d2c79ab17ff0022304f712805d6959?s=96&d=mm&r=g","caption":"Partho"},"description":"Partho Das, founder of Lia Infraservices, has 15+ years of expertise in cloud solutions, DevOps, and infrastructure security. He provides consultation on architecture planning, DevOps setup, Kubernetes, and cloud migrations. Partho holds multiple AWS and Azure certifications, along with CISCO CCNA &amp; CCNP. Connect on LinkedIn","sameAs":["https:\/\/www.linkedin.com\/in\/partho-dev\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/posts\/485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/comments?post=485"}],"version-history":[{"count":6,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/posts\/485\/revisions"}],"predecessor-version":[{"id":3356,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/posts\/485\/revisions\/3356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/media\/3743"}],"wp:attachment":[{"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/media?parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/categories?post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.liainfraservices.com\/blog\/wp-json\/wp\/v2\/tags?post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}