Problems upgrading to mysql 8.4 from 5.7

From: Pamela Ballantyne <boyvalue_at_gmail.com>
Date: Sun, 11 Aug 2024 21:56:41 UTC
I've just upgraded from the latest patch level of FreeBSD 12 to 13.3-p5.
The only problem so far has been the MySQL upgrade.  I didn't find any
detailed instructions, I did vet the existing 5.7 db files as instructed on
the
MySQL site. Some instructions said to do a binary upgrade and start
the MySQL server, which would upgrade the DB files.

That's not happening.

The upgrade process deleted 5.7. I used pkg to get mysql84.

service mysql-server start

The error log leaves a message about not being able to open mysql.ibd,
which doesn't exist
and I guess never has.

Any help most urgently requested.
Thanks!
Pam

Here's the logfile:

2024-08-11T21:44:30.6NZ mysqld_safe Logging to
'/var/db/mysql/ns.ssr.com.err'.
2024-08-11T21:44:30.6NZ mysqld_safe Starting mysqld daemon with databases
from /var/db/mysql
2024-08-11T21:44:30.688377Z 0 [System] [MY-015015] [Server] MySQL Server -
start.
2024-08-11T21:44:30.899150Z 0 [Warning] [MY-010097] [Server] Insecure
configuration for --secure-file-priv: Current value does not restrict
location of generated files. Consider setting it to a valid, non-empty path.
2024-08-11T21:44:30.899204Z 0 [System] [MY-010116] [Server]
/usr/local/libexec/mysqld (mysqld 8.4.0) starting as process 7738
2024-08-11T21:44:30.944078Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2024-08-11T21:44:31.708765Z 1 [ERROR] [MY-012592] [InnoDB] Operating system
error number 2 in a file operation.
2024-08-11T21:44:31.708803Z 1 [ERROR] [MY-012593] [InnoDB] The error means
the system cannot find the path specified.
2024-08-11T21:44:31.708823Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open
datafile for read-only: 'mysql.ibd' OS error: 71
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2024-08-11T21:44:31.764666Z 1 [ERROR] [MY-010334] [Server] Failed to
initialize DD Storage Engine
2024-08-11T21:44:31.764879Z 0 [ERROR] [MY-010020] [Server] Data Dictionary
initialization failed.
2024-08-11T21:44:31.764911Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-11T21:44:31.766104Z 0 [System] [MY-010910] [Server]
/usr/local/libexec/mysqld: Shutdown complete (mysqld 8.4.0)  Source
distribution.
2024-08-11T21:44:31.766134Z 0 [System] [MY-015016] [Server] MySQL Server -
end.
2024-08-11T21:44:31.6NZ mysqld_safe mysqld from pid file
/var/db/mysql/ns.ssr.com.pid ended