InMotion Hosting Support Center

Download MySQL WorkbenchOne tool you can use to connect to remotely connect to databases on your shared, VPS, or Dedicated hosting account is MySQL Workbench. MySQL Workbench is a free tool you can use to connect to your server databases from your personal computer. MySQL Workbench can be Downloaded for free at the following link:

You will want to use the Windows (x86, 32-bit), MSI Installer if you are on Windows. The file we are installing in this tutorial is the mysql-workbench-gpl-5.2.47-win32.msi file.

Once you have downloaded MySQL Workbench, you can install it onto your computer. After you have the program installed, follow the steps below to set up a remote connection.

Add IP to your Remote MySQL

In order for you to be able to connect to your databases remotely you will need to add your local computer IP address to the Remote MySQL in cPanel. You can get your IP address by going to the following link:

What's My IP address?

Steps to connect to your database remotely

  1. Open MySQL Workbench.
  2. New Connection MySQL WorkbenchClick New Connection towards the bottom left of MySQL Workbench.
  3. Test Connection MySQL WorkbenchIn the "Set up a New Connection Dialogue" box, Type your Database connection credentials. The credentials will be like the following:

    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 database user that was created.
    Default Schema: This can be left blank.

    Click Test Connection.

  4. Enter password MySQL WorkbenchType your password and click the "Save Password in Vault" check box.

    Click Ok.

  5. Correect connetion MySQL WorkbenchMySQL Workbench should say "Connection parameters are correct". Click Ok.
  6. Click ok MySQL WorkbenchClick Ok again to accept the connection settings.
  7. Open Connetion MySQL WorkbenchNow under the SQL Development section you will see your connection listed in the Open Connection to Start Querying box. Click your newly created account.

    View Databases in MySQL WorkbenchNow you will see the databases list in the area on the left.

Support Center Login

Social Media Login

Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-03-26 10:17 am

Is there any way I can set up job schedule in Mysql workbench 5.2ce? 

9,968 Points
2014-03-26 10:36 am
Hello Dushyant,

It depends what you mean by being able to set up a job schedule. For instance you can use MySQL Workbench in order to schedule a backup of your database.

Or are you instead referring to the MySQL Event Scheduler? If that is the case, then yes you can create your Events from within MySQL Workbench using the standard syntax for doing so:

CREATE EVENT hit_update
UPDATE user_hits SET hits = hits + 1;

Although for this to work, your server's /etc/my.cnf configuration file must contain the line turning on the Event Scheduler:


Please let us know if you had any further questions at all.

- Jacob
n/a Points
2014-11-02 4:27 pm

If your site has a certificate installed, you can use SSH to secure you connection to MySQL for MySQL Workbench.  In MySQL Workbench, setup the connection as follows:

  • SSH Hostname: <>:2222
  • SSH Username: <yourSSHuser>
  • SSH Password: <sshpasword>
  • SSH Key File: <path to your SSH private keyfile>
  • MySQL Hostname:
  • MYSQL Server Port: 3306
  • Username: <DBUserAccount>
  • Default Schema:  <leave blank>

Click Test Connection and you will be prompted for the <DBUserAccount> password which you can store in your keychain.

n/a Points
2014-11-05 12:10 pm

There is actually no requirement for the site certificate.  The SSH tunnel is established separately from SSL/TLS.  Although SSH may utilize SSL/TLS, in the case of MySQL Workbench, only the SSH connection information is required.

n/a Points
2014-03-26 10:43 am

Jacob, Thanks for replying me back,

I'm planning to set up job in mysql  workbench. This job is for the one of the function is referencing the three tables to populate the data in mysql workbench database. That data is comming from SQL database. So do I also need to set up alert too to get the data from sql server? 

Please let me know how to do it?

9,968 Points
2014-03-26 11:01 am
Hello Dushyant, no problem at all.

Are you sure that what you're trying to accomplish is best served by a remote MySQL interface? It sounds like you might be trying to programmatically alter the data in your database, and this is typically done with a scripting language such as PHP interacting with the MySQL database.

Typically you'd have your PHP script connect to your database you need to pull data from, then connect to the database you'd like to put that information into and do an INSERT query.

Doing it this way, you could then just setup a normal cron job on the server to run your PHP script to keep updating your databases.

Alternatively this probably could be done with MySQL Workbench, but you would need to turn on the MySQL Event Scheduler to automate things and I'm not sure of the exact process for using jobs in this fashion with a remote MySQL interface.

- Jacob
n/a Points
2014-03-26 11:50 am

Thanks for your reply.  

I'm not that good to do it... any way is there any screen shot to show me to set up job? 

Or do you have any pdf to take me start working on it..

9,968 Points
2014-03-26 1:03 pm
Hello Dushyant,

