Knowledgebase

How to Connect to RCS Managed Databases for MySQL with Popular Client Apps Print

  • 0

Introduction

RCS Managed Databases for MySQL provide a secure, highly available, and easily scalable solution for hosting your data. However, these databases require client applications that support secure socket layer (SSL) connections. To ensure your data remains secure, this article provides a comprehensive guide to connecting to a RCS Managed Database using popular client applications, such as MySQL client, MySQL Workbench, PHPMyAdmin, DBeaver, HeidiSQL, Beekeeper Studio, and many others. With these steps, you can use your client application to access and manage your RCS Managed Database for MySQL securely.

The following values refer to example connection details used in this article:

  • Host: example.RCSdb.com,

  • Username: RCSadmin

  • Port: 18140

Please replace the values with your actual connection details from the customer portal.

Prerequisites

To complete tasks in this article, you may need to:

Then, follow the steps below for your client to connect to the database.

MySQL Client

MySQL Client is the most used command line tool as it's installed with the local MySQL servers. To get started, copy the connection string from the RCS customer portal, which looks like this:

    $ mysql --host="example.RCSdb.com" --port=18140 --user="RCSadmin" --password="your-strong-password"

After you connect, verify your SSL connection with the status command. You'll see the connection cipher in the SSL entry if successful.

    mysql> status;

    --------------

    mysql  Ver 8.0.31-0ubuntu2 for Linux on x86_64 ((Ubuntu))



    Connection id:      102

    Current database:

    Current user:       RCSadmin@192.0.2.123

    SSL:            Cipher in use is TLS_AES_256_GCM_SHA384



    ...

PHPMyAdmin

PHPMyAdmin is a popular web-based graphical database management tool for MySQL and MariaDB databases. Using the tool, you can connect, create, export, and manage your database with ease. You can install PHPMyAdmin on a cloud server, or locally on your computer through packages such as wamp server and xammp server.

