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:

http://dev.mysql.com/downloads/workbench/

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.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

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? 

Staff
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
ON SCHEDULE EVERY 1 MINUTE
DO
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:

event_scheduler=ON



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

- Jacob
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?

Staff
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..

Staff
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

Jacob,

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

Staff
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

Jacob,

Can I import data through .text file? 

Staff
17,273 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.

Regards,

Arnel C.
n/a Points
2014-03-26 8:41 pm
I'm not seen those import export buttons....
Staff
17,273 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).

Regards,
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?

Staff
9,162 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

hi

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

Failed to connect to mysql at ridgesushi.com:3306 with user ******

can't connect to MYSQL on 'ridgesushi.com'(10060)

 

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

 

may i know what is the issue ??

 

Staff
9,162 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

sir 

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

Staff
19,427 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 

 

Staff
9,162 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.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

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

21 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

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: support@InMotionHosting.com
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!