{"id":3313,"date":"2017-09-21T13:07:42","date_gmt":"2017-09-21T17:07:42","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=3313"},"modified":"2017-09-21T13:07:42","modified_gmt":"2017-09-21T17:07:42","slug":"how-to-install-mysql-u17","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/","title":{"rendered":"How to Install Mysql on Ubuntu 17"},"content":{"rendered":"<h1>How to Install MySQL on Ubuntu 17<\/h1>\n<div class=\"row\">\n<div class=\"col-lg-8\">\n<p><a rel=\"nofollow\" href=\"https:\/\/www.mysql.com\">MySQL<\/a> is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux platforms. MySQL is often used for web-based applications, online publishing, and some web development platforms.<\/p>\n<p>Ubuntu is an open source operating system based on Linux and is a popular operating system choice for personal computers and mobile devices. Ubuntu is also a popular choice for running physical or virtual servers and is currently one of the most popular choices for running cloud hosting environments.<\/p>\n<\/div>\n<div class=\"col-lg-4\"><img decoding=\"async\" align=\"right\" alt=\"MySQL Logo\" src=\"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png\"\/><\/div>\n<\/div>\n<h2>Getting Started<\/h2>\n<p>In order to follow this guide you will need to have the following in place:<br \/>\n\u2022 One node (<a href=\"https:\/\/www.globo.tech\/cloud-server-pricing\" target=\"_blank\">Cloud Server<\/a> or <a href=\"https:\/\/www.globo.tech\/dedicated-server-hosting\" target=\"_blank\">Dedicated Server<\/a>) that has Ubuntu 14.04 LTS installed.<br \/>\n\u2022 SSH Root Access to your server<br \/>\nBefore you can begin installing MySQL on Ubuntu 17.04, you need to have one node, a cloud server or a dedicated server, with Ubuntu 17.04 currently installed.<\/p>\n<p>Additionally, Secure Shell (SSH) root access to your server running Ubuntu 17.04 is recommended. SSH, if you&#8217;re unaware, is a network protocol used when network services are being executed over an unsecured network; SSH allows for secure execution.<\/p>\n<h2>Tutorial<\/h2>\n<p><strong>Installing MySQL<\/strong><\/p>\n<div class=\"row\">\n<div class=\"col-lg-6\">\n<p>Now that your node is established, Ubuntu is installed, and you have SSH root access to your server, you want to verify that your server is up to date and current repositories are installed:<br \/>\n<code>apt-get update && apt-get upgrade -y<\/code><\/p>\n<p>Once you have confirmed the server is currently running the most recent version, you can begin the process to install MySQL. While the primary installation package is necessary, other packages may be optional and should be installed if necessary:<\/p>\n<\/div>\n<div class=\"col-lg-6\">\n<div class=\"videoWrapper\"><iframe src=\"https:\/\/www.youtube.com\/embed\/M4iGucCztg0\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<\/div>\n<\/div>\n<p><code>apt-get install mysql-server mysql-client -y<\/code><\/p>\n<p>While you are installing MySQL packages, you will be prompted to select a new root password. That password will then be used to sign in to your MySQL as a super user. It&#8217;s recommended that you select a strong password, write it down if necessary, and keep it secured.<\/p>\n<p>After the installation of MySQL is complete, you may need to secure your new MySQL. There is a script you may utilize from your command line to secure MySQL:<br \/>\n<code>mysql_secure_installation<\/code><\/p>\n<p>During this process, the script will prompt you for answers to several questions. You will not need to change your root password, but you may want to remove anonymous users and disable remote login, depending on your needs. You may follow the answers indicated below for an easy setup:<br \/>\n<code class=\"gris\">Enter password for user root: ENTER ROOT PASSWORD<br \/>\nPress y|Y for Yes, any other key for No: n<br \/>\nChange the password for root ? n<br \/>\nRemove anonymous users? y<br \/>\nDisallow root login remotely? y<br \/>\nRemove test database and access to it? y<br \/>\nReload privilege tables now? y<\/code><\/p>\n<p>Finally, you&#8217;ve completed the setup of your MySQL on Ubuntu 17.04. You are now able to log in using the root account and the password you setup earlier, entering them into the command line. Use the following command to log in:<br \/>\n<code>mysql -u root -p<\/code><\/p>\n<p>After entering the root username and password you created, you will be signed into the MySQL command line client.<\/p>\n<p>Congratulations! Enjoy your new MySQL setup on your server running Ubuntu 17.04.<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>You&#8217;ve successfully completed the steps necessary to install MySQL on either a cloud or dedicated server that&#8217;s running Ubuntu 17.04. Your MySQL is ready to be placed into production. If you found this setup guide helpful, please share it with others that are looking to setup their own MySQL.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>How to Install MySQL on Ubuntu 17 MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux platforms. MySQL is often used for web-based applications, online publishing, and some web development platforms. Ubuntu is an open source operating system based on Linux and is a popular operating system choice<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[],"class_list":["post-3313","post","type-post","status-publish","format-standard","hentry","category-applications","operating_system-ubuntu-17-04"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install Mysql on Ubuntu 17 - Globo.Tech<\/title>\n<meta name=\"description\" content=\"How to Install MySQL on Ubuntu 17 ? MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux ...\" \/>\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.globo.tech\/learning-center\/how-to-install-mysql-u17\/\" \/>\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 Ubuntu 17 - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"How to Install MySQL on Ubuntu 17 ? MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-21T17:07:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/\",\"name\":\"How to Install Mysql on Ubuntu 17 - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png\",\"datePublished\":\"2017-09-21T17:07:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"How to Install MySQL on Ubuntu 17 ? MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux ...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#primaryimage\",\"url\":\"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png\",\"contentUrl\":\"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.globo.tech\/learning-center\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install Mysql on Ubuntu 17\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\/\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install Mysql on Ubuntu 17 - Globo.Tech","description":"How to Install MySQL on Ubuntu 17 ? MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux ...","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.globo.tech\/learning-center\/how-to-install-mysql-u17\/","og_locale":"en_US","og_type":"article","og_title":"How to Install Mysql on Ubuntu 17 - Globo.Tech","og_description":"How to Install MySQL on Ubuntu 17 ? MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux ...","og_url":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/","og_site_name":"Globo.Tech","article_published_time":"2017-09-21T17:07:42+00:00","og_image":[{"url":"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png","type":"","width":"","height":""}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/","url":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/","name":"How to Install Mysql on Ubuntu 17 - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#primaryimage"},"image":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png","datePublished":"2017-09-21T17:07:42+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"How to Install MySQL on Ubuntu 17 ? MySQL is a database management system that runs on multiple platforms, including Windows, Unix-based, and Linux ...","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#primaryimage","url":"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png","contentUrl":"https:\/\/www.mysql.com\/common\/logos\/logo-mysql-170x115.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-mysql-u17\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to Install Mysql on Ubuntu 17"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/3313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=3313"}],"version-history":[{"count":13,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/3313\/revisions"}],"predecessor-version":[{"id":3529,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/3313\/revisions\/3529"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=3313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=3313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=3313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}