Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to use MySQL Workbench to access remote MySQL databases hosted in a web site

Posted on 2016-09-16
4
Medium Priority
?
157 Views
Last Modified: 2016-09-16
We have 'MySQL Workbench' v6.2 and want to access MySQL databases hosted in other remote web locations.  How can we do this?
0
Comment
Question by:rayluvs
  • 2
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
gplana earned 2000 total points
ID: 41801971
Just create a new MySQL connection to your site:

https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-new.html

Instead of 127.0.0.1 you should put the IP of your server.

It it doesn't work you may have to contact your hosting provider to enable mysql remote connections.

Hope it helps. Regards.
0
 

Author Comment

by:rayluvs
ID: 41801996
Yes, that is what we have.  But just finish finding out that the site where the database is located, has a SSL certificate.   Any additional info besides your comment in order to make it work?
0
 

Author Comment

by:rayluvs
ID: 41802108
Hi,

FYI:

It was the enable mysql remote connections; called & done!

Thanx!
0
 
LVL 15

Expert Comment

by:gplana
ID: 41802207
Excellent! Thank you for letting me know.
0

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question