Forum

* The generation of the initial system mysql database is now done when mysql is started from the initscript and only if the /var/lib/mysql/mysql directory is empty (mysql_install_db). Previousely this was quite hidden and silently done at (rpm) install time. As a consequence to this change you may have to perform some manual tasks to upgrade the mysql system database and such. So, doing something like this might help you:

systemctl stop mysqld.service TMPDIR=/var/tmp mysql_install_db mysql_upgrade --skip-write-binlog

[root@localhost ~]# systemctl stop mysqld.service
[root@localhost ~]# TMPDIR=/var/tmp
[root@localhost ~]# mysql_install_db mysql_upgrade --skip-write-binlog
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2020-11-09 8:51:48 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
201109 8:51:48 server_audit: MariaDB Audit Plugin version 1.4.10 STARTED.
201109 8:51:48 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2020-11-09 8:51:48 0 [ERROR] /usr/sbin/mysqld: unknown option '--skip-write-binlog'
2020-11-09 8:51:48 0 [ERROR] Aborting

201109 8:51:48 server_audit: STOPPED

Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /usr/sbin/mysqld --skip-grant-tables --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables;

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

[root@localhost ~]#