'Mysql could not be started' message

5 posts / 0 new
Last post
kc2grn
'Mysql could not be started' message

Have it installed, but keep getting this message error.
Any help most appreciated.
Joel

2025-03-13T16:07:35.085993Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-03-13T16:07:35.098432Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 46da4064-0025-11f0-916b-9c305b356e9b.
2025-03-13T16:07:35.110768Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-03-13T16:07:35.110899Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-03-13T16:07:35.110911Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-03-13T16:07:35.111245Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).
2025-03-13T16:08:30.336866Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.24.04.1) starting as process 23896
2025-03-13T16:08:30.337703Z 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.
2025-03-13T16:08:30.337712Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-03-13T16:08:30.345445Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-03-13T16:08:30.345593Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-03-13T16:08:30.345606Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-03-13T16:08:30.345926Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).
2025-04-17T15:05:26.190747Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.24.04.1) starting as process 47952
2025-04-17T15:05:26.191516Z 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.
2025-04-17T15:05:26.191525Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-04-17T15:05:26.232255Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-04-17T15:05:26.232386Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-04-17T15:05:26.232401Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-04-17T15:05:26.232786Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).
2025-04-17T15:10:04.021050Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.24.04.1) starting as process 48304
2025-04-17T15:10:04.021818Z 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.
2025-04-17T15:10:04.021826Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-04-17T15:10:04.029853Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-04-17T15:10:04.029952Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-04-17T15:10:04.029968Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-04-17T15:10:04.030397Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).
2025-04-17T15:34:07.290044Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.24.04.1) starting as process 50648
2025-04-17T15:34:07.290840Z 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.
2025-04-17T15:34:07.290849Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-04-17T15:34:07.298695Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-04-17T15:34:07.298806Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-04-17T15:34:07.298820Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-04-17T15:34:07.299157Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).

oh1kh
'Mysql could not be started' message

Hi Joel!

You have to replace Mysql (mysqld 8.0.41-0ubuntu0.24.04.1) With MariaDB

sudo apt-get install mariadb-client-10.3 mariadb-server-10.3 libmariadb3 libssl-dev

--
Saku
OH1KH

kc2grn
"Mysql could not be started'

Thank you Saku. I did that and this was returned:

"Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package mariadb-client-10.3 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
mariadb-client

Package mariadb-server-10.3 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
mariadb-server-core mariadb-server mariadb-client

E: Package 'mariadb-client-10.3' has no installation candidate
E: Package 'mariadb-server-10.3' has no installation candidate"

Then I did the following per the suggested action:

Sudo apt-get install mariadb-server-core mariadb-server mariadb-client

Ran CQRLog and now get this error message box:

"Error during connection to database: TMySQL57Connection : Server connect failed."

Joel
KC2GRN

oh1kh
"Mysql could not be started'

HI Joel!

Maybe those refer to old packets as message was very old where I copied that. I am a Fedora user and do not know what are package names currently with Ubuntu.
I try to dig out.....

sudo apt install mariadb-client mariadb-server mariadb-common

Those should do it with Ubuntu 2204.

They are copied from script I have in my GitHub
https://github.com/OH1KH/CqrlogAlpha/tree/main/compiled

where I have full Cqrlog install script for Ubuntu 2204.
https://github.com/OH1KH/CqrlogAlpha/blob/main/compiled/install_Ubuntu22...

Perhaps those could help you forward.

--
Saku
OH1KH

kc2grn
"Myqsl could not be started"

Saku,
Thank you for the information. I'll give it a try and see what happens!
73, Joel