{"id":2519,"date":"2022-03-02T13:43:21","date_gmt":"2022-03-02T13:43:21","guid":{"rendered":"https:\/\/ionoslabs.com\/?p=2519"},"modified":"2022-07-11T14:26:54","modified_gmt":"2022-07-11T14:26:54","slug":"install-mysql-on-ubuntu-instance","status":"publish","type":"post","link":"https:\/\/ionoslabs.com\/index.php\/install-mysql-on-ubuntu-instance\/","title":{"rendered":"Install Mysql on Ubuntu Instance"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1289.6px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_2_3 2_3 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-border-color:#000000;--awb-border-style:dashed;--awb-width-large:66.666666666667%;--awb-margin-top-large:0px;--awb-spacing-right-large:2.88%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2.88%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-content-boxes content-boxes columns row fusion-columns-1 fusion-columns-total-1 fusion-content-boxes-1 content-boxes-icon-with-title content-left\" style=\"--awb-hover-accent-color:#ff8d61;--awb-circle-hover-accent-color:#ff8d61;--awb-item-margin-bottom:40px;\" data-animationOffset=\"top-into-view\"><div style=\"--awb-backgroundcolor:rgba(255,255,255,0);\" class=\"fusion-column content-box-column content-box-column content-box-column-1 col-lg-12 col-md-12 col-sm-12 fusion-content-box-hover content-box-column-last content-box-column-last-in-row\"><div class=\"col content-box-wrapper content-wrapper link-area-box icon-hover-animation-fade\" data-animationOffset=\"top-into-view\"><div class=\"heading icon-left\"><h2 class=\"content-box-heading fusion-responsive-typography-calculated\" style=\"--h2_typography-font-size:23px;--fontSize:23;line-height:1.29;\">Install Mysql using cloud-init on new Ubuntu instance<\/h2><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"content-container\">\n<p>These cloud-init files will download and install Mysql Server onto an Ubuntu 20.04 LTS instance in the IONOS cloud.\u00a0 The Deploy 1 file should be used if you are getting an IP address via DHCP.\u00a0 The Deploy 2 file should be used if creating a private network and statically assigning an IP address.<\/p>\n<p>Please remember to write down you credentials at the install completion, and delete the log files in \/var\/log\/cloud-init-output.log<\/p>\n<p><strong>What is going on here:<\/strong><\/p>\n<p>In the Deploy 1 section, we are performing the following:<\/p>\n<ul>\n<li>Performing apt update<\/li>\n<li>Performing apt upgrade<\/li>\n<li>Cloning the secure Mysql install bash script from https:\/\/github.com\/ionoslabs\/mysql-cloud-init<\/li>\n<li>Setting the script as executable<\/li>\n<li>Running the script<\/li>\n<\/ul>\n<p>View the secure install bash script on github <a href=\"https:\/\/github.com\/ionoslabs\/mysql-cloud-init\/mysql-install.sh\">https:\/\/github.com\/ionoslabs\/mysql-cloud-init\/mysql-install.sh<\/a> for more information on this script<\/p>\n<p>In the Deploy 2 section, we are doing the same thing as in Deploy 1 except we are also setting a static IP address by creating a custom networking yaml and passing it via cloud-init functions.\u00a0 Set the static internal IP address you want at line 21 and gateway at line 22<\/p>\n<ul>\n<li>Write out file \/etc\/cloud\/cloud.cfg.d\/99-custom-networking.cfg<\/li>\n<li>Set correct permissions on file for netplan generation<\/li>\n<li>Write out file \/etc\/netplan\/config.yaml and set static IP address<\/li>\n<li>Set correct permissions on file for netplan generation<\/li>\n<li>Lines 28 through 31 remove automatically generated netplan yaml&#8217;s and replace with custom configuration<\/li>\n<\/ul>\n<\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><div class=\"fusion-content-boxes content-boxes columns row fusion-columns-1 fusion-columns-total-1 fusion-content-boxes-2 content-boxes-icon-with-title content-left\" style=\"--awb-hover-accent-color:#ff8d61;--awb-circle-hover-accent-color:#ff8d61;--awb-item-margin-bottom:40px;\" data-animationOffset=\"top-into-view\"><div style=\"--awb-backgroundcolor:rgba(255,255,255,0);\" class=\"fusion-column content-box-column content-box-column content-box-column-1 col-lg-12 col-md-12 col-sm-12 fusion-content-box-hover content-box-column-last content-box-column-last-in-row\"><div class=\"col content-box-wrapper content-wrapper link-area-box icon-hover-animation-fade\" data-animationOffset=\"top-into-view\"><div class=\"heading icon-left\"><h2 class=\"content-box-heading fusion-responsive-typography-calculated\" style=\"--h2_typography-font-size:23px;--fontSize:23;line-height:1.29;\">Install Step by Step Deploy 1<\/h2><\/div><div class=\"fusion-clearfix\"><\/div><div class=\"content-container\">\n<p>Steps for installation:<\/p>\n<ol>\n<li>Login to the IONOS Data Center Designer at <a href=\"https:\/\/dcd.ionos.com\">https:\/\/dcd.ionos.com<\/a><\/li>\n<li>Create the server instance and copy and paste cloud-init yaml from the right\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a new data center from the Data Center designer menu in the upper left and select the region from the drop down below the description area<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Add a server item by clicking on server from the left palette and dragging to the DCD grid area<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Attach your server to the internet by clicking on the plus \u201c+\u201d and dragging the line to the internet access icon, this will automatically create a \u201cLAN 1\u201d network<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on the server icon and to the right and enter a name ie Mysql-1<\/span>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Choose the type of CPU, and desired number of Cores and RAM<\/span><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on the Storage item<\/span>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Select the desired storage, HDD or SSD<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Provide a name for the storage ie\u00a0 mysql-storage<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Enter desired availability zone or leave on auto<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Enter desired storage size in GB<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Click on image and select IONOS Images and then select Ubuntu 20.04-LTS-server-cloud-init.qcow2<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">For password, enter the desired root password (optionally you can use SSH keys) Note:\u00a0 This field can only take alphanumeric, no special characters like *!@# etc&#8230;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Make sure \u201cBoot from device\u201d is checked and click \u201cCreate HDD Storage\u201d<\/span><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">If you have selected the correct image you should see a section appear called \u201cCloud-Init user data\u201d click in this field to enter the cloud-init script<\/span><\/li>\n<li>Copy the cloud-init yaml from under the deploy section of this page and paste into the &#8220;<span style=\"font-weight: 400;\">Cloud-Init user data&#8221; and click Ok<\/span><\/li>\n<li>Click on &#8220;Provision Changes&#8221; and this will start the provisioning process.\u00a0 Once the &#8220;In Progress&#8221; message is gone the server has been created and you can access it by right clicking on the instance in DCD and select console to watch the Mysql install progress.<\/li>\n<li>The install takes approx 10 minutes to complete<\/li>\n<li>The entire install is completed when you see the below ouput on the screen<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"lazyload alignnone wp-image-2524 size-large\" src=\"https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-1024x90.png\" data-orig-src=\"https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-1024x90.png\" alt=\"\" width=\"1024\" height=\"90\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%2790%27%20viewBox%3D%270%200%201024%2090%27%3E%3Crect%20width%3D%271024%27%20height%3D%2790%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-200x17.png 200w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-300x26.png 300w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-400x35.png 400w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-600x52.png 600w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-768x67.png 768w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-800x70.png 800w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete-1024x90.png 1024w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-complete.png 1143w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>11.\u00a0 Write down the randomly generated Mysql root password, see example below:<\/p>\n<p><img decoding=\"async\" class=\"lazyload alignnone size-large wp-image-2527\" src=\"https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-1024x94.png\" data-orig-src=\"https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-1024x94.png\" alt=\"\" width=\"1024\" height=\"94\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%2794%27%20viewBox%3D%270%200%201024%2094%27%3E%3Crect%20width%3D%271024%27%20height%3D%2794%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-200x18.png 200w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-300x27.png 300w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-400x37.png 400w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-600x55.png 600w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-768x70.png 768w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-800x73.png 800w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password-1024x94.png 1024w, https:\/\/ionoslabs.com\/wp-content\/uploads\/2022\/03\/mysql-cloud-init-root-password.png 1171w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>12.\u00a0 You can also access the generated Mysql root password in \/var\/log\/cloud-init-output.log\u00a0 NOTE:\u00a0 Once you have recorded this password you should delete this log file with rm -f \/var\/log\/cloud-init-output.log<\/p>\n<\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_3 1_3 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:33.333333333333%;--awb-margin-top-large:0px;--awb-spacing-right-large:5.76%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:5.76%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-1 fusion-title-text fusion-title-size-one\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.2;\">Download<\/h1><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-1 > .CodeMirror, .fusion-syntax-highlighter-1 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-1 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-1 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-1 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#eaeaea;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_1\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><label for=\"fusion_syntax_highlighter_1\" class=\"screen-reader-text\">Syntax Highlighter<\/label><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_1\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">git clone https:\/\/github.com\/ionoslabs\/mysql-cloud-init<\/textarea><\/div><div class=\"fusion-title title fusion-title-2 fusion-title-text fusion-title-size-one\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.2;\">Deploy 1<\/h1><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-2 > .CodeMirror, .fusion-syntax-highlighter-2 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-2 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-2 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-2 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#eaeaea;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_2\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><label for=\"fusion_syntax_highlighter_2\" class=\"screen-reader-text\">Syntax Highlighter<\/label><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_2\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">#cloud-config\napt_update: true\napt_upgrade: true\n\nruncmd:\n - git clone git:\/\/github.com\/ionoslabs\/mysql-cloud-init \/tmp\/mysql-cloud-init\n - chmod +x \/tmp\/mysql-cloud-init\/mysql-install.sh\n - \/tmp\/mysql-cloud-init\/mysql-install.sh<\/textarea><\/div><div class=\"fusion-title title fusion-title-3 fusion-title-text fusion-title-size-one\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.2;\">Deploy 2<\/h1><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-3 > .CodeMirror, .fusion-syntax-highlighter-3 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-3 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-3 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-3 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#eaeaea;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_3\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><label for=\"fusion_syntax_highlighter_3\" class=\"screen-reader-text\">Syntax Highlighter<\/label><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_3\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">#cloud-config\napt_update: true\napt_upgrade: true\n\n#  \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n# use this section if creating a private network behind a NAT gateway set a static internal address for the instance\n\nwrite_files:\n- path: \/etc\/cloud\/cloud.cfg.d\/99-custom-networking.cfg\n  permissions: '0644'\n  content: |\n    network: {config: disabled}\n- path: \/etc\/netplan\/config.yaml\n  permissions: '0644'\n  content: |\n    network:\n        version: 2\n        ethernets:\n            ens6:\n                dhcp4: false\n                addresses: [192.168.10.20\/24]\n                gateway4: 192.168.10.1\n                nameservers:\n                  addresses: [1.1.1.1]\n\n\nruncmd:\n - rm \/etc\/netplan\/50-cloud-init.yaml\n - rm \/etc\/netplan\/01-netcfg.yaml\n - netplan generate\n - netplan apply\n#  \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n#  end the internal IP section, below section clones secure install script and does secure install of mysql\n\n - git clone git:\/\/github.com\/ionoslabs\/mysql-cloud-init \/tmp\/mysql-cloud-init\n - chmod +x \/tmp\/mysql-cloud-init\/mysql-install.sh\n - \/tmp\/mysql-cloud-init\/mysql-install.sh<\/textarea><\/div><div class=\"fusion-title title fusion-title-4 fusion-title-text fusion-title-size-one\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.2;\">Cleanup<\/h1><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep- sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-4 > .CodeMirror, .fusion-syntax-highlighter-4 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-4 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-4 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-4 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#eaeaea;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_4\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><label for=\"fusion_syntax_highlighter_4\" class=\"screen-reader-text\">Syntax Highlighter<\/label><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_4\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">Delete new instance via DCD<\/textarea><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":2520,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[455,382,391,691],"tags":[],"class_list":["post-2519","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ci-cd","category-how-to","category-resources","category-wordpress"],"_links":{"self":[{"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/posts\/2519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/comments?post=2519"}],"version-history":[{"count":12,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/posts\/2519\/revisions"}],"predecessor-version":[{"id":2534,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/posts\/2519\/revisions\/2534"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/media\/2520"}],"wp:attachment":[{"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/media?parent=2519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/categories?post=2519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ionoslabs.com\/index.php\/wp-json\/wp\/v2\/tags?post=2519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}