Solved

access to MySQL from Windows 7 via MySQL Workbench

Posted on 2010-09-01
3
603 Views
Last Modified: 2013-11-15
I have a new MySQL database set up and I need to manage it with MySQL Workbench.  Everything works great on the localhost, but as soon as I try to install a new server instance and connect to MySQL from my workstation, I get a failure.  I have tried by both IP as well as hostname.  I am using an administrator level database user on the SQL box.  The database is on an Ubuntu Server machine and is working perfectly with this exception.  I made sure the server is listening on 3306.  It still appears that I have a permissions issue, but I can't seem to find out what it is.  I can access the database management with PHPMyAdmin, but I need to be able to use some of the MySQL tools.
0
Comment
Question by:219com
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
dehcbad25 earned 500 total points
ID: 33579906
by default remote access is disabld on MySQL. Have you enabled it?
If not, here is a quick guide that I found doing a quick search
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
0
 

Author Closing Comment

by:219com
ID: 33580198
Cool, thanks, that was easier than I figured it would be.
0
 
LVL 2

Expert Comment

by:dehcbad25
ID: 33581468
I had this problem a couple of times as well :p
I like the MySQL workbench to do backups, even though I use phpmyadmin for everything else
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

If you use Debian 6 Squeeze and you are tired of looking at the childish graphical GDM login screen that is used by default, here's an easy way to change it. If you've already tried to change it you've probably discovered that none of the old met…
This article will explain how to establish a SSH connection to Ubuntu through the firewall and using a different port other then 22. I have set up a Ubuntu virtual machine in Virtualbox and I am running a Windows 7 workstation. From the Ubuntu vi…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now