cannot create system table MySQL(mariadb)

English Applications
1

I am following this guide here https://en.opensuse.org/SDB:Linux_Apache_MySQL_PHP .
Apache has been successfully installed and works.
The service for mysql has been started, I know need to create user and system tables. So as root I have cd /bin and execued the command.

mysql_install_db --user=mysql

However I receive an error that it cannot retrieve a host and will only accept an IP.

linux-41ym:/bin # mysql_install_db --user=mysql
WARNING: The host 'linux-41ym.site' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !

If I am supposed to modify this command I am unsure how to the error refers me to this page https://mariadb.com/kb/en/installing-system-tables-mysql_install_db/

From the page i tried this commands to skip DNS lookup but receive this error.

linux-41ym:/bin # mysql_install_db --skip-name-resolve --user=mysql
WARNING: The host 'linux-41ym.site' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
140402 21:55:20 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
140402 21:55:51 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
140402 21:55:51 [ERROR] Plugin 'Aria' init function returned error.
140402 21:55:51 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
ERROR: 1017  Can't find file: '/tmp/#sql_46f6_0' (errno: 2)
140402 21:55:51 [ERROR] Aborting

140402 21:55:51 [Note] /usr/sbin/mysqld: Shutdown complete

How can I resolve this?

2

The WARNING says that linux-41ym.site can not be resolved to an IP address.

I assume that linux-41ym.site is the host/domainname given by the installer to your host as a default during network installation because you did not tell it otherwise. Also it does not seem to be in /etc/hosts (and it will of course not be in the DNS server you use).

3

Neither the opensuse or mariadb guide cover this exceptig the already tried.
–skip-name-resolve

I was unable to resolve using that command for test databases. The following command appears to work normally and let me proceed.

/usr/bin/mysql_secure_installation
4

As long as you have entered a root password and answered Y to all the other questions, you will have set up a secure default installation. This is always the first command to run if you are installing a fresh installation.