Download MySQL WorkbenchOne tool you can use to connect to your server Remotely with is MySQL Workbench. MySQL Workbench is a free tool you can use to connect to your server databases from your personal computer at home. 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 is 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 MySQL Workbench. After you have the program installed, follow the steps below to set up the 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 our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Comments

Post a comment
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
5,522 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
5,522 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
5,522 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
5,522 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
10,499 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
10,499 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
4,023 Points
2014-03-27 10:21 am
Your information should still be saved if you update MySQL Workbench.

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

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

Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 1895
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5132

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

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!