MySQL startup problem

2 posts / 0 new
Last post
9H1ZZ
MySQL startup problem

Help please!
Just installed a new Mint 20 and then, with synaptic, installed the most recent CQRLOG 2.4.0-3.
On starting CQRLOG, I get the message:
MySQL could not be started.
The Database connection panel appears... I tried the button 'Connect'.... no change. I tried ticking 'Save log data to local machine', again no change.
The mysql.err shows the following:

2020-10-09T13:03:51.488211Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 14831
2020-10-09T13:03:51.489371Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-10-09T13:03:51.489385Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-10-09T13:03:51.501960Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-10-09T13:03:51.502191Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-10-09T13:03:51.502286Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-10-09T13:03:51.502870Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-10-09T13:09:25.944434Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 14891
2020-10-09T13:09:25.945567Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-10-09T13:09:25.945581Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-10-09T13:09:25.957930Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-10-09T13:09:25.958174Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-10-09T13:09:25.958278Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-10-09T13:09:25.958873Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).

The error message panel recommends sending the above messages to this Forum for assistance.

Thanks .

Robin, 9H1ZZ

9H1ZZ
RESOLVED - MySQL startup

Tried uninstalling / reinstalling CQRLOG - no change.
Finally cured it by re-installing (yet again) the OS - Mint 20.