Looks like mysql_install_db was run as root.

Change the ownership to the mysql user and the service should start ok.

chown -R mysql: /var/lib/mysql

On Sat, Dec 31, 2022 at 9:05 AM Tim McConnell <tmcconnell168@gmail.com> wrote:
Hi Guilaume,
>From journalctl :
2022-12-30 14:23:01 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:23:01 0 [ERROR] /usr/sbin/mariadbd: unknown option '--
print-defaults'
2022-12-30 14:23:01 0 [ERROR] Aborting
2022-12-30 14:30:11 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:30:11 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:34:42 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:34:42 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:34:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:34:42 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:34:42 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:34:42 0 [Note] InnoDB: Using liburing
2022-12-30 14:34:42 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:34:42 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:34:42 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:34:42 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:34:42 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:34:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:34:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:34:42 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43100; transaction id 15
2022-12-30 14:34:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:34:42 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:34:42 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:34:42 0 [Note] InnoDB: Cannot open
'/var/lib/mysql/ib_buffer_pool' for reading: Permission denied
2022-12-30 14:34:42 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:34:42 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:34:42 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-12-30 14:34:42 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:34:42 0 [ERROR] Aborting
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:34:42 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:34:42 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:34:42 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
Warning: Memory not freed: 280
2022-12-30 14:35:15 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:35:15 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:35:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:35:15 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:35:15 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:35:15 0 [Note] InnoDB: Using liburing
2022-12-30 14:35:15 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:35:15 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:35:15 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:15 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:35:15 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:35:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:35:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:35:15 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43112; transaction id 15
2022-12-30 14:35:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:35:15 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:35:15 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:35:15 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:35:15
2022-12-30 14:35:15 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:15 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:15 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:15 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:15 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:15 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:35:15 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:35:15 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:35:15 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:35:15 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:35:16 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:35:16 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:35:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:35:16 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:35:16 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:35:16 0 [Note] InnoDB: Using liburing
2022-12-30 14:35:16 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:35:16 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:35:16 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:35:16 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:35:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:35:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:35:16 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43124; transaction id 15
2022-12-30 14:35:16 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:35:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:35:16 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:35:16 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:35:16
2022-12-30 14:35:16 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:35:16 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:35:16 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:35:16 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:35:16 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:35:16 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:35:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:35:16 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:35:16 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:35:16 0 [Note] InnoDB: Using liburing
2022-12-30 14:35:16 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:35:16 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:35:16 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:35:16 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:35:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:35:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:35:16 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43136; transaction id 15
2022-12-30 14:35:16 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:35:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:35:16 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:35:16 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:35:16
2022-12-30 14:35:16 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:35:16 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:35:16 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:16 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:16 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:16 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:16 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:35:16 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:35:17 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:35:17 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:35:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:35:17 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:35:17 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:35:17 0 [Note] InnoDB: Using liburing
2022-12-30 14:35:17 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:35:17 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:35:17 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:35:17 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:35:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:35:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:35:17 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43148; transaction id 15
2022-12-30 14:35:17 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:35:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:35:17 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:35:17 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:35:17
2022-12-30 14:35:17 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:35:17 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:35:17 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:35:17 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:35:17 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:35:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:35:17 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:35:17 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:35:17 0 [Note] InnoDB: Using liburing
2022-12-30 14:35:17 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:35:17 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:35:17 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:35:17 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:35:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:35:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:35:17 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43160; transaction id 15
2022-12-30 14:35:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:35:17 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:35:17 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:35:17 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:35:17
2022-12-30 14:35:17 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:35:17 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:35:17 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:35:17 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:35:17 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:35:17 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:35:17 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:35:17 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:48:21 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:48:21 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:48:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:48:21 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:48:21 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:48:21 0 [Note] InnoDB: Using liburing
2022-12-30 14:48:21 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:48:21 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:48:21 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:48:21 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:48:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:48:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:48:21 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43172; transaction id 15
2022-12-30 14:48:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:48:21 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:48:21 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:48:21 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:48:21
2022-12-30 14:48:21 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:48:21 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:48:21 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:48:21 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:48:21 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:48:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:48:21 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:48:21 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:48:21 0 [Note] InnoDB: Using liburing
2022-12-30 14:48:21 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:48:21 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:48:21 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:48:21 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:48:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:48:21 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:48:21 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43184; transaction id 15
2022-12-30 14:48:21 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:48:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:48:21 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:48:21 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:48:21
2022-12-30 14:48:21 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:21 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:21 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:21 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:21 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:48:21 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:48:21 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:48:21 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:48:22 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:48:22 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:48:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:48:22 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:48:22 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:48:22 0 [Note] InnoDB: Using liburing
2022-12-30 14:48:22 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:48:22 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:48:22 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:48:22 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:48:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:48:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:48:22 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43196; transaction id 15
2022-12-30 14:48:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:48:22 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:48:22 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:48:22 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:48:22 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:48:22 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:48:22 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:48:22 0 [ERROR] Aborting
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
Warning: Memory not freed: 280
2022-12-30 14:48:22 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:48:22 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:48:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:48:22 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:48:22 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:48:22 0 [Note] InnoDB: Using liburing
2022-12-30 14:48:22 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:48:22 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:48:22 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:48:22 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:48:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:48:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:48:22 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43208; transaction id 15
2022-12-30 14:48:22 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:48:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:48:22 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:48:22 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:48:22
2022-12-30 14:48:22 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:48:22 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:48:22 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:22 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:22 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:22 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:22 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:48:22 0 [ERROR] Aborting
Warning: Memory not freed: 280
2022-12-30 14:48:23 0 [Warning] Plugin 'OQGRAPH' is of maturity level
gamma while the server is stable
2022-12-30 14:48:23 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021
2022-12-30 14:48:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2022-12-30 14:48:23 0 [Note] InnoDB: Number of pools: 1
2022-12-30 14:48:23 0 [Note] InnoDB: Using crc32 + pclmulqdq
instructions
2022-12-30 14:48:23 0 [Note] InnoDB: Using liburing
2022-12-30 14:48:23 0 [Note] InnoDB: Initializing buffer pool, total
size = 134217728, chunk size = 134217728
2022-12-30 14:48:23 0 [Note] InnoDB: Completed initialization of buffer
pool
2022-12-30 14:48:23 0 [Note] InnoDB: 128 rollback segments are active.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/gtid_slave_pos.ibd' OS error: 81
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/gtid_slave_pos. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for
mysql/gtid_slave_pos because it could not be opened.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_index_stats because it could not be opened.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for
mysql/innodb_table_stats because it could not be opened.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/transaction_registry.ibd' OS error: 81
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/transaction_registry. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:23 0 [Warning] InnoDB: Ignoring tablespace for
mysql/transaction_registry because it could not be opened.
2022-12-30 14:48:23 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-12-30 14:48:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
2022-12-30 14:48:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-30 14:48:23 0 [Note] InnoDB: 10.6.11 started; log sequence
number 43220; transaction id 15
2022-12-30 14:48:23 0 [Note] InnoDB: Loading buffer pool(s) from
/var/lib/mysql/ib_buffer_pool
2022-12-30 14:48:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-12-30 14:48:23 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-12-30 14:48:23 0 [Note] InnoDB: Buffer pool(s) load completed at
221230 14:48:23
2022-12-30 14:48:23 0 [Warning] You need to use --log-bin to make --
expire-logs-days or --binlog-expire-logs-seconds work.
2022-12-30 14:48:23 0 [ERROR] Can't open and lock privilege tables:
Table 'mysql.servers' doesn't exist
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_table_stats.ibd' OS error: 81
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_table_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:23 0 [Note] Using systemd activated socket host ::
port 3306
2022-12-30 14:48:23 0 [Note] Using systemd activated unix socket
/run/mysqld/mysqld.sock
2022-12-30 14:48:23 0 [Note] Using systemd activated unix socket
@mariadb
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Cannot open datafile for read-
only: './mysql/innodb_index_stats.ibd' OS error: 81
2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.
2022-12-30 14:48:23 0 [ERROR] InnoDB: Could not find a valid tablespace
file for mysql/innodb_index_stats. Please refer to
https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for
how to resolve the issue.
2022-12-30 14:48:23 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.db' doesn't exist
2022-12-30 14:48:23 0 [ERROR] Aborting
Warning: Memory not freed: 280
I tried to follow the link in the errors but it appears that you have
to have a running DB to do those steps.

--
Tim McConnell <tmcconnell168@gmail.com>


On Fri, 2022-12-30 at 21:54 +0100, Guillaume Lefranc wrote:
> Please post the content of your error logs (journalctl -u
> mariadb.service)
>
> Le ven. 30 déc. 2022, 21:50, Tim McConnell <tmcconnell168@gmail.com>
> a écrit :
> > Hi Guillame,
> > Well, that almost worked, mysql_install_db ran and completed. Now
> > it
> > won't let me login as root. If I try 'mysql -u root -p'and hit
> > enter
> > when prompted for a password I get this
> > Enter password:
> > ERROR 2013 (HY000): Lost connection to server at 'handshake:
> > reading
> > initial communication packet', system error: 104
> > and I have to use 'sudo systemctl start mariadb.socket' instead of
> > 'sudo systemctl start mariadb.service' but it has to be restarted
> > if
> > authentication fails. 
> > so the rest of the KB you sent does no good since I still can't
> > access
> > the DB, or even view what was created by the installer command. 
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~maria-discuss
> > Post to     : maria-discuss@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~maria-discuss
> > More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp