Solved

access to MySQL from Windows 7 via MySQL Workbench

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL - search xml field for multiple occurrences of specific text 6 53
MySQL Error 3 40
MySQL database data submission 7 61
Easy to use inventory management software 7 70
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Creating and Managing Databases with phpMyAdmin in cPanel.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

24 Experts available now in Live!

Get 1:1 Help Now