Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

Cannot connect WorkBench from Windows 7 pc to Windows server

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
donpick
Asked:
donpick
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
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
 
donpickAuthor Commented:
Thank you for your answer.  I managed to figure out how to add a user using the Workbench utility.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now