Tech A Services
  • Home
  • Help Center
  • Support
  • Sign In
  • View Services
  1. Portal Home
  2. Knowledgebase
  3. 03 Hosting
  4. Overview of MySQL Workbench and Remote Database Connection

  Categories

01 Getting Started
5
02 The Client Area
2
03 Hosting
6
04 Emails
5
05 WordPress Essentials
7
06 Plugins
5
07 Security
8

  Categories

  Tag Cloud

buy domain buy hosting plan domain registration domain transfer Email Backup Email Configuration Email Transfer Microsoft Outlook POP Protocol WordPress Security WordPress Website Security

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket

Overview of MySQL Workbench and Remote Database Connection Print

  • 0

This guide provides an overview of MySQL Workbench and instructions for connecting to your database remotely.


Prerequisites

Before proceeding, ensure you have the following:

  1. MySQL Workbench Installed:
    Download the appropriate version for your operating system (Windows, macOS, Ubuntu, RedHat, or Fedora) from the MySQL Workbench Downloads page.
  2. Public IP Address:
    The IP address of the MySQL Server (also the website’s hosting IP).
  3. Database Credentials:
    The username and password for the MySQL account you want to connect.
  4. Safelisted IP Address:
    Add your local machine’s IP address to the server’s firewall to allow access to the MySQL port.

What Is MySQL Workbench?

MySQL Workbench is a cross-platform graphical user interface for managing SQL servers and databases. It is maintained by Oracle and includes tools for:

  • SQL Development
  • Data Modeling
  • Server Administration
  • Data Migration
  • Performance Monitoring

Key Features:

  1. SQL Development: Run and edit SQL queries, manage connections, and manipulate data objects.
  2. Data Modeling: Create and edit database schemas with a visual Table Editor.
  3. Server Administration: Manage users, perform backups, monitor database health, and configure servers.
  4. Data Migration: Migrate data from other database systems like PostgreSQL, Microsoft SQL Server, and more.
  5. Performance Dashboard: Monitor metrics and identify performance issues through visual reports.

Steps to Connect MySQL Workbench to a Remote Database

1. Install MySQL Workbench

Download and install the version suited for your system. MySQL Workbench is available in:

  • Community Edition (Open Source)
  • Standard and Enterprise Editions (Commercial)

2. Obtain Database Credentials

You’ll need the hostname/IP address, database username, and password. Contact the TAS support team if you need assistance retrieving these credentials.

3. Safelist Your IP Address

Add your local machine’s IP address to the server’s firewall for MySQL access. If you have a dynamic IP, repeat this step whenever your IP changes.

4. Open MySQL Workbench and Create a New Connection

  1. Launch MySQL Workbench and click the + button to start a new connection.
  2. Fill in the following details in the "Setup New Connection" window:
    • Connection Name: A descriptive name (e.g., "MyWebsite_Database").
    • Connection Method: Standard (TCP/IP).
    • Hostname: Enter the hosting IP address.
    • Port: Leave as default (3306).
    • Username: Enter your database username.
    • Password: Click Store in Keychain to save the password.
    • Default Schema: Leave blank if not specified.

5. Test the Connection

Click Test Connection to verify your settings.

6. Save and Connect

If the test is successful, click OK to save the connection and access the database.


Managing Your Database in MySQL Workbench

Once connected, you can:

  • View and edit database configurations under Administration.
  • Monitor server performance using the Performance Dashboard.
  • View users, permissions, and current connections.
  • Import/export MySQL dump files for backup or restoration.
  • Use the Schemas section to view and interact with database tables and objects.

From the Schemas area, you can expand database objects, run complex queries, and edit data directly within MySQL Workbench.


By following these steps, you’ll be able to efficiently manage and interact with your remote database using MySQL Workbench.


Was this answer helpful?

Related Articles

How to Cancel Your Domain Management Services with TAS Canceling your domain management services with TAS is a straightforward process. Follow these... How to Cancel Your Web Hosting Service with TAS Canceling your web hosting service with TAS is a straightforward process designed for your... Guide for a Smooth Email Transfer away from TAS To ensure a seamless transfer of your emails from the TAS Belize server, please follow these... How to Purchase a Hosting Plan on TechAServices.com How to Purchase a Hosting Plan on TechAServices.com Purchasing a hosting plan on... Instructions for Using Your Backup After Cancellation Once you’ve submitted your request to cancel hosting and maintenance services, TAS will provide a...
« Back

  Tag Cloud

buy domain buy hosting plan domain registration domain transfer Email Backup Email Configuration Email Transfer Microsoft Outlook POP Protocol WordPress Security WordPress Website Security

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket
Tech A Services

Reliable technology, hosting, websites and digital solutions backed by real support.

  • Client Portal

    • Dashboard
    • My Services
    • Billing
    • Order Services

    Support

    • Support Tickets
    • Open a Ticket
    • Help Center
    • Contact Us

    Account

    • Sign In
    • Create Account

    Tech A Services

    • Main Website
    • Terms of Service
    Copyright © 2026 Tech A Services (TAS). All Rights Reserved.
    Client Portal

    Loading...
    Loading...
    Choose language
    العربية
    Azerbaijani
    Català
    中文
    Hrvatski
    Čeština
    Dansk
    Nederlands
    English
    Estonian
    Persian
    Français
    Deutsch
    עברית
    Magyar
    Italiano
    Macedonian
    Norwegian
    Português
    Português
    Română
    Русский
    Español
    Svenska
    Türkçe
    Українська

    Choose Currency

    $ USD
    BZ$ BZD

    Generate Password

    Please enter a number between 8 and 64 for the password length