MySQL Forums
Forum List  »  MySQL Workbench

Workbench - Could not connect to MySQL server during Test DB Connection
Posted by: Jeremy Burr
Date: April 29, 2013 02:12AM

I have recently developed a relational DB in MySQL Workbench 5.2.47.CE rev10398 running on Win7.

Unfortunately, I wasn't able to get the connections to Xammp set up correctly (probably due to my company's security policies and SW component removal). Therefore, I purchased a new laptop, and downloaded the same MySQL Workbench 5.2.47.CE rev10398. The new laptop runs Win8. Xammp is now running on the new platform :-) However, I cannot connect to the MySQL server during the "Test DB connection" task.

In both cases, Win7/Win8, I followed the Workbench documentation for new server instances, giving the default inputs, but the responses were different for the same input.

Win7 / Win8
Click "New Server Instance" in Server Administration
"localhost" is highlighted in radio button.
Click "Next"
Hostname: localhost
Port: 3306
Username: root
Password: <Store in Vault> or <Clear> {no difference to problem)
Default Schema: <left blank>
Click "Next"
{everything is the same to here}

Win7
Screen Log:
"The database connection information is being tested...."
{checked} Open Database Connection
{checked} Get Server Version: 5.6.10
{checked} Get Server OS:Windows
"Database connection tested successfully."

Win8
Screen Log:
"The database connection information is being tested...."
{red "X"} Open Database Connection
{red "X"} Get Server Version: 5.6.10
{red "X"} Get Server OS:Windows
{in red} "Could not connect to MySQL server:"
{in red} "Can't connect to MySQL server on '127.0.0.1' (10061)"
{in red} "You may continue if the server is simply not running."
Message Log:
Connection to MySQL server localhost...
Can't connect to MySQL server on '127.0.0.1' (10061)

Win7 platform = Lenovo T420, Intel Core i5-2520M processor
Win8 platform = Acer Aspire V5, Intel Core i5-3337U processor

Can you please provide guidance on to resolve this server connection issue.

Thanks.
Jeremy

Options: ReplyQuote


Subject
Views
Written By
Posted
Workbench - Could not connect to MySQL server during Test DB Connection
6979
April 29, 2013 02:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.