Skip links

Connecting to MySQL Database Service – SSH and MySQL Shell

With the Oracle Cloud Infrastructure (OCI) MySQL Database Services, in order to connect you have to access MySQL through a compute node.  This means you will have to create a compute node within OCI.  You can do this quickly with Terraform (here).

Once you have an OCI compute node built, you will need to install MySQL Shell.  MySQL Shell is the advanced MySQL Client for Developers and DBAs.  Making interaction with MySQL easier from the command line.

Installing MySQL Shell

Access the OCI compute node (needs public IP address of compute node)

> ssh -I .ssh/mysql_private_key.pem opc@<public IP address>

mysql-shell-ssh.png

Install MySQL Shell via command line

> sudo yum install -y mysql-shell

mysql-shell-install.png

After MySQL Shell is installed, you can access your MySQL Database Service (database) via the command line.

Connecting to MySQL

To start MySQL Shell and connect to the DB System endpoint, the following command is used.  Keep in mind, you are SSHed into the compute node, from the compute node you’ll use the DB System private IP address to connect.

> mysqlsh [email protected]

mysql-shell-connection.png

Provide the password for the user that was established when creating the MySQL Database Service.

After providing the password, you will be connected to the MySQL Database Service.  By default the MySQL Shell will connect you to the JavaScript command line option.  I’ve switched to the SQL command line option by using “\sql”.

mysql-shell-connected.png

At this point, you can now interact with your MySQL database on Oracle Cloud Infrastructure (OCI).

