MySQL error

4 posts / 0 new
Last post
AE4WX
MySQL error

I'm unable to get CQRLOG to start due to a MySQL error. I am running Ubunti 22.04 LTS. Any thoughts? Tnx 73 de AE4WX

Here is the mysql.err file:

2024-03-30T13:13:12.170130Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 11688
2024-03-30T13:13:12.174064Z 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-03-30T13:13:12.174069Z 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-03-30T13:13:12.177218Z 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: 42b62c61-ee97-11ee-8fed-6c3c8cfda0f4.
2024-03-30T13:13:12.179879Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:13:12.179971Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:13:12.179982Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:13:12.180213Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-03-30T13:19:34.702089Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 12023
2024-03-30T13:19:34.703357Z 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-03-30T13:19:34.703365Z 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-03-30T13:19:34.708945Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:19:34.709053Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:19:34.709066Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:19:34.709314Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-03-30T13:20:44.037444Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 12311
2024-03-30T13:20:44.038341Z 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-03-30T13:20:44.038346Z 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-03-30T13:20:44.043431Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:20:44.043712Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:20:44.043726Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:20:44.043957Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-03-30T13:25:34.847326Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 13572
2024-03-30T13:25:34.847836Z 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-03-30T13:25:34.847841Z 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-03-30T13:25:34.852829Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-03-30T13:25:34.852948Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-30T13:25:34.852965Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-30T13:25:34.853180Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1)

oh1kh
MySQL error

2024-03-30T13:13:12.170130Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 11688

You have mysql and Cqrlog needs MariaDB.

You should install MaridB https://www.cqrlog.com/comment/8349#comment-8349

--
Saku
OH1KH

johnbabu
Adult Service Provider

We have girls from various backgrounds like air hostesses, models, actresses, housewives, college students and even Russians. Lucknow Escort Service have wide range of profiles, there is something for everyone at our directory. You can select the best escort based on your personal preferences.To cater to the sexual needs of menfrom diverse background, including the men from middle-class society.

Angel17
Nice

1. The user doesn't exist. Check if the user exists in the database, and if they don't, create a new user.
2. The password is incorrect. To fix this, reset the MySQL password.
3. Connecting to the wrong host. Double-check that the host you're connecting to is correct.

Must try this one ford dealer fort wayne