Mysql cannot find a valid data directory.

2 posts / 0 new
Last post
LA1RMA
Mysql cannot find a valid data directory.

2021-10-13T11:39:17.744391Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.21.04.3) starting as process 3184
2021-10-13T11:39:17.747824Z 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.
2021-10-13T11:39:17.747830Z 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.
2021-10-13T11:39:17.755876Z 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: 32f850d7-2c1a-11ec-9117-04d9f5f9fbf6.
2021-10-13T11:39:17.763226Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-10-13T11:39:17.763466Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-10-13T11:39:17.763531Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-10-13T11:39:17.764594Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.21.04.3) (Ubuntu).
2021-10-13T11:47:10.343127Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.21.04.3) starting as process 6817
2021-10-13T11:47:10.343728Z 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.
2021-10-13T11:47:10.343733Z 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.
2021-10-13T11:47:10.354044Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-10-13T11:47:10.354281Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-10-13T11:47:10.354338Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-10-13T11:47:10.354627Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.21.04.3) (Ubuntu).
2021-10-13T11:49:19.550976Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.21.04.3) starting as process 7044
2021-10-13T11:49:19.551575Z 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.
2021-10-13T11:49:19.551580Z 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.
2021-10-13T11:49:19.561894Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-10-13T11:49:19.562135Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-10-13T11:49:19.562193Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-10-13T11:49:19.562463Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.21.04.3) (Ubuntu).

How do I fix this ?
I a running the latest Ubuntu Budgie

oh1kh
Mysql cannot find a valid data directory.

Hej!

It seems that you are running mysql 8.0 I think that is default with Ubuntu.
You should install MariaDB instead.

Installing MariaDB will remove mysql8.0 and after that cqrlog should work ok.

There are many threads about it. Here is one https://www.cqrlog.com/node/3202

--
Saku
OH1KH