Leave a comment

  1. Hello! Do you know if they make any plugins to help with SEO?

    I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very
    good success. If you know of any please share. Appreciate it!

    You can read similar blog here: Wool product

  2. I was pretty pleased to uncover this website. I need to to thank you for your time just for this fantastic read!! I definitely savored every little bit of it and I have you bookmarked to check out new stuff on your site.

  3. I was excited to uncover this great site. I need to to thank you for ones time due to this wonderful read!! I definitely liked every bit of it and I have you bookmarked to look at new things on your web site.

  4. I’d like to thank you for the efforts you’ve put in writing this blog. I am hoping to check out the same high-grade blog posts from you later on as well. In fact, your creative writing abilities has motivated me to get my very own site now 😉

  5. Spot i’ll carry on with this write-up, I truly believe this website wants additional consideration. I’ll more likely be once more to see additional, thank you that info.

  6. buy herpafend Herpafend is a
    natural supplement designed to control herpes symptoms. It
    strengthens the body’s defenses and reduces the frequency of outbreaks.
    Formulated with ingredients like elderberry, echinacea, and L-lysine, Herpafend aids in maintaining health.

    Manufactured in the USA in an FDA-registered facility, Herpafend maintains premium standards.
    It is genetically unmodified and gluten-free. Customers say less
    frequent and less severe outbreaks.

    Try Herpafend today and notice the change in your herpes
    management.

  7. Everyone loves it when individuals get together and share thoughts. Great blog, keep it up!

  8. For example, an option trader can make a bet that in 6 months time a stock will be trading either above a certain price or below a lower price – an each way bet if you will!

  9. The painters positioned the window part on an open easel positioned earlier than a window, or put the glass flat onto a transparent desk, so the artist might see the impact of the sunshine coming by means of the glass.

  10. If the S&P 500 rises by 1, the inverse ETF is designed to fall by 1; and if the S&P falls by 1, the inverse ETF should rise by 1.

  11. Vancouver office contains more or less 270 attorneys, they offer:- mergers and acquisitions, corporate normal account, charge, security, each the money associated and managing an account administration, prosecution, advantages.

  12. He scored the only goal of the sport from the penalty spot on 7 April, as Wolfsburg defeated SC Freiburg to achieve the semi-finals of the DFB-Pokal, also making a goalline clearance later on.

  13. After the Wall Street Crash of 1929, the United States Congress handed a sequence of acts regulating the securities markets generally and mutual funds specifically.

  14. It’s a crucial step in the CE certification process, as it lays the groundwork for demonstrating product conformity to relevant standards.

  15. With a girly fashion that’s all about pinks and reds, Chin Chin is your go to if you want to dress up a number of candy with just a little little bit of spice.

  16. So a informal phrase like, “the computer between your ears”, when it comes dressed up as a significantly intended assertion, can’t declare membership among the resource of merely “colourful metaphors”.

  17. Remarks: Karpov marched out to a victory in Sport 1. Korchnoi resigned on move 44, down the exchange and a pawn and with an inferior position.

  18. As you may see, the later variations of Windows do not require you to pick out disk defragmenter and even click on “Defragment Disk” so as to get the process to run.

  19. 10 year treasury bonds have a term of more than one year, but not more than 10 years.

  20. Furthermore, everybody can freely select their way of life, opinions and religion, while respecting the rights of others.

  21. Matching funds to qualify for QZAB funding had been offered by way of private donations.

  22. Anderson and Kurzer conclude that this led to a critical exposure to the 2008 global financial crisis when the housing markets collapsed under the crumbling legs of complex mortgage-backed financial products.

  23. The examine and analysis costs, that are taken under consideration as the tax paid by such persons, shall not be accepted as allowable bills for tax purposes.

  24. To obtain this Authority, instructors must demonstrate honesty,
    knowledge, and the ability to teach safe driving to young learners.

  25. But don’t let this scare you from getting started, it’s absolutely normal to feel nervous when learning how to
    drive.

  26. Typically the course offered by varied finance institute concentrate on various elements of finance coaching like financial management, financial planning, threat administration, controlling, funds management and so on.

  27. The DIA is more than just a membership — it’s a community of ADIs and driving instruction experts, all
    working to improve the industry together.

  28. As a multi-car school I needed a system where I could be more efficient for our instructors.

  29. Safe Transport Victoria can investigate matters related to a driving
    instructor’s conduct based on public complaints.

  30. My clients love it, they can instantly see their progress plus
    loads of other features for the pupil.

  31. It is no secret that New Zealand has some lovely waterfronts, however do you know that you would be able to visit the clearest lake in the world there?

  32. The public colleges in Chattanooga, in addition to Hamilton County, have fallen underneath the purview of the Hamilton County Faculties because the 1997 merger of the urban Chattanooga Metropolis Colleges system and the principally rural Hamilton County Colleges system.

  33. Ambassador took a satisfying leap to 23,769; requirements attracted over a ­quarter-million sales.

  34. The suburbs began sprawling outward, and their residents started commuting longer hours to their jobs in town.

  35. These Sales reps know everything they need about the products, the sector, and corresponding subjects like past and future history, competitors, and cross-functional applications.

  36. Automated Confirmations Strong on-line event registration software program may be a beautiful time saver because it ensures automated confirmations and receipts to registrants in addition to creates custom reviews for the aim of monitoring participant info and status of funds without any paperwork.

  37. Your success is our success—our students consistently pass with
    flying colours!
    Brisbane’s test routes often include tricky intersections—we’ll help
    you master them! Choosing the right driving school can make all
    the difference—our students consistently succeed.

  38. Unsure about which driving school to choose? Our excellent reviews speak for themselves!

    Want to avoid last-minute panic before your driving test?
    Start lessons early with us! Ready to take your driving skills to
    the next level? We’re here to help.

  39. Learning to drive in Brisbane is an exciting journey, and
    having a skilled instructor makes all the difference!

    Whether you’re a nervous beginner or looking to refine your skills, our driving
    instructors are here to help. Master lane changes and motorway driving with our expert lessons.

  40. Have questions about the test? Our experienced instructors have all the answers!

    Brisbane’s roads present unique challenges—our lessons prepare you for all of them.
    Need a car for your driving test? We provide test-day support for our students.

  41. Learning to drive with us means gaining real-world skills you’ll use for life.

    Brisbane’s road rules can be tricky—our lessons cover everything you need to know.
    Learning to drive in Brisbane is an exciting journey, and having a skilled
    instructor makes all the difference!

  42. Need help preparing for your driving test? Our mock tests will get you ready!

    Learning to drive is a major milestone—our Brisbane instructors make it a smooth experience.
    Your success is our success—our students consistently pass with
    flying colours!

  43. Nervous about merging onto the motorway? We’ll teach you the smoothest way to
    do it.
    Don’t just learn to drive—learn to drive with confidence and skill.
    Getting your P-plates is easier with the right training—our students pass with confidence.

  44. Mastering Brisbane’s busy intersections is easier
    with the right driving instructor by your side.

    Your safety is our top priority—learn from the best! No two
    learners are the same—we personalise our approach to
    suit you.

  45. Don’t just aim to pass—aim to drive safely for life with our expert training.

    Brisbane’s roads can be complex, but our
    structured lessons make navigating them simple. Our goal is to help you pass your test AND become a safe, confident driver
    for life.

  46. Don’t risk bad habits—learn the correct techniques from the
    very beginning.
    Choosing a reputable driving school is crucial—our instructors are highly experienced and qualified.
    Brisbane’s roads present unique challenges—our lessons prepare you for all of them.

  47. A structured approach to learning ensures long-term success—book with us today!

    Safe driving habits start from day one—book your first lesson with us today!

    Don’t leave it too late—book your lessons now to get
    test-ready in time.

  48. In the morning, she announces Ben must drive her to the Edinburgh International Book Festival, where she has been invited
    to read poetry.

  49. Making sure that all of these fluids are topped up and at the recommended levels will not solely be sure that your automobile is secure to drive, but it surely will also ensure the automobile is performing optimally and keep it on the road for many years.

  50. You is likely to be taking a look at the totally different life insurance and income safety insurance coverage policy selections present out there in addition to asking yourself which can meet your requirements.

  51. Make sure that no tree branches or shrubs are touching your private home, significantly close to roof traces, as a result of rats can climb foliage and then find ways into the structure.

  52. After I initially left a comment I seem to have clicked on the -Notify me when new comments are added- checkbox and from now on every time a comment is added I receive four emails with the exact same comment. Perhaps there is an easy method you can remove me from that service? Thanks a lot.

  53. Their gentle, compact design are perfect for stowing away when touring by plane or automotive or wherever house is likely to be a concern.