MySQL error on newly built machine

3 posts / 0 new
Last post
af7o
MySQL error on newly built machine

I'm working on replacing my hamshack machine with one a bit more capable. I have CQRLog running on the old box, and am quite happy with it.

installed a fresh copy of Mint 20 on the new box. I've used the synaptic tool to remove MariaDB and install MySQL per some of the other entries that I've found on these forums.

Upon launching CQRLog, I get the splash screen, then:
Error during connection to database
TMySQL57Connection: Server connect failed.

Per the next dialog, I am posting the last several lines of my mysql.err file

>>
2020-11-15T05:06:20.814952Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-0ubuntu0.20.04.2) starting as process 5672
2020-11-15T05:06:20.815612Z 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-11-15T05:06:20.815621Z 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-11-15T05:06:20.824140Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-11-15T05:06:20.824280Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-11-15T05:06:20.824329Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-11-15T05:06:20.824598Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-0ubuntu0.20.04.2) (Ubuntu).
2020-11-16T00:12:33.824604Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-0ubuntu0.20.04.2) starting as process 1634
2020-11-16T00:12:33.825634Z 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-11-16T00:12:33.825643Z 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-11-16T00:12:33.833507Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-11-16T00:12:33.833645Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-11-16T00:12:33.833709Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-11-16T00:12:33.833996Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-0ubuntu0.20.04.2) (Ubuntu).

<<

Thanks in advance,
de Dan, AF7O

oh1kh
MySQL error on newly built machine

Hi Dan !

Looks like you have done it now upside down.
Your error dump, as well what you said, you seem to have mysqls 8.0 instead of MariaDB.

Cqrlog does not run with mysqld 8.0.

I have made test install and upgrade cqrlog to latest version from source. You should try to follow that https://cqrlog.com/node/2998
You do not need to follow it to the end. Up to line "So far success!" is far enough if you do not want to try QT5 graphics version.

--
Saku
OH1KH

af7o
MySQL error on newly built machine

Saku--
Thanks for pointing me to that page. I wish I had seen it earlier. I'll give it a try and let you know my results.

Kiitos & 73

de Dan, AF7O