Mysql not started

4 posts / 0 new
Last post
f5idc
Mysql not started

Hello, since i've resinstalled my ubuntu, i can't start cqrlog. It said "mysql not started".
So i've search if mysql was ok installed > it's ok
i've search in mysql.err and it's writed this :
2023-05-31T10:49:02.666789Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.2) starting as process 24096
2023-05-31T10:49:02.688174Z 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.
2023-05-31T10:49:02.688181Z 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.
2023-05-31T10:49:02.744975Z 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: c1ab89c1-ffa0-11ed-8788-00016cd46b36.
2023-05-31T10:49:02.803009Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-05-31T10:49:02.803327Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-05-31T10:49:02.803415Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-31T10:49:02.805208Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.22.04.2) (Ubuntu).
2023-11-04T22:03:11.164891Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.22.04.1) starting as process 23029
2023-11-04T22:03:11.165579Z 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.
2023-11-04T22:03:11.165587Z 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.
2023-11-04T22:03:11.227895Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-11-04T22:03:11.228200Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-04T22:03:11.228259Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-04T22:03:11.229727Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.22.04.1) (Ubuntu).
2024-01-05T22:07:03.905932Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.22.04.1) starting as process 189476
2024-01-05T22:07:03.962116Z 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.
2024-01-05T22:07:03.962158Z 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.
2024-01-05T22:07:04.369176Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-01-05T22:07:04.374033Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-01-05T22:07:04.374097Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-05T22:07:04.376344Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.22.04.1) (Ubuntu).
2024-01-07T08:59:29.510008Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.22.04.1) starting as process 268698
2024-01-07T08:59:29.533544Z 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.
2024-01-07T08:59:29.533593Z 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.
2024-01-07T08:59:29.693789Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-01-07T08:59:29.694528Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-01-07T08:59:29.694595Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-07T08:59:29.727195Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.22.04.1) (Ubuntu).
2024-01-07T09:03:34.175483Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.22.04.1) starting as process 271428
2024-01-07T09:03:34.176445Z 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.
2024-01-07T09:03:34.176454Z 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.
2024-01-07T09:03:34.180442Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-01-07T09:03:34.180590Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-01-07T09:03:34.180603Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-07T09:03:34.180915Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.22.04.1) (Ubuntu).
2024-01-07T09:32:45.236225Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.22.04.1) starting as process 4486
2024-01-07T09:32:45.236932Z 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.
2024-01-07T09:32:45.236940Z 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.
2024-01-07T09:32:45.295400Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-01-07T09:32:45.295558Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-01-07T09:32:45.295580Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-07T09:32:45.296072Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.22.04.1) (Ubuntu).

What does it mean ? what can i do ?
Many thanks

oh1kh
Mysql not started

Hi!
Ubuntu installs mysql. It sould be Mariadb.
Install MariaDB and it replacec mysql.

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

--
Saku
OH1KH

f5idc
it work !

Many tks my friend, it start now !

Best 73

adamusa (not verified)
Nice

This is one of the best posts I've read on this forum. The information in the article helped me understand more about a new topic that I had never known. fnf