MySQL Forums
Forum List  »  MySQL Workbench

MySQL 8.0 Windows 10 Connection to local MySQL fails from Workbench
Posted by: Kevin Shaw
Date: April 25, 2018 08:10AM

Hi,

I'm trying to get my newly installed Workbench to connect to my newly installed MySQL server.

Windows 10, version 8.0.

An attempt to connect hangs for a while, and then fails with:

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 (code 2013)"

(from the Workbench log).

I can connect to the server from the same PC using the MySQL Shell, as follows:

MySQL JS > \connect root@localhost:3306
Creating a session to 'root@localhost:3306'
Enter password: ***********
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 16
Server version: 8.0.11 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.

MySQL localhost:3306 ssl JS >

It also works with mysqladmin:

[kevin.shaw.kshaw] ➤ ./mysqladmin.exe -u root -p"Doug&hetty1" version
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin.exe Ver 8.0.11 for Win64 on x86_64 (MySQL Community Server - GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version 8.0.11
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 4 min 52 sec

Threads: 2 Questions: 9 Slow queries: 0 Opens: 126 Flush tables: 2 Open tables: 102 Queries per second avg: 0.030

───────────────────────────────────────────



The Workbench connection is being attempted from the same PC as the MySQL server is installed on, and the same PC as the MySQL Shell and mysqladmin are run from.

The Workbench connection uses root, localhost, 3306, and a TCP/IP connection

What is the problem?

Thanks

Kev

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0 Windows 10 Connection to local MySQL fails from Workbench
103
April 25, 2018 08:10AM


Sorry, only registered users may post in this forum.

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.