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!