[MDEV-25184] can't install DB Created: 2021-03-18  Updated: 2021-04-18  Resolved: 2021-04-18

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Dvir Horev Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

VMware Workstation



 Description   

can't install DB with the command: mysql_install_db --user=mysql

The Error: Installation of system tables failed! Examine the logs in
/var/log/mariadb/mariadb.log or /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/libexec/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



 Comments   
Comment by Daniel Black [ 2021-03-18 ]

Please include information like distro and version that you are using to install.

What user are you running mysql_install_db as?

What is in the described logs?

Comment by Daniel Black [ 2021-03-18 ]

Also, which mariadb version/package?

Generated at Thu Feb 08 09:35:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.