{"id":5067,"date":"2021-09-21T08:32:05","date_gmt":"2021-09-21T07:32:05","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=5067"},"modified":"2024-12-10T15:51:53","modified_gmt":"2024-12-10T14:51:53","slug":"discovering-mysql-database-service-episode-8-connect-to-mysql-database-service-using-mysql-shell","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2021\/09\/21\/discovering-mysql-database-service-episode-8-connect-to-mysql-database-service-using-mysql-shell\/","title":{"rendered":"Discovering MySQL Database Service \u2013 Episode 8 \u2013 Connect to MySQL Database Service Using MySQL 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 eight<\/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

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 8 – Connect to MySQL Database Service Using MySQL Shell<\/h1>\n\n\n\n

    In the previous episode<\/a> we’ve seen how to use an OCI Bastion session in order to provide a restricted and time-limited access to administer our MySQL instance.
    One more step 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 fantastic MySQL Shell<\/strong> – an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server.<\/p>\n\n\n\n

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

    MySQL Shell<\/h2>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n

    MySQL Shell<\/a> is an advanced client & code editor for MySQL. In addition to the provided SQL functionality, it provides scripting capabilities for JavaScript and Python.<\/p>\n\n\n\n

    MySQL Shell includes utilities<\/a> for working with MySQL, among others:<\/p>\n\n\n\n