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
Solved

access to MySQL from Windows 7 via MySQL Workbench

Posted on 2010-09-01
3
611 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mysql ide 10 45
BACKUP of mysql database from mysql server - using Coldfusion 9 42
Optimize the query 5 43
Wifi connection to laptop without router windows 10 11 39
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 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