Bug #101404 shows 1042 error while configuration setting by installer
Submitted: 30 Oct 2020 15:00 Modified: 5 Nov 2020 13:26
Reporter: ABHIJIT BORKOTOKY Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:8.0.22 OS:Windows (10 64bits)
Assigned to: CPU Architecture:Other (x64)

[30 Oct 2020 15:00] ABHIJIT BORKOTOKY
Description:
While installing MySQL Server 8.0.22, it shows "MySQL error 1042: Unable to connect to any of the specified MySQL hosts." and the details as describe below:

"Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.22...
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.22) initializing of server in progress as process 9488
InnoDB initialization has started.
InnoDB initialization has ended.
root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Process for mysqld, with ID 9488, was run successfully and exited with code 0.
Successfully started process for MySQL Server 8.0.22.
MySQL Server 8.0.22 intialized the database successfully.
Ended configuration step: Initializing database (may take a long time)

Beginning configuration step: Starting the server

Attempting to start service MySQL80...
Successfully started service MySQL80.
Waiting until a connection to MySQL Server 8.0.22 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 2: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 3: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 4: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 5: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 6: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 7: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 8: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 9: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 5 seconds before the next connection attempt...
Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Failed to connect to MySQL Server 8.0.22 after 10 attempts.
Ended configuration step: Starting the server"

Please help how to solve it and run MySQL command line. I am using MS Windows 10 64 bits OS.

How to repeat:
Please give me solution how to run MySQL in  My PC.
I repeated many times but same.....
Send suggestion to email Id
abhiborkotoky@outlook.com
[30 Oct 2020 15:06] ABHIJIT BORKOTOKY
My computer detail

Attachment: Screenshot (24).png (image/png, text), 92.46 KiB.

[30 Oct 2020 15:06] ABHIJIT BORKOTOKY
My computer detail

Attachment: Screenshot (24).png (image/png, text), 92.46 KiB.

[30 Oct 2020 15:06] ABHIJIT BORKOTOKY
My computer detail

Attachment: Screenshot (24).png (image/png, text), 92.46 KiB.

[30 Oct 2020 15:07] ABHIJIT BORKOTOKY
workstation

Attachment: Screenshot (25).png (image/png, text), 101.93 KiB.

[5 Nov 2020 13:26] MySQL Verification Team
Hello ABHIJIT,

Thank you for the bug report.
This is most likely duplicate of Bug #95413, please see Bug #95413.
Please follow the steps stated by Miguel in the Bug #95413. Thanks.

Regards,
Ashwini Patil