Re: MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Posted by: Viacheslav Latypov
Date: June 04, 2020 01:55PM

The problem appears during the configuration step (starting the server). The message about attempts can be seen in the log. After 10 retries, the wizard shows the error.

info from the log file:

mysql-installer Information: 10 : Successfully started service MySQL80.
DateTime=2020-06-04T17:31:54.7267601Z
mysql-installer Information: 10 : Waiting until a connection to MySQL Server 8.0.20 can be established (with a maximum of 10 attempts)...
DateTime=2020-06-04T17:31:54.7267601Z
mysql-installer Information: 10 : Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:31:54.7580076Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:31:55.0548708Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:31:55.1017491Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:31:55.1017491Z
mysql-installer Information: 10 : Retry 2: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:00.1172253Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:00.1172253Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:00.1172253Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:00.1328436Z
mysql-installer Information: 10 : Retry 3: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:05.1435044Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:05.1435044Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:05.1435044Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:05.1591307Z
mysql-installer Information: 10 : Retry 4: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:10.1664909Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:10.1664909Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:10.1664909Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:10.1821089Z
mysql-installer Information: 10 : Retry 5: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:15.1975812Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:15.1975812Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:15.1975812Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:15.2132034Z
mysql-installer Information: 10 : Retry 6: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:20.2299790Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:20.2299790Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:20.2299790Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:20.2455953Z
mysql-installer Information: 10 : Retry 7: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:25.2610755Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:25.2610755Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:25.2610755Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:25.2766937Z
mysql-installer Information: 10 : Retry 8: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:30.2915714Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:30.2915714Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:30.2915714Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:30.3071880Z
mysql-installer Information: 10 : Retry 9: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:35.3240682Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:35.3240682Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:35.3240682Z
mysql-installer Information: 10 : Waiting 5 seconds before the next connection attempt...
DateTime=2020-06-04T17:32:35.3396862Z
mysql-installer Information: 10 : Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
DateTime=2020-06-04T17:32:40.3551573Z
mysql-installer Information: 10 : MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
DateTime=2020-06-04T17:32:40.3551573Z
mysql-installer Error: 50 : Sequence contains more than one matching element
Thrown by: Logger.LogException
DateTime=2020-06-04T17:32:40.3551573Z
mysql-installer Information: 10 : Failed to connect to MySQL Server 8.0.20 after 10 attempts.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
474
June 04, 2020 01:55PM


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.