Solved

Cannot connect WorkBench from Windows 7 pc to Windows server

Posted on 2014-09-06
2
334 Views
Last Modified: 2014-09-10
Running Windows 7 pro on pc (let's call it workstation 1)
Running Small Business Server 2008 on the Windows server (let's call this ML350)
WorkBench can successfully connect to localhost if I am logged in directly on the ML350 server so I know the MySql service is running and WorkBench on the server is working well.
The problem is connecting from workstation 1 to the ML350 server.
I have done the following:
 - Created outbound rule on workstation 1 for port 3306
 - When I execute the command “telnet ml350 3306”  telnet says it can successfully communicate so I know ports are not an issue.
 - When I attempt to create a connection in WorkBench to ML350, I enter:
 .    Connection name:  Test1
.      Connection method is standard (tcp/ip)
.     Hostname is ML350
.      Port is : 3306
.      username is : root

When I click on “test connection” , the dialog asks for the password for root.  I enter it and click on OK and get the error message:
   “ Failed to connect to MySQL at ML350:3306 with user root.”

I have tried replacing the hostname with the ip address of ML350 server and get the same message.

What am I missing ?  How do I solve this?
0
Comment
Question by:donpick
[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 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 40308206
Do not use 'root' for a remote connection.  It is normally restricted to 'localhost' because it can be used to cause damage up to destroying the server.  Create a user with the privileges you need and 'anyhost' for remote access.  http://dev.mysql.com/doc/refman/5.5/en/adding-users.html
0
 

Author Closing Comment

by:donpick
ID: 40316218
Thank you for your answer.  I managed to figure out how to add a user using the Workbench utility.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Creating and Managing Databases with phpMyAdmin in cPanel.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

688 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