| Bug #95413 | When using installer, I get connection error | ||
|---|---|---|---|
| Submitted: | 18 May 2019 10:02 | Modified: | 21 May 2019 14:38 |
| Reporter: | Tim Jones | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 8.0.16, 8.0.22 | OS: | Windows (Windows 10) |
| Assigned to: | CPU Architecture: | x86 | |
[18 May 2019 10:05]
Tim Jones
My CPU details: C:\WINDOWS\system32>wmic cpu get caption, deviceid, name, numberofcores, maxclockspeed, status Caption DeviceID MaxClockSpeed Name NumberOfCores Status AMD64 Family 21 Model 112 Stepping 0 CPU0 3000 AMD A9-9420 RADEON R5, 5 COMPUTE CORES 2C+3G 2 OK
[19 May 2019 21:40]
MySQL Verification Team
Open a command line prompt with administrator privileges, go to bin install directory and check the path of my.ini file using the service name i.e?
C:\>cd "Program Files\MySQL\MySQL Server 8.0\bin"
C:\Program Files\MySQL\MySQL Server 8.0\bin>sc qc mysql80 | findstr defaults-file
BINARY_PATH_NAME : "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" MySQL80
check if the service is running trying to stop it :
C:\Program Files\MySQL\MySQL Server 8.0\bin>net stop mysql80
The MySQL80 service is stopping.
The MySQL80 service was stopped successfully.
Now try to start the server with below command and print here what you get:
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --standalone --console
2019-05-19T21:37:08.202077Z 0 [Warning] [MY-010915] [Server] '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.
2019-05-19T21:37:08.205507Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) starting as process 9624
2019-05-19T21:37:10.382580Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-05-19T21:37:10.427625Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL.
2019-05-19T21:37:10.584383Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
if the server starts like below then try to login using the mysql.exe:
c:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.16 MySQL Community Server - GPL
Copyright (c) 2000, 2019, 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.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
[20 May 2019 16:44]
Tim Jones
Hi. I don't have a my.ini file!?
C:\Program Files\MySQL\MySQL Server 8.0\bin>dir
Volume in drive C is Windows
Volume Serial Number is 10EE-D40C
Directory of C:\Program Files\MySQL\MySQL Server 8.0\bin
20/05/2019 17:11 <DIR> .
20/05/2019 17:11 <DIR> ..
13/04/2019 14:34 677,888 harness-library.dll
13/04/2019 06:57 6,391,104 ibd2sdi.exe
13/04/2019 06:57 6,359,872 innochecksum.exe
01/04/2019 10:55 2,104,832 libeay32.dll
01/04/2019 10:54 1,839,616 libmecab.dll
13/04/2019 06:57 6,252,352 lz4_decompress.exe
13/04/2019 06:57 6,646,592 myisamchk.exe
13/04/2019 06:57 6,478,656 myisamlog.exe
13/04/2019 06:57 6,545,216 myisampack.exe
13/04/2019 06:57 6,522,688 myisam_ftdump.exe
13/04/2019 06:57 6,616,384 mysql.exe
13/04/2019 06:57 6,516,544 mysqladmin.exe
13/04/2019 06:57 6,817,088 mysqlbinlog.exe
13/04/2019 06:57 6,528,832 mysqlcheck.exe
13/04/2019 06:57 46,693,696 mysqld.exe
13/04/2019 06:57 6,586,176 mysqldump.exe
13/04/2019 14:16 7,902 mysqldumpslow.pl
13/04/2019 14:16 28,713 mysqld_multi.pl
13/04/2019 06:57 6,508,864 mysqlimport.exe
13/04/2019 06:57 6,990,144 mysqlpump.exe
13/04/2019 06:57 7,056,704 mysqlrouter.exe
13/04/2019 14:34 254,464 mysqlrouter_http.dll
13/04/2019 06:57 7,125,312 mysqlrouter_passwd.exe
13/04/2019 06:57 6,240,064 mysqlrouter_plugin_info.exe
13/04/2019 06:57 6,506,816 mysqlshow.exe
13/04/2019 06:57 6,525,248 mysqlslap.exe
13/04/2019 14:16 7,392 mysql_config.pl
13/04/2019 06:57 6,281,024 mysql_config_editor.exe
13/04/2019 06:57 6,505,792 mysql_secure_installation.exe
13/04/2019 06:57 6,310,208 mysql_ssl_rsa_setup.exe
13/04/2019 06:57 6,206,784 mysql_tzinfo_to_sql.exe
13/04/2019 06:57 6,612,288 mysql_upgrade.exe
13/04/2019 06:57 6,264,128 my_print_defaults.exe
13/04/2019 06:57 6,969,664 perror.exe
01/04/2019 10:55 357,376 ssleay32.dll
13/04/2019 06:58 6,226,752 zlib_decompress.exe
36 File(s) 228,563,175 bytes
2 Dir(s) 912,449,863,680 bytes free
C:\Program Files\MySQL\MySQL Server 8.0\bin>dir *.ini
Volume in drive C is Windows
Volume Serial Number is 10EE-D40C
Directory of C:\Program Files\MySQL\MySQL Server 8.0\bin
File Not Found
C:\Program Files\MySQL\MySQL Server 8.0\bin>
[20 May 2019 16:46]
Tim Jones
Disregard :) These instructions are confusing.
[20 May 2019 16:50]
Tim Jones
OK, think I'm with you now :) Service wouldn't start: C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --standalone --console [warn] evsig_init_: socketpair: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. 2019-05-20T16:45:45.992243Z 0 [Warning] [MY-010915] [Server] '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. 2019-05-20T16:45:45.996814Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) starting as process 9668 2019-05-20T16:46:13.368498Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2019-05-20T16:46:13.532845Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL. 2019-05-20T16:46:13.549362Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
[21 May 2019 8:48]
MySQL Verification Team
Thank you for the feedback. This behavior is about your OS environment and not from the installer and server, doing a search you could find similar issue with others products.
[21 May 2019 8:59]
Tim Jones
Hi, So what might that be then? It's a brand new laptop. It sounds as if there's a pre-requisite that's required that isn't documented as part of your install. How do I find out what it needs? I've installed SQL Server just fine (probably have to use that now). What other products have similar behaviour? I'm not sure how I find out what those products are because I have no idea what my current issue even is other than it won't connect.
[21 May 2019 10:21]
MySQL Verification Team
When you ran the start server from command line you got: C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --standalone --console [warn] evsig_init_: socketpair: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. Then after that the server started: 2019-05-20T16:46:13.532845Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL. 2019-05-20T16:46:13.549362Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060 Try from administrator command line start the service, be sure not there is an instance of the server running: net start mysql_service_name (mysql80?)
[21 May 2019 10:33]
Tim Jones
Hi, many thanks for a quick reply! I get: C:\Program Files\MySQL\MySQL Server 8.0\bin>net start mysql80 The MySQL80 service is starting........ The MySQL80 service could not be started. More help is available by typing NET HELPMSG 3523. Help message not very helpful ha ha. C:\Program Files\MySQL\MySQL Server 8.0\bin>net helpmsg 3523 The *** service could not be started.
[21 May 2019 10:47]
MySQL Verification Team
Probably the error was printed in the err log file which you find on data directory host_name.err i.e:
c:\ProgramData\MySQL\MySQL Server 8.0\Data>dir *.err
Volume in drive C has no label.
Volume Serial Number is 6005-E7EC
Directory of c:\ProgramData\MySQL\MySQL Server 8.0\Data
05/21/2019 06:47 AM 5,386 URAL.err
1 File(s) 5,386 bytes
0 Dir(s) 58,378,227,712 bytes free
that was the reason asked you to run it as standalone.
[21 May 2019 10:55]
MySQL Verification Team
I forgot to ask you to check the Windows Event Viewer for errors.
[21 May 2019 10:55]
Tim Jones
It seems to have started? [warn] evsig_init_: socketpair: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. 2019-05-21T10:50:44.619419Z 0 [Warning] [MY-010915] [Server] '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. 2019-05-21T10:50:44.625985Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) starting as process 5428 2019-05-21T10:51:13.719337Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2019-05-21T10:51:14.150681Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL. 2019-05-21T10:51:14.281581Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060 When I ran it on command line, it timed out and errored but if I left it another 45 seconds, it did indeed start. Does that mean I can carry on with the instruction from a couple of days ago?
[21 May 2019 11:45]
Tim Jones
Hi, cleared down the event logs and tried again. Nothing appeared there.
[21 May 2019 11:50]
MySQL Verification Team
It seems to have started? <CUT> 2019-05-21T10:51:14.150681Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.16' socket: '' port: 3306 MySQL Community Server - GPL. However what about log error file and Windows Event viewer?
[21 May 2019 11:58]
Tim Jones
Hi, think our mails crossed wires. [21 May 10:55] Tim Jones --> Eventviewer didn't show up anything (stopped service, cleared logs and reran netstart) [21 May 10:55] Tim Jones --> that extract was from the *.err file.
[21 May 2019 12:13]
MySQL Verification Team
Well the issue here for me is that I couldn't repeat I did search and that error message I only found with people using Azure stuff, so I could suggest you, check firewall, anti-virus and then remove the current install cleaning all the directories of the current install and try to install again if the issue continues then try manual install.
[21 May 2019 14:38]
Tim Jones
OK, will do thanks. Really appreciate all of your help with this. Hopefully it will get sorted! Cheers.
[5 Nov 2020 13:27]
MySQL Verification Team
Bug #101404 marked as duplicate of this one.
[30 Dec 2020 18:42]
Luân Hoàng
Hi, When i run the start server from command line: C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --standalone --console I get: 2020-12-30T17:20:27.108265Z 0 [Warning] [MY-010915] [Server] 'N0_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. 2020-12-30T17:20:27.110266Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.22) starting as process 6244 2020-12-30T17:20:27.1422672 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-12-30T17:20:28.589350Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-12-30T17:20:30.912484Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060 2020-12-30T17:20:31.271503Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2020-12-30T17:20:31.276504Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2020-12-30T17:20:31.575521Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.22' socket: '' port: 3306 MySQL Comnunity Server - GPL. Nothing else happened Operating system which this laptop used is win7
[10 Jul 2022 3:42]
Devanshu Nalavade
Hi I'm having a similar problem and I ran the command line code, this is the output I get: mysqld: File '.\POSEIDON-bin.index' not found (OS errno 13 - Permission denied) 2022-07-10T03:39:41.503780Z 0 [Warning] [MY-010915] [Server] '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. 2022-07-10T03:39:41.505402Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.29) starting as process 8224 2022-07-10T03:39:41.510546Z 0 [ERROR] [MY-010119] [Server] Aborting 2022-07-10T03:39:41.510815Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.29) MySQL Community Server - GPL.
[10 Jul 2022 3:42]
Devanshu Nalavade
Hi I'm having a similar problem and I ran the command line code, this is the output I get: mysqld: File '.\POSEIDON-bin.index' not found (OS errno 13 - Permission denied) 2022-07-10T03:39:41.503780Z 0 [Warning] [MY-010915] [Server] '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. 2022-07-10T03:39:41.505402Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.29) starting as process 8224 2022-07-10T03:39:41.510546Z 0 [ERROR] [MY-010119] [Server] Aborting 2022-07-10T03:39:41.510815Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.29) MySQL Community Server - GPL.
Description: I have a brand new laptop running the exact same version of Windows as my other laptop (10.0.17134.706). Old laptop is about 18 months old so has lots of apps installed on it already and didn't get any issues when installing MySQL 8.0.16. On this new laptop, I have a few apps and as a result, have Visual C++ 2013; and Visual C++ 2015-2019 redistributables. I have disabled UAC so don't think it should be a permissions issue. I can ping localhost: Pinging DESKTOP-GGHPQ5U [::1] with 32 bytes of data: Reply from ::1: time<1ms Reply from ::1: time<1ms Reply from ::1: time<1ms Reply from ::1: time<1ms Ping statistics for ::1: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms It just simply won't install and can't find anything to fix this. Did find someone with the EXACT error (as per his log) but nobody had replied to it. Please see my log below. Many thanks! Tim 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) Deleting the data directory from a previous (failed) configuration... Attempting to run MySQL Server with --initialize-insecure option... Starting process for MySQL Server 8.0.16... 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... [warn] evsig_init_: socketpair: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. '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.16) initializing of server in progress as process 10056 root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.16) initializing of server has completed Process for mysqld, with ID 10056, was run successfully and exited with code 0. Successfully started process for MySQL Server 8.0.16. MySQL Server 8.0.16 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.16 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.16 after 10 attempts. Ended configuration step: Starting the server How to repeat: Run the install Suggested fix: No idea :(