How to access MDS by using MySQL Enterprise Workbench

 Using MySQL Enterprise Workbench to write SQL statements against MDS

Assume that you wanted to access/write sql statements on MDS from MySQL Workbench Running on On-premises (Windows OS)

How? Below are steps you needed to follow.

To connect with MySQL Workbench ,you require below details handy :-

Prerequisite:-

1.       Installed MySQL Enterprise Workbench(preferred latest version) On-Premises. 2.       Putty - https://www.putty.org/ 3.       Up & Running MDS on ORACLE CLOUD . 4.       Up and Running Compute instance.   Note:- To download MySQL Enterprise Edition trail version by below links:- https://edelivery.oracle.com/

 

How to Install MySQL Enterprise Edition on Windows?  Below links will be helpful https://dev.mysql.com/doc/workbench/en/wb-windows.html

Open MySQL Enterprise Workbench

SSH Hostname:-  <Public IP Address of Compute Instance> SSH Username:-  <opc->default user name assigned when you create compute Instance> SSH Key File:-  You needed to generate key file from .PPK file by using PUTTY.   MySQL Host Name :-  MDS IP address MySQL Server Port :-  3306 MySQL User Name :-  <give user name of MySQL database> MySQL Password :-  <give the password>*********

How to generate Key file?

What you need to do is:-

1.       Open puttygen and click on Conversions àImport Keyà search for existing .ppk filesàupload it.-->Click on conversions àExport OpenSSH  Keyà Save as opensshkey .

2.       Then pass SSH Key File:-  as opensshkey.

 

1.       Test Connection with above parameters.

Open MySQL Workbench and click on +

Login to MySQL Work bench and execute commands…

Conclusion

MySQL Database Service is a fully managed database service that enables organizations to deploy cloud-native applications using the world's most popular open source database. It is 100% developed, managed and supported by the MySQL Team.

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.