0

Im fairly new to ubuntu and I currently need some help understanding this error.

As of now, Im working on a server with which to host a WordPress sites using this tutorial: https://deliciousbrains.com/hosting-wordpress-yourself-nginx-php-mysql/ I am currently stuck at trying to setup the default system tables for MariaDB/Mysql(?) (i would also greatly appreciate if someone could help shed some light on what Im actually trying to achieve here, Im trying my hardest to follow it all but I still find it to be quite confusing).

After I installed MariaDB using the instruction from their website: https://downloads.mariadb.org/mariadb/repositories/#distro=Ubuntu&distro_release=xenial--ubuntu_xenial&version=10.1&mirror=supportex and created a root password(for mariadb, not the actual server), whenever i try to run: sudo mysql_install_db i get this error message:

Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2017-08-30 11:37:39 140643689761024 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-1~xenial) starting as process 2161 ...

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/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant --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
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

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

I do not know what's causing this to happen, I already tried reinstalling MariaDB several times to no availl, and it also appears that the file .my.cnf appears to be missing.

If someone could help me solving this problem i would be very grateful!

  • Did you have a look at the log in /var/lib/mysql as suggested? Did you also try the various proposals contained in the error message? You would be one step further. – Marc Vanhoomissen Aug 31 '17 at 13:50
  • I did, however most the log didn't really contain any usefull information and the other 2 options didn't seem to work either. but it not necesary anymore because apparently MariaDB did install aparently, and its working fine. So I dont know what the error was about or wether it has any severe effects on the database storing – Emiel van den Brink Sep 1 '17 at 13:56

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.