{REQ} Error start mysql
Posted by: AhrimanSefid (---.194.185.40.188.clients.your-server.de)
Date: November 19, 2022 01:12PM

Hi All.
can help for fixed Error:

wampmysqld64: Table 'mysql.plugin' doesn't exist
2022-11-19T12:02:22.427398Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2022-11-19T12:02:22.431437Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-11-19T12:02:22.441287Z 0 [Warning] Failed to open optimizer cost constant tables

2022-11-19T12:02:22.444140Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2022-11-19T12:02:22.446508Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2022-11-19T12:02:22.452147Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2022-11-19T12:07:56.591411Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2022-11-19T12:07:56.595469Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-11-19T12:07:56.603627Z 0 [Warning] Failed to open optimizer cost constant tables

2022-11-19T12:07:56.604567Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2022-11-19T12:07:56.605137Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2022-11-19T12:07:56.606692Z 0 [ERROR] Aborting

wampmysqld64: Table 'mysql.plugin' doesn't exist
2022-11-19T12:08:50.756601Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2022-11-19T12:08:50.757590Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-11-19T12:08:50.760194Z 0 [Warning] Failed to open optimizer cost constant tables

2022-11-19T12:08:50.760809Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2022-11-19T12:08:50.761260Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2022-11-19T12:08:50.763258Z 0 [ERROR] Aborting

Options: ReplyQuote
Re: {REQ} Error start mysql
Posted by: Otomatic (Moderator)
Date: November 19, 2022 02:17PM

Hi,

Please READ (and answer) BEFORE YOU ASK A QUESTION

It seems that some tables in the mysql database are corrupted or missing. See the MySQL documentation for repair procedures.

See also [forum.wampserver.com] --- Execute mysql_upgrade.exe ---

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.