MySQL Forums
Forum List  »  Install & Repo

Re: Connect Error
Posted by: David Jones
Date: August 20, 2020 08:50AM

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.

Options: ReplyQuote


Subject
Written By
Posted
August 19, 2020 04:11PM
August 19, 2020 06:46PM
Re: Connect Error
August 20, 2020 08:50AM
August 20, 2020 09:18AM
August 20, 2020 11:11AM
August 20, 2020 11:16AM
August 20, 2020 12:00PM
August 20, 2020 05:13PM
August 21, 2020 12:44PM
August 20, 2020 02:06PM


Sorry, you can't reply to this topic. It has been closed.

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.