Fresh install on Linux Mint 22 -

2 posts / 0 new
Last post
KI4IO
Fresh install on Linux Mint 22 -

failed - here are the last 20 lines or so
2024-08-31 8:24:30 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-08-31 8:24:30 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-08-31 8:24:30 0 [Note] Server socket created on IP: '::'.
2024-08-31 8:24:30 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-08-31 8:24:30 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-08-31 8:24:30 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB-0ubuntu0.22.04.1' socket: '/home/jerryw/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-08-31 8:24:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240831 8:24:30
2024-08-31 8:24:30 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-08-31 23:04:52 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-08-31 23:04:52 0 [Note] InnoDB: FTS optimize thread exiting.
2024-08-31 23:04:52 0 [Note] InnoDB: Starting shutdown...
2024-08-31 23:04:52 0 [Note] InnoDB: Dumping buffer pool(s) to /home/jerryw/.config/cqrlog/database/ib_buffer_pool
2024-08-31 23:04:52 0 [Note] InnoDB: Buffer pool(s) dump completed at 240831 23:04:52
2024-08-31 23:04:52 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-08-31 23:04:52 0 [Note] InnoDB: Shutdown completed; log sequence number 1919941352; transaction id 1118973
2024-08-31 23:04:52 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-09-14T15:58:15.483421Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39-0ubuntu0.24.04.2) starting as process 9344
2024-09-14T15:58:15.485424Z 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-09-14T15:58:15.485444Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-09-14T15:58:16.030574Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-09-14T15:58:16.030738Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-14T15:58:16.030750Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-14T15:58:16.031354Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39-0ubuntu0.24.04.2) (Ubuntu).

Jerry
KI4IO
Warrenton, VA

KI4IO
working

dug around in the posts and tried this:
sudo apt install cqrlog
then
sudo apt install mariadb-client mariadb-server

CQRlog is now working!

Thanks Mr. forum

Jerry
KI4IO