To connect to a RCS Managed Database for MySQL using PHPMyAdmin. You need to edit the application's main configuration file and add your RCS database details as described below.

  1. Depending on your PHPMyAdmin installation type, navigate to the /etc/phpmyadmin/ directory.

     $ cd /etc/phpmyadmin/
    
  2. Verify that the config.inc.php file exists`.

     $ ls *.php
    

    If the file does not exist or your server runs a control panel, enter the following command to locate the phpmyadmin directory.

     $ sudo locate phpmyadmin
    

    Switch to the directory, and verify that the config.inc.php file is available. For example:

     $ cd /usr/local/phpmyadmin/
    

    On Windows, you can find the PHPMyAdmin folder within your wamp or xampp web server directory.

  3. Edit the config.inc.php file.

     $ sudo nano config.inc.php
    
  4. Add the following RCS Database configurations at the end of the file.

     $i++;
    
     $cfg['Servers'][$i]['host'] = 'example.RCSdb.com:18140'; //RCS host address and port
    
     $cfg['Servers'][$i]['user'] = 'RCSadmin';   //username
    
     $cfg['Servers'][$i]['password'] = 'ultra-strong-password';  //database password
    
     $cfg['Servers'][$i]['auth_type'] = 'config';  
    
     $cfg['Servers'][$i]['ssl']=true;  
    

    Save and close the file.

  5. In a new web browser window, access the PHPMyAdmin interface.

     https://example.com/phpmyadmin
    
  6. Log in to PHPMyadmin using your database administrator username and password.

  7. On the left navigation menu, click the Current server: drop-down option, and select your RCS database from the list.

    Connect RCS Database in PHPMyAdmin

  8. When connected, your RCS databases display in the Databases section.

    Your RCS Managed Database for MySQL is now connected to PHPMyAdmin, and you can create new user accounts, create new tables, and manage your database within the application interface.

MySQL Workbench

MySQL Workbench is a free graphical database development, administration, and design tool available on Windows, Linux, and macOS. It's used by database developers, architects, and administrators to visually design, generate data, and execute SQL queries on MySQL and MariaDB databases.

To connect your RCS Managed Database for MySQL using MySQL Workbench, download the latest version from the official website, and install it on your computer.

  1. Open MySQL Workbench from your applications menu.

  2. Click Database on the MySQL Workbench top menu bar, and select Connect to Database.

  3. In the open Connect to Database window, keep the Connection Method: set to Standard (TCP/IP).

  4. Enter your RCS database host address in the Hostname: field and connection port in the Port: field.

  5. Enter the database username, and click Store in Vault to enter the user password.

    Connect to RCS database in MySQL Workbench

  6. Keep the Default Schema field empty.

  7. To tighten your database connection, navigate to the SSL tab and select If available in the Use SSL drop-down field.

  8. Click OK to save changes and connect to your RCS Managed Database for MySQL.

  9. The MySQL Workbench SQL Editor opens with your database and is ready for use on your computer.

  10. Save the connection to enable it on your computer permanently.

DBeaver

DBeaver is a free, open-source graphical database management tool that supports many SQL database engines such as MySQL, MariaDB, SQLite, and PostgreSQL. It supports cloud data sources, is extensible with extensions, and offers an easy-to-use interface.

To connect your RCS Managed Database for MySQL using DBeaver, download and install the application from the official website.

  1. Open the DBeaver from your applications list.

  2. Click Database on the top menu bar and select Connect to a database.

  3. Click MySQL from the icon list of database options, and click Next.

  4. In the Server section, enter your RCS host address in the Server Host: field.

  5. Enter the database connection port in the Port: field.

  6. In the Authentication field, enter your database administrator username and password in the Username: and Password: fields, respectively.

    Connect DBeaver to RCS SQL Database

  7. Navigate to the SSL tab, and click Use SSL to enable all secure connection options.

  8. In the Advanced section, deselect the Require SSL: and Verify server certificate options if you have not specified a certificate file for your computer.

  9. Click Test Connection to verify that your details are correct.

  10. When successful, click Finish to save your connection settings.

  11. Your RCS database displays in the Database Navigator window, double-click it to connect and start managing your database.

CloudBeaver

CloudBeaver is a free, open-source self-hosted database management tool released under the Apache 2.0 license for developers and database users. It supports multiple databases, an SQL editor, a role-based security model, and can migrate to a Kubernetes cluster.

To connect to your RCS Managed Database for MySQL using CloudBeaver, install the application using docker as listed on the official GitHub instructions page. Then follow the instructions below.

  1. Access the CloudBeaver web interface. Replace the following URL with your actual server address.

     http://192.168.0.2:8080
    
  2. In the Connection Management section, click Add.

  3. Click MySQL from the list of database engines.

  4. Within the Driver tab, enter your RCS database host address, port in the Host and Port fields, respectively.

  5. In the Authentication section, enter your database username and password in the appropriate fields.

    Connect RCS Database using CloudBeaver

  6. Click Driver Properties and enter ssl in the NAME field.

  7. On the useSSL result, click the true drop-down, and select Yes.

  8. Click Test to verify your database details.

  9. When a connection is established, click Create to permanently add your RCS database connection.

  10. Navigate to Connection Management, click your RCS database and establish a connection to start managing the database.

Beekeeper Studio

Beekeeper Studio is a popular SQL database management tool that supports several database engines such as MySQL and MariaDB. It offers features such as SSL connections, an advanced SQL query manager, a multi-tab interface, and data export in multiple formats.

To connect to a RCS Managed Database for MySQL using Beekeeper Studio, you need to install the latest version from the official website, then follow the steps below.

  1. Open Beekeeper Studio.

  2. In the New Connection tab, click the select connection drop-down field and select MySQL from the list.

  3. In the pop-up window, keep MySQL, and keep Host and Port selected as the connection mode.

  4. Enter your RCS Host address and connection port in the Host and Port fields, respectively.

  5. Toggle the Enable SSL button to ON.

  6. Enter your database username and password in the respective fields. Keep the Default database field empty.

    Connect Beekeeper Studio to RCS Managed Database for MySQL

  7. Click Test to verify that your database details are correct.

  8. When successful, enter a custom name in the Save Connection field and click Save to make the database connection permanent.

  9. Click Connect to make a connection to your RCS Managed Database for MySQL and start managing your database in Beekeeper.

HeidiSQL

HeidiSQL is a free graphical SQL database manager that supports both MySQL and MariaDB Databases. It offers rich features such as SSH tunnel connections, a variables editor, a table editor, full-text search, and a scheduled event manager.

To use HeidiSQL with your RCS Managed Database for MySQL, you need to download and install the latest version from the official website.

  1. Open HeidiSQL.

  2. In the Session Manager window, click New in the bottom left corner.

  3. Keep MariaDB or MySQL (TCP/IP) selected as the Network type.

  4. Enter your RCS database host address in the Hostname/IP field.

  5. Enter your database username and password in the respective fields.

  6. Enter your RCS database port in the Port: field.

    Connect HeidiSQL to RCS Database

  7. Navigate to the SSL tab, and check Use SSL to secure your connection.

  8. Click Save in the bottom left corner to save your connection.

  9. Click Open to establish a connection to your RCS database and open the SQL query editor.

SQLECTRON

Sqlectron is an open-source lightweight database management tool that offers both a graphical and command line-based interface for database connections. It supports several database engines, offers secure SSL connections, an SQL query manager, and SQL auto-complete feature.

To connect Sqlectron to your RCS Managed Database for MySQL, you need to download the latest version of the application from the official GitHub repository.

  1. Open Sqlectron from your applications menu.

  2. In the open Servers dialog, click Add to setup a new connection.

  3. Enter your connection name, and select MySQL as the database type.

  4. Toggle the SSL button to ON.

  5. Enter your RCS host address in the Server Address field, and set the connection port.

  6. Enter a valid database user and password in the respective fields.

    Connect RCS Managed Database for MySQL using Sqlectron

  7. Click Test to verify your database details.

  8. When the connect test is successful, scroll and click Save to make the connection permanent.

  9. Click Connect to establish a connection to your RCS database and open the SQL query editor.

Navicat is a paid graphical MySQL database administration and development tool that supports SQL modeling and simultaneous connections to multiple databases. It offers features such as database migration, quick data generation, charts, SSL connections, collaboration, and a visual SQL builder.

To connect to a RCS Managed Database for MySQL using the Navicat for MySQL application, you need to download the latest version from the official website.

  1. Open Navicat for MySQL from your applications menu.

  2. Click Connection on the main navigation tool bar, and select MySQL from the list of options.

  3. In the New Connection pop-up, give your database connection a name.

  4. Enter your RCS database host address, and connection port in the respective Host:, and Port: fields.

  5. Enter the RCS database username and password in the respective fields.

    Setup RCS Database connection using Navicat for MySQL

  6. Navigate to the SSL tab, and check use SSL.

  7. Click Test Connection to verify your database details.

  8. When the connection test is successful, click save to add your connection.

  9. Double Click your database connection on the left navigation bar to establish a connection to your RCS database.

  10. When connected, your RCS database schema displays in the application.

DbGate

DbGate is a free, open-source graphical SQL database management tool that supports multiple database management and cross-database connections. It supports SSL connections, javascript scripting, rich database design tools, a schema editor, a query editor, and a SQL generator.

To connect DbGate to your RCS Managed Database for MySQL. Download and install the latest version from the official website and follow the following steps.

  1. Open DbGate from the applications menu.

  2. In the New Connection prompt, select MySQL as the connection type.

  3. Keep the connection mode as Host and Port.

  4. Enter your RCS database host address in the Server field.

  5. Enter the RCS database port in the Port field.

  6. Enter the RCS database user and password in the User and Password fields, respectively.

  7. Click the SSL tab, and check Use SSL to ON.

    Connect to a RCS Database using DbGate

  8. Click Test to verify your database details.

  9. When the connection test is successful, click Save to add your connection permanently.

  10. Click Connect to establish a connection to your RCS database.

  11. Close the connection dialog and start managing your database from the left navigation Connections tab.


Was this answer helpful?
Back

Powered by WHMCompleteSolution