MySQLcould not be started on latest Linux mint.

3 posts / 0 new
Last post
LA1RMA
MySQLcould not be started on latest Linux mint.

2023-04-23T08:58:08.240440Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-0ubuntu0.22.04.2) starting as process 12698
2023-04-23T08:58:08.241204Z 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-04-23T08:58:08.241211Z 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-04-23T08:58:08.251921Z 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: f795ff46-e1b4-11ed-a067-04d9f5f9fbf6.
2023-04-23T08:58:08.256767Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2023-04-23T08:58:08.256937Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-23T08:58:08.256950Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-23T08:58:08.257195Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-0ubuntu0.22.04.2) (Ubuntu).

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

So, how do I fix this ?

oh1kh
MySQLcould not be started on latest Linux mint.

Hi!
Reason shows up on your first line: [Server] /usr/sbin/mysqld (mysqld 8.0.32-0ubuntu0.22.04.2) starting

Cqrlog needs MariaDB if you are using the default log database base (in your home folder) that is "save log data to local machine"
install mariadb packages: server, client and compat
Installing them will remove mysql 8

You can use Mysql 8 if you use it without "save log data on local machine" and set sql server address as localhost, port 3306 (in Database connect window) and create sql user with password and privileges to create an modify databases and set that information also to database connect window.

--
Saku
OH1KH

LA1RMA
That fixed it! Thank you!

That fixed it! Thank you!