Again, are you sure that what you are trying to setup requires a MySQL job? And what are you referring to when you are talking about a job, or job schedule?

If you're talking about using the MySQL Event Scheduler, then I'd recommend reading that documentation from MySQL to help understand the concepts of MySQL events, and see if that is indeed something you need to use.

I don't see a way to directly add MySQL events from MySQL Workbench, so you would just need to use the standard method of doing a normal query for these based on the Event syntax. But again this is only going to be available on a server in which that is turned on server-wide.

- Jacob
n/a Points
2014-03-26 5:10 pm


Is there anyway  I can import data to mysql workbench database? 

9,968 Points
2014-03-26 5:55 pm
Hello Dushyant,

Yes you can import data using MySQL Workbench, but you don't have separate MySQL Workbench databases. It is simply a tool that you use to manage MySQL databases, much like you could use phpMyAdmin on the server itself.

Once you've created a connection to a database on the main Home screen in MySQL Workbench, and then connected to that database, you should see the Navigator panel on the left-hand side.

There should be a Data Import/Restore button a bit further down that you can click on. Then on the next page, you'd more than likely want to select Import from Self-Contained File and then select the location of the .sql backup that you'd like to import into the currently selected database.

- Jacob
n/a Points
2014-03-26 8:31 pm


Can I import data through .text file? 

36,465 Points
2014-03-26 8:54 pm
Hello Dushyant,

Thanks for the question. Actually, the .SQL file is a text file. If you're going to be importing data, it would need to be formatted in some type of table format such as what's found in .csv files in order to be of some use. You can typically use a SQL client such as phpMyAdmin to import the file. If, as per the posts above, you're trying to programmatically update the database, you would need to open the table and match the data you're importing per the database constraints. I hope that helps to answer your question. Please let us know if you need any further information. If you're interested, check out our article on Importing a Database using phpMyAdmin.


Arnel C.
n/a Points
2014-03-26 8:41 pm
I'm not seen those import export buttons....
36,465 Points
2014-03-26 9:07 pm
Hello Dushyant,

I'm not sure what you have loaded, but here is a link for MySQL Workbench version 6.0. The link will also lead to the documentation on this tool. You can also do it via shell (Plugins > Start Shell for MySQL Utilities):

$ mysqldbimport --server=user:pass@host:port:socket db1.csv db2.sql db3.gri
You can type --help after each command for a listing of the flags.

$ mysqldbexport --server=user:pass@host:port:socket db1, db2, db3

(note: this requires either a VPS/Dedicated server account and the appropriate access level).

Arnel c.
n/a Points
2014-03-27 9:33 am

Thank for replying Arn,

 I've currently installed mysql workbench 5.2ce.. Also I check that have an update available for 6.0. So my question is it ok to update newer version? Do I get lost my current database and tables?

11,186 Points
2014-03-27 10:21 am
Your information should still be saved if you update MySQL Workbench.
n/a Points
2014-07-31 7:14 am


i install workbench 6.1 and tried to connect it showing following error

Failed to connect to mysql at with user ******

can't connect to MYSQL on ''(10060)


but when i tried to connect with localhost it's working well


may i know what is the issue ??


11,186 Points
2014-07-31 9:22 am
Have you already added your IP to the allowed MySQL remote hosts? If not, follow our guide on adding your IP to the MySQL remote hosts.
n/a Points
2014-10-21 8:23 am


i have some problem in 5th step my workbeanch is not connect properly it gives some error

41,736 Points
2014-10-21 9:26 am
Hello Shubam,

What is the error message you are receiving on step 5? Be sure that your connection parameters are correct for the server you are trying to connect to.

Kindest Regards,
Scott M
n/a Points
2014-10-21 11:44 am

yes sir i checked 5 to 10 times but it gives error 


11,186 Points
2014-10-21 11:52 am
Could you please provide the specific error message you are getting?
n/a Points
2014-10-21 1:11 pm

Very Nice. It really helped. Very good Mysql Tutorial. Thanks.

n/a Points
2014-11-05 2:27 am

Hello. I tried it but there are some problems.

"Connection parameters are correct SSL not enabled"

How to enable the SSL?Why it cannot enable the SSL?

>< Could you comment the problems?


41,736 Points
2014-11-05 10:11 am
Hello Sally,

Port 3306 is the port used to connect to MySQL, but there is not an SSL connection involved.

Kindest Regards,
Scott M
n/a Points
2014-11-07 5:49 am

Hello Scott M,

Thanks for your reply.

SSL connection is very important???Can I let it go and then still continue to use the software?I would like to create a database to connect the php file, then doing the mail merge function to send a mass email to many recipients.

I am a new user. It is my school project. Could you mind to help me?





