Solved

access to MySQL from Windows 7 via MySQL Workbench

Posted on 2010-09-01
3
613 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

707 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