MySQL Forums
Forum List  »  Install & Repo

Re: Correct parameters after changing password
Posted by: Hubert CANEVET
Date: March 02, 2021 01:01AM

Got the log !
My.ini includes Base-dir=D:\MySQL, and in D:\MySQL\Data, I find a file named as the machine with the err extension.

The most simple to be sure to cut at the good place was to attempt again to launch the service, then the log ends like this :

2021-03-02T05:03:22.269272Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32428838ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2021-03-02T05:42:14.587738Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 354674ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2021-03-02T06:52:18.219298Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-03-02T06:52:18.220130Z 0 [Warning] '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.
2021-03-02T06:52:18.220158Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-03-02T06:52:18.222987Z 0 [ERROR] Cannot open Windows EventLog; check privileges, or start server with --log_syslog=0
2021-03-02T06:52:18.223007Z 0 [Note] mysqld (mysqld 5.7.21) starting as process 3656 ...
2021-03-02T06:52:18.791111Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-02T06:52:18.791891Z 0 [Note] InnoDB: Uses event mutexes
2021-03-02T06:52:18.792371Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2021-03-02T06:52:18.793588Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-03-02T06:52:18.798764Z 0 [Note] InnoDB: Number of pools: 1
2021-03-02T06:52:18.804248Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2021-03-02T06:52:18.811228Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-03-02T06:52:18.821091Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-02T06:52:18.837429Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2021-03-02T06:52:18.838068Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2021-03-02T06:52:18.838676Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-03-02T06:52:19.041114Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-03-02T06:52:19.041768Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-03-02T06:52:19.042474Z 0 [ERROR] Failed to initialize builtin plugins.
2021-03-02T06:52:19.043033Z 0 [ERROR] Aborting

2021-03-02T06:52:19.043398Z 0 [Note] Binlog end
2021-03-02T06:52:19.052804Z 0 [Note] Shutting down plugin 'CSV'
2021-03-02T06:52:19.059474Z 0 [Note] mysqld: Shutdown complete

Options: ReplyQuote


Subject
Written By
Posted
Re: Correct parameters after changing password
March 02, 2021 01:01AM


Sorry, only registered users may post in this forum.

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.