10,077 Points
2014-11-07 11:49 am
Hello Sally Mak,

If you are still needing to connect to the database via SSL then you will need to log into the cPanel and use PHPMyAdmin. You can still use the software without the SSL option as the information is still secure.

Kindest Regards,
TJ Edens.
n/a Points
2014-11-09 9:53 am

can any one help me on this:

I have installed mysql, i clicked on new connection and entered username and password

it says Connection parameters are correct SSL not enabled.

how can i enable SSL.

26,744 Points
2014-11-10 11:22 am
Hello vishakha,

Thank you for your question. If you have a a VPS, or Dedicated server, you can Enable SSL/TLS Manager in WHM, for cPanel users.

I could not locate an account on our servers, but if you contact your host they should be able to enable this option for you.

Thank you,
n/a Points
2015-01-20 3:37 pm

Hi .... before I get into learning your interface with MySql I have a simple question. but first here is my background. I used to build online Apps for websites with MSSQL, and mainly ASP/Javascript etc. I retired 7 years ago, and now find myself on a Linux server with access to MySQL. I have a project I want to do that is very simple, but I don't know PHP nor MySQL. However, there is plenty of sample coding available onlone that i can edit for the simple things I need to do. I used to use the free MS tool for remote access to the MSSQL server I hosted with a provider, in order to create tables, fields, import/export data, edit field data when needed quickly for a client, do certain queries for maintenance or correcting mistakes made (made plenty of those). Having the visual aid with handson for repair and maintenance type queries was great. Of course most of my work was done from ASP based code. And so my question is, should I expect that Workbench will basically give me the same type of tools that I am used to. I am using Wordpress and I already bought Gravity Forms, that was a mistake, they integrate the form data somehow into the Wordpress table. I can only find one plugin that creates separate tables, but it is very limited and not well supported. So it looks like my dreaeded concern has raised its head, I have to work from scratch. I desparately need a tool like the one I am used to, because my memory is failing and learning lotsa new coding is only a limited option. At least the project is simple. Finding that your tool might be the trick for me, is great. What can I expect to be able to do out of the things I listed above. They are the only tools I need for a remote connection, create tables, create fields, export/import data, backup, edit fields/rows when I made an error or need a change, and move data from one field to another through query. 

n/a Points
2015-01-20 3:40 pm

Sorry, did not realize I was on a hosting site. Not having heard of Workbench, I thought I was on a site for support for workbench. Excuse my question please, I am not a customer of yours. Will seek support elsewhere.

11,186 Points
2015-01-20 4:04 pm
I'm happy to help where I can.

Regarding how GravityForms stores it's data, it is a WordPress standard and nearly all plugins store data in the same way keep things organized. GravityForms is by far the best form handling plugin available for WordPress and is highly respected by WordPress developers, including myself.

If you're trying to just work with a database, PHPMyAdmin or MySQL Workbench are your best options.
n/a Points
2015-03-29 11:38 am

I dont have a dedicate IP and it is dynamically allocated by ISP so does it mean i have to change IP on cpanel everytime i refresh the router. (mysql remote connecting to workbench)

41,736 Points
2015-03-30 10:08 am
Hello Zam,

Yes, you will need to enter the current IP every time you want to connect.

Kindest Regards,
Scott M
n/a Points
2015-04-22 5:34 am



I want send an automatic email  in mysql as backend using scheduler....

can let me know how to send an email ..with steps..

kindly help me out in this...

Thanks ,


36,465 Points
2015-04-23 7:50 am
Hello Nagnedra,

Apologies but that is unfortunately beyond the scope of our support. We do not provide coding support. You may want to study this post that describes a person approaching the same issue.

Arnel C.
n/a Points
2015-08-18 10:53 am

My SQL databases connect smaller versions 5.1 workbench and I send compatibility issues with version 6.3

10,077 Points
2015-08-18 11:01 am
Hellow Lau,

What version of MySQL are you trying to connect to? We recommend not using any version below 5.0. Are you getting an error when you try to connect?

Best regards,
TJ Edens
2015-09-14 5:13 pm
Thanks for the post
n/a Points
2015-11-13 5:45 am


Is there any way to add a DB2 database in Mysql Workbench?



10,077 Points
2015-11-13 9:57 am
Hello Amy,

It seems that it is not possible to load a DB2 database into workbench as IBM has made the software proprietary.

Best Regards,
TJ Edens
n/a Points
2016-01-18 9:30 am

i cant connet to mysql database even after adding my machine ip address on the list of allowed ips in cpanel

please assiste

41,736 Points
2016-01-18 11:52 am
Hello ceasar,

It should work fine assuming all credentials are correct. What is the specific error message you are getting?

Kindest Regards,
Scott M

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

47 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!