In this tutorial we will learn about connecting to Telgoo5 replicated DB using MySQL Workbench.
First, let's go over what a replicated database is. A replicated database is a copy of an existing database, which is kept in sync with the original database by replicating any changes made to the original database to the replicated database
-
Open a web browser on your computer and go to the MySQL Workbench download page.
-
Scroll down to the "MySQL Workbench Community (GPL) Downloads" section.
-
Select the appropriate download link for your operating system (Windows, macOS, or Linux).
-
Once the download is complete, locate the downloaded file and open it.
-
Follow the installation wizard instructions to install MySQL Workbench on your computer.
-
During the installation process, you will be prompted to select the components to install. Make sure that the "MySQL Workbench" component is selected.
-
To connect MySQL Workbench to your MySQL server, click the "New Connection" button in the home screen and enter the required information such as the server hostname, port number, username, and password.
-
Once you have entered the connection details, click the "Test Connection" button to verify that the connection is successful.
And that's it! With this access to the replicated database, you'll be able to gain more visibility into your data and make informed decisions based on the insights you discover.
Prerequisites:
- You will need to request replicated DB credentials from Telgoo5 from your project or account manager. You will need username, password, hostname, port, database name in order to connect to replicated DB and these will be provided by Telgoo5 upon request.
- You will also need to make sure that you provide your static public IP to your Telgoo5 contact so that we can ensure that your IP is whitelisted to access replicated DB. If you try to make the connection to the replicated DB without having your IP whitelisted, the connection would fail.