"Plug-in Table Does Not Exist" Error During MySQL Startup

Asked 2 years ago, Updated 2 years ago, 43 views

My name is toshimizu, and I am a super beginner in programming.

I just asked a similar question and got an answer, but I ran into another error again, so I would like to ask you a question again.Please forgive me for being a beginner.

I tried to deploy MySQL on my PC, but when I tried to install and boot MySQL, I got errors like "mysql plugin table does not exist" or "upgrade".
I don't even know where to make a plug-in table, even though it's OK to make a plug-
Does anyone know the cause or solution?

The steps I took are as follows.

(1) Download "Windows (x86, 64-bit), ZIP Archive" from MySQL site (https://dev.mysql.com/downloads/mysql/).

(2) Create a folder dedicated to MySQL on the D drive of the PC and expand the zip file inside the folder

(3) Create "data", "logs", "temp" and "mydata" folders in the folder, create "my.ini" files, copy paste the code in the reference article, and edit it to fit your PC environment.

(4) Launched the command prompt in administrator mode. Go to the folder where MySQL is installed and initialize MySQL with the following commands.

bin\mysqld --initialize-insecure --user=mysql

(5) Attempted to launch MySQL with the following command:

bin\mysqld --defaults-file=".\my.ini" -- console

The following error message appears:

 2019-11-28T 12:30:53.235246Z 0 [System] [MY-010116] [Server] 
D:\myplace\01_server\mysql\bin\mysqld.exe (mysqld8.0.18) starting as process 2256
mysqld —Table'mysql.plugin' doesn't exist
2019-11-28 T12:30:54.505401Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugintable.Please perform the MySQL upgrade procedure.
2019-11-28 T12:30:54.580612Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-11-28 T12:30:54.758654Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-11-28 T12:30:54.789074Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-11-28 T12:30:54.793681Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2019-11-28 T12:30:54.795536Z0 [ERROR] [MY-013129] [Server] A message extended for a client cannot be sent there as no client-session is attached.Therefore, we're sending the information to the error-log installed: MY-001146-Table'mysql.component'doesn't exist
2019-11-28 T12:30:54.798796Z0 [Warning] [MY-013129] [Server] A message extended for a client cannot be sent there as no client-session is attached.Therefore, we're sending the information to the error-log installed: MY-003543-The mysql.component table is missing or has an incorrect definition.
2019-11-28 T12:30:54.803699Z 0 [ERROR] [MY-010326] [Server] fatal error:Can't open and lock privilege tables:Table'mysql.user'doesn't exist
2019-11-28 T12:30:54.805593Z0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2019-11-28 T12:30:54.810116Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-11-28 T12:30:55.747382Z 0 [System] [MY-010910] [Server] D:\myplace\01_server\mysql\bin\mysqld.exe: Shutdown complete (mysqld8.0.18) MySQL Community Server - GPL.

When installing MySQL, refer to the following articles:

How do I install and launch MySQL for zip in Windows 10?Qiita

To determine the cause, we tried the following tests, but the problem was not resolved.

(a)

 2019-11-28T 12:30:53.235246Z 0 [System] [MY-010116] [Server] D:\myplace\01_server\mysql\bin\mysqld.exe (mysqld8.0.18) starting as process 2256
mysqld —Table'mysql.plugin' doesn't exist

It said "mysql plugin does not exist", so I thought I should edit the file mysqld.exe, but it disappears as soon as I open it.

(b)

 2019-11-28T 12:30:54.505401Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugintable.Please perform the MySQL upgrade procedure.

"Please follow the steps to upgrade MySQL" and I looked into the relevant information, but I couldn't solve it with my own understanding.

By the way, when I tried to install MySQL, I was referring to various articles on the Internet, but before I followed the Qiita article above, I tried to install MySQL in a different way, but it didn't work, so I'm trying to do it now.

Therefore, the PC download file (Drive C) is as follows:

mysql-8.0.18-winx64.zip (← The zip file from which the MySQL file you are currently working)
mysql-installer-web-community-8.0.18.0(1)
mysql-installer-web-community-8.0.18.0 (←installer who gave up trying to install before)

I wonder if this has any effect.I would appreciate it if you could point it out.

My environment is as follows.
[PC: Inspiron 3471, Memory: 8GB, OS: Windows 10 Home (64-bit)]

Also, how can we solve these problems when we encounter it?I would appreciate it if you could let me know.
Again, I apologize for the rudimentary question, but I appreciate your cooperation.

mysql

2022-09-30 15:02

1 Answers

I was able to solve myself.
Thank you for your cooperation.


2022-09-30 15:02

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.