Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 2nd February 2011, 01:11
lloydcodrington lloydcodrington is offline
Junior Member
 
Join Date: Feb 2009
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL Workbench Connection Error

Hi Guys,
I have a centOS local testing server which I installed with the aid of one of the guides on this site. It has been working fine and I am able to access all my test sites and databases via Dreamweaver ftp and SSH etc. Also I am able to access mysql using phpmyadmin.

However I now need the power of MySQL Workbench to work on a project and am having difficulty connecting to the database. I keep getting an error: Can't connect to MySQL server on (10060).

Can anyone suggest a way forward as I am running out of hair....

Thanks in anticipation,
Lloyd
Reply With Quote
Sponsored Links
  #2  
Old 2nd February 2011, 16:25
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
Default

Did you install MySQL Workbench on your Windows desktop? If so, does your MySQLserver allow remote connections? Is port 3306 open in the server's firewall?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 2nd February 2011, 17:48
lloydcodrington lloydcodrington is offline
Junior Member
 
Join Date: Feb 2009
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi falko,
Yes I do have the port open but I was wondering if there was something I needed to set in the config file as I do know that on my production server which I manage via WebHostManager, WHM, I have to specify a host for it to be allowed remote access to MySQL itself. But am not sure what and where the changes are stored when done via WHM.
Reply With Quote
  #4  
Old 3rd February 2011, 14:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
 
Default

Quote:
Originally Posted by lloydcodrington View Post
I have to specify a host for it to be allowed remote access to MySQL itself.
Can you use a wildcard? Otherwise you must use your desktop PC's public IP (or the hostname that is associated to that IP; you can look it up as follows:
Code:
dig -x 1.2.3.4
Replace 1.2.3.4 with your public IP.)
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Tags
(10060), connection, error, mysql workbench

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 mail doesn't work Marr General 6 1st September 2010 10:32
Problem with services!! banzaiwebstudio.com Installation/Configuration 7 19th May 2010 22:13
Mail not working epicuniversal General 5 13th June 2009 09:24
LB1 Not Taking Over Shared IP Using Heartbeat 2.1.3 On FC10 64Bit asyadiqin Installation/Configuration 5 11th February 2009 21:11
Installation Fails... :( cyberstorm Installation/Configuration 1 15th January 2006 19:07


All times are GMT +2. The time now is 18:21.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.