{"id":5139,"date":"2021-10-05T08:25:13","date_gmt":"2021-10-05T07:25:13","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=5139"},"modified":"2021-10-05T08:25:16","modified_gmt":"2021-10-05T07:25:16","slug":"discovering-mysql-database-service-episode-10-connect-to-mysql-database-service-using-oci-cloud-shell","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2021\/10\/05\/discovering-mysql-database-service-episode-10-connect-to-mysql-database-service-using-oci-cloud-shell\/","title":{"rendered":"Discovering MySQL Database Service \u2013 Episode 10 \u2013 Connect to MySQL Database Service Using OCI Cloud Shell"},"content":{"rendered":"\n

MySQL<\/a>, the world’s most popular open source database<\/strong>, is available as a managed cloud service<\/strong> in Oracle Cloud Infrastructure<\/a><\/strong> (OCI<\/a><\/strong>) under the name of MySQL Database Service<\/a><\/strong> (MDS<\/a><\/strong>).<\/p>\n\n\n\n

MySQL Database Service is a fully managed cloud service, 100% Developed, Managed and Supported by the MySQL Team.<\/strong><\/p><\/blockquote><\/figure>\n\n\n\n

This is the tenth<\/span> episode of \u00ab\u00a0Discovering MySQL Database Service<\/a><\/em><\/strong><\/em><\/strong>\u00ab\u00a0, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. <\/p>\n\n\n\n

Please also note that you can run this tutorial and thus try MySQL Database Service & the other Oracle Cloud Infrastructure services for free<\/span><\/strong> by starting your 30-day trial<\/a>.<\/p>\n\n\n\n

\"MySQL<\/figure><\/div>\n\n\n\n
\n

Planning episodes<\/h2>\n\n\n\n
  1. Introduction to the series Discovering MySQL Database Service<\/em><\/strong><\/a> <\/li>
  2. Create a compartment<\/a><\/li>
  3. Create a Virtual Cloud Network<\/a><\/li>
  4. Dump your MySQL data into an Object Storage bucket<\/a><\/li>
  5. Create a MySQL DB system from a MySQL Shell dump<\/a><\/li>
  6. Update the Private Subnet Security List<\/a><\/li>
  7. Use a Bastion SSH port forwarding session<\/a><\/li>
  8. Connect to MySQL Database Service Using MySQL Shell<\/a><\/li>
  9. Connect to MySQL Database Service Using MySQL Workbench<\/a><\/li>
  10. Connect to MySQL Database Service Using OCI Cloud Shell<\/a><\/li>
  11. MySQL Database Service Features Overview<\/li><\/ol>\n<\/div><\/div>\n\n\n\n

    <\/p>\n\n\n\n

    <\/div>\n\n\n\n

    Episode 10 – Connect to MySQL Database Service Using OCI Cloud Shell<\/h1>\n\n\n\n

    In the previous episode<\/a> we’ve seen how to connect to our MySQL Database Service instance with MySQL Workbench using a SSH port forwarding from the OCI Bastion service. <\/p>\n\n\n\n

    And in episode 8<\/strong> – Discovering MySQL Database Service \u2013 Episode 8 \u2013 Connect to MySQL Database Service Using MySQL Shell<\/a> – we\u2019ve seen how to connect to our MySQL Database Service instance with MySQL Shell using here again a SSH port forwarding from the OCI Bastion service.<\/p>\n\n\n\n

    Two more steps to our Discovering MySQL Database Service<\/em><\/strong> journey. <\/p>\n\n\n\n

    In this episode, we’ll learn how to connect to our MySQL Database Service instance using the Oracle Cloud Infrastructure Cloud Shell<\/strong>.
    It provides a pre-authenticated Oracle Cloud Infrastructure CLI and preinstalled developer tools for easily managing Oracle Cloud resources.<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    Cloud Shell<\/h2>\n\n\n\n

    Oracle Cloud Infrastructure Cloud Shell gives you access to an always available Linux shell<\/span> directly in the Oracle Cloud Infrastructure Console.<\/p>\n\n\n\n

    You can use the shell to interact with resources like MySQL Database Service, Oracle Container Engine for Kubernetes cluster, Oracle Autonomous Database, …<\/p>\n\n\n\n

    Cloud Shell provides:<\/p>\n\n\n\n