i just started rebuilding my files after a total PC crash. installed CQRlog but it will not run
need some help......
error file shows:
2021-07-21T15:50:27.993724Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 8511
2021-07-21T15:50:27.994586Z 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-07-21T15:50:27.994593Z 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-07-21T15:50:27.999393Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-21T15:50:27.999530Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-21T15:50:27.999569Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-21T15:50:27.999879Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).
2021-07-27T21:14:28.394940Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) starting as process 4621
2021-07-27T21:14:28.395963Z 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-07-27T21:14:28.395969Z 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-07-27T21:14:28.399963Z 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: a0b25813-ef1f-11eb-b53b-18473d09043d.
2021-07-27T21:14:28.402868Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-27T21:14:28.402962Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-27T21:14:28.403009Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-27T21:14:28.403277Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.20.04.2) (Ubuntu).
2021-07-27T21:17:29.814813Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) starting as process 4979
2021-07-27T21:17:29.815438Z 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-07-27T21:17:29.815444Z 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-07-27T21:17:29.824641Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-27T21:17:29.824768Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-27T21:17:29.824808Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-27T21:17:29.825122Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.20.04.2) (Ubuntu).
Tue, 2021-07-27 22:37
#1
new install will not run
HI!
It shows up that you are running mysql 8.0
Cqrlog does not run with that. You should install MariaDB server instead.
Try something like:
sudo apt-get install mariadb-client-10.3 mariadb-server-10.3 libmariadb3 libmariadb-dev-compat
Installing mariadb should remove mysql 8.0
--
Saku
OH1KH
- What distro are you using?
- How did you install this (including version pls)
otherwise the only thing we can say is what Saku just said.