Re: Connect Error
Peter,
Thanks for your help.
Please bear with me, I’m still going up the learning curve.
I hope I found the error log. I’ll paste the lines from the last day or so when the problem began. Before I do that, let me mention some other symptoms.
One of the things I tried was to uninstall and then reinstall. I may not have completed that process.
When I run MySQL Installer, the “Quick Action” column is mostly empty. However, in the MySQL Server row, there is a hot-link that says “Reconfigure”. If I click that link and start the process, I can only get as far as the Accounts and Roles page. When I put in my password and click the “Check” button, there is an X. If I hover the mouse pointer over the X there is a message that says:
“MySQL server is not running, a connection cannot be established”.
I can’t go any farther and I can’t complete the process.
Also, if I open MySQL Workbench and open “Manage Server Connections” then click the “Test Connection” button, a popup message box has this:
Failed to Connect to MySQL at 127.0.0.1:3306 with user root
If I then click the “Local instance MySQL80” button, MySQL opens but there is no connection.
Could the problem be that MySQL is not connecting to the port? How do I correct that?
Here is the last day or so of the error log:
2020-08-19T21:20:39.196498Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-08-19T21:20:39.197791Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-08-19T21:20:39.199063Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-08-19T21:20:39.200113Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-08-19T21:20:39.201456Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL.
2020-08-19T21:49:50.363753Z 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.
2020-08-19T21:49:50.366355Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.21) starting as process 2908
2020-08-19T21:49:50.387454Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-08-19T21:49:50.419974Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2020-08-19T21:49:50.421013Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 50 = ['jonesoklahomacemetery - Copy\tblcemeteryplots.ibd', 'jonesoklahomacemetery\tblcemeteryplots.ibd']
2020-08-19T21:49:50.422623Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-08-19T21:49:50.423904Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-08-19T21:49:50.425132Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-08-19T21:49:50.426181Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-08-19T21:49:50.427563Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL.
2020-08-20T11:49:17.010675Z 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.
2020-08-20T11:49:17.013697Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.21) starting as process 12788
2020-08-20T11:49:17.079734Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-08-20T11:49:17.143046Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2020-08-20T11:49:17.144063Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 50 = ['jonesoklahomacemetery - Copy\tblcemeteryplots.ibd', 'jonesoklahomacemetery\tblcemeteryplots.ibd']
2020-08-20T11:49:17.145659Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-08-20T11:49:17.147259Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-08-20T11:49:17.148655Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-08-20T11:49:17.149658Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-08-20T11:49:17.156138Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL.