access to MySQL from Windows 7 via MySQL Workbench

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.
219comAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dehcbad25Connect With a Mentor Commented:
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
 
219comAuthor Commented:
Cool, thanks, that was easier than I figured it would be.
0
 
dehcbad25Commented:
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
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.

All Courses

From novice to tech pro — start learning today.