Thanks for the suggestion. I did indeed find mention of mysql_upgrade, so followed the instructions in the linked post. When I loaded the MSQL container, it output this:
bash-4.2# 2026-02-09T13:07:27.163061Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2026-02-09T13:07:27.165673Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 8 …
2026-02-09T13:07:27.172160Z 0 [Note] InnoDB: PUNCH HOLE support available
2026-02-09T13:07:27.172391Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2026-02-09T13:07:27.172409Z 0 [Note] InnoDB: Uses event mutexes
2026-02-09T13:07:27.172420Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2026-02-09T13:07:27.172428Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2026-02-09T13:07:27.172436Z 0 [Note] InnoDB: Using Linux native AIO
2026-02-09T13:07:27.172938Z 0 [Note] InnoDB: Number of pools: 1
2026-02-09T13:07:27.173113Z 0 [Note] InnoDB: Using CPU crc32 instructions
2026-02-09T13:07:27.175692Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2026-02-09T13:07:27.188161Z 0 [Note] InnoDB: Completed initialization of buffer pool
2026-02-09T13:07:27.191314Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2026-02-09T13:07:27.210272Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2026-02-09T13:07:27.261855Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2026-02-09T13:07:27.261969Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2026-02-09T13:07:27.285678Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2026-02-09T13:07:27.287081Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2026-02-09T13:07:27.287105Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2026-02-09T13:07:27.288858Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 50143800538
2026-02-09T13:07:27.289533Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2026-02-09T13:07:27.290457Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2026-02-09T13:07:27.299182Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table ‘mysql.gtid_executed’ doesn’t exist
2026-02-09T13:07:27.299276Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2026-02-09T13:07:27.302565Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2026-02-09T13:07:27.302582Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2026-02-09T13:07:27.302616Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2026-02-09T13:07:27.302628Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2026-02-09T13:07:27.303585Z 0 [ERROR] SSL error: Unable to get private key from ‘server-key.pem’
2026-02-09T13:07:27.303722Z 0 [Warning] Failed to set up SSL because of the following SSL library error: Unable to get private key
2026-02-09T13:07:27.303877Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2026-02-09T13:07:27.305593Z 0 [Note] Server hostname (bind-address): ‘*’; port: 3306
2026-02-09T13:07:27.305637Z 0 [Note] IPv6 is available.
2026-02-09T13:07:27.305736Z 0 [Note] - ‘::’ resolves to ‘::’;
2026-02-09T13:07:27.305777Z 0 [Note] Server socket created on IP: ‘::’.
2026-02-09T13:07:27.309299Z 0 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
2026-02-09T13:07:27.309918Z 0 [Warning] InnoDB: Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2026-02-09T13:07:27.309944Z 0 [Warning] Failed to open optimizer cost constant tables
2026-02-09T13:07:27.312410Z 0 [Warning] System table ‘time_zone_leap_second’ is expected to be transactional.
2026-02-09T13:07:27.312425Z 0 [Warning] System table ‘time_zone_name’ is expected to be transactional.
2026-02-09T13:07:27.312433Z 0 [Warning] System table ‘time_zone’ is expected to be transactional.
2026-02-09T13:07:27.312442Z 0 [Warning] System table ‘time_zone_transition_type’ is expected to be transactional.
2026-02-09T13:07:27.312451Z 0 [Warning] System table ‘time_zone_transition’ is expected to be transactional.
2026-02-09T13:07:27.312987Z 0 [Warning] System table ‘servers’ is expected to be transactional.
2026-02-09T13:07:27.316783Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column ‘NESTING_EVENT_TYPE’ at position 15 to have type enum(‘TRANSACTION’,‘STATEMENT’,‘STAGE’,‘WAIT’, found type enum(‘STATEMENT’,‘STAGE’,‘WAIT’).
2026-02-09T13:07:27.317138Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column ‘NESTING_EVENT_TYPE’ at position 15 to have type enum(‘TRANSACTION’,‘STATEMENT’,‘STAGE’,‘WAIT’, found type enum(‘STATEMENT’,‘STAGE’,‘WAIT’).
2026-02-09T13:07:27.317499Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column ‘NESTING_EVENT_TYPE’ at position 15 to have type enum(‘TRANSACTION’,‘STATEMENT’,‘STAGE’,‘WAIT’, found type enum(‘STATEMENT’,‘STAGE’,‘WAIT’).
2026-02-09T13:07:27.318939Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_user_by_event_name: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.319530Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_account_by_event_name: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.322978Z 0 [ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.323953Z 0 [ERROR] Incorrect definition of table performance_schema.setup_objects: expected column ‘OBJECT_TYPE’ at position 0 to have type enum(‘EVENT’,‘FUNCTION’,‘PROCEDURE’,‘TABLE’,‘TRIGGER’, found type enum(‘TABLE’).
2026-02-09T13:07:27.325521Z 0 [ERROR] Column count of performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68, found 73. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.325862Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.326221Z 0 [ERROR] Column count of performance_schema.events_stages_current is wrong. Expected 12, found 10. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.326644Z 0 [ERROR] Column count of performance_schema.events_stages_history is wrong. Expected 12, found 10. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.327041Z 0 [ERROR] Column count of performance_schema.events_stages_history_long is wrong. Expected 12, found 10. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.327837Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_account_by_event_name: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.328214Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_user_by_event_name: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.329189Z 0 [ERROR] Column count of performance_schema.events_statements_current is wrong. Expected 41, found 40. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.329583Z 0 [ERROR] Column count of performance_schema.events_statements_history is wrong. Expected 41, found 40. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.329983Z 0 [ERROR] Column count of performance_schema.events_statements_history_long is wrong. Expected 41, found 40. Created with MySQL 50645, now running 50744. Please use mysql_upgrade to fix this error.
2026-02-09T13:07:27.330663Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_account_by_event_name: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.331006Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_user_by_event_name: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.335867Z 0 [ERROR] Incorrect definition of table performance_schema.users: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.336354Z 0 [ERROR] Incorrect definition of table performance_schema.accounts: expected column ‘USER’ at position 0 to have type char(32), found type char(16).
2026-02-09T13:07:27.351307Z 0 [Note] mysqld: ready for connections.
Version: ‘5.7.44’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
2026-02-09T13:07:27.537662Z 0 [Note] InnoDB: Buffer pool(s) load completed at 260209 13:07:27
Then when I ran the mysql_upgrade command, it said this:
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
2026-02-09T13:08:54.795733Z 2 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to ``http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html`` for how to resolve the issue.
mysql_upgrade: [ERROR] 1146: Table ‘mysql.gtid_executed’ doesn’t exist
I had a look at the listed URL, but none of it seemed useful.
As an aside, before I brought the container down to try the mysql_upgrade, I noticed that a lot of the medi in the library was displaying as a black rectangle with a red cross in a circle. I am wondering if this could be a permissions issue from me restoring the backup I made. Do you know what permissions are supposed to be for the folders/files in the main /opt/xibo folder?