Installation of MySQL Server

2 posts / 0 new
Last post
Anonymous (not verified)
Installation of MySQL Server

I am new to Linux, so I will need specific directions on how to fix this.
I installed the Linux version (deb) which is running on Zorin and got an error message. DB problem. MySQL could not be started. Check to see if MYSQL server is installed properly.

The log files are;
2021-12-22T16:40:13.619207Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 47741
2021-12-22T16:40:13.620341Z 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-12-22T16:40:13.620351Z 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-12-22T16:40:13.639921Z 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: d6083743-6345-11ec-97f6-701ce742fe9b.
2021-12-22T16:40:13.686976Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-12-22T16:40:13.687206Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-12-22T16:40:13.687295Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-22T16:40:13.687934Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-22T16:41:30.797746Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 47773
2021-12-22T16:41:30.798467Z 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-12-22T16:41:30.798477Z 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-12-22T16:41:30.805338Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-12-22T16:41:30.805449Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-12-22T16:41:30.805493Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-22T16:41:30.805875Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-22T16:42:03.447411Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 47849
2021-12-22T16:42:03.448588Z 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-12-22T16:42:03.448604Z 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-12-22T16:42:03.458693Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-12-22T16:42:03.458842Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-12-22T16:42:03.458908Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-22T16:42:03.459490Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).

Thank you.
Rick KT4DG

oh1kh
Installation of MySQL Server

Hi Rick!

You have a cassic Ubuntu problem.
You have Mysql v8 and you should install MariaDB instead.

There are many threads about this topic in Forum. For example https://www.cqrlog.com/node/2439

--
Saku
OH1KH