---
title: "How to Connect to a Database with MySQL Workbench"
description: "MySQL Workbench is a free tool that can connect your database to your Shared, VPS, or Dedicated Hosting account. The application can replace phpMyAdmin as your interface to work with your database...."
url: https://www.inmotionhosting.com/support/website/connect-database-remotely-mysql-workbench/
date: 2013-03-01
modified: 2025-02-20
author: "InMotion Hosting Contributor"
categories: ["Website", "Working with Databases"]
type: post
lang: en
---

# How to Connect to a Database with MySQL Workbench

![](https://www.inmotionhosting.com/support/wp-content/uploads/2023/03/mysql-workbench-1024x538.jpg)

**MySQL Workbench** is a free tool that can connect your database to your [Shared](https://www.inmotionhosting.com/shared-hosting), [VPS](https://www.inmotionhosting.com/vps-hosting), or [Dedicated Hosting](https://www.inmotionhosting.com/dedicated-servers) account. The application can replace [phpMyAdmin](https://www.inmotionhosting.com/support/phpmyadmin-mysql/) as your interface to work with your database.

We will provide you with the information to download and install the application. Then, we will guide you through the steps to set up a remote connection to your database.

## Download and Install MySQL Workbench

MySQL Workbench is a visual tool for many tasks, including SQL development, data modeling, and database administration. The tool is available for Windows, Linux, and Apple operating systems.

[Download MySQL Workbench](https://www.mysql.com/products/workbench/) for free from the MySQL home page.

Once you have downloaded the version of **MySQL Workbench** to match your computer, install it based on your operating system requirements.

## Video – How to Connect a Database with MySQL Workbench

![How to Connect to a Database with MySQL Workbench](https://i.ytimg.com/vi_webp/uVMCXYQoz1I/maxresdefault.webp)

*Don’t have time to read the article? Watch our walk-through video.*

## Add IP to Your Remote MySQL

[Add your local computer IP address to the Remote MySQL ](/support/website/setting-up-a-remote-mysql-connection-in-cpanel/)in cPanel to connect to your databases remotely. You can get your IP address by going to the following link: [What is my IP address?](https://www.inmotionhosting.com/support/tools/what-is-my-ip-address/)

## Connect To Your Database Remotely

After installing MySQL Workbench and saving your IP address in Remote MySQL, you must configure MySQL Workbench to connect to the database. You will also need to know your database credentials. If you have problems obtaining your credentials, please get in touch with our [live technical support team](https://www.inmotionhosting.com/contact) for assistance.

1. Open **MySQL Workbench**.
2. In the bottom left of the page, click on **New Connection**.![New Connection MySQL Workbench](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_connect-database-mysql-workbench_mysql-workbench-1-new-connection.gif)
3. Enter your database connection credentials in the **Set up a New Connection** dialog box. The following is a list of the credentials you will be configuring:**Connection Name**: You can name this whatever you like.**Connection Method**: Standard (TCP/IP).**Hostname**: You can use your domain our your cPanel IP address.**Port**: 3306**Username**: Your cPanel username or the user you created for the database.**Password**: cPanel password or the password for the created database user.**Default Schema: **This can be left blank.
4. Click **Test Connection**.![Test Connection MySQL Workbench](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_connect-database-mysql-workbench_mysql-workbench-2-connection-setting.gif)
5. If you see the message “Connection parameters are correct,” click **Ok**.![Correect connetion MySQL Workbench](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_connect-database-mysql-workbench_mysql-workbench-4-correct.gif)
6. Click **Ok** again to accept the connection settings.
7. You will find your newly created connection in the SQL Development section. Go to **Open Connection to Start Querying**, then select your connection.

You will see the databases listed on the left side like this:

![View Databases in MySQL Workbench](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_connect-database-mysql-workbench_mysql-workbench-7-databases.gif)

Once connected to your database, you can use the MySQL Workbench as your new tool to modify, develop, and administrate your databases. Its [features](https://www.mysql.com/products/workbench/features.html) make it a great tool you can use without logging into cPanel.
