Wind River Support Network


LIN5-19083 : missing the user of "mysql" cause "mysql_install_db" return error

Created: Jul 17, 2014    Updated: Dec 19, 2017
Resolved Date: Jul 24, 2014
Found In Version:
Fix Version:
Severity: Standard
Applicable for: Wind River Linux 5
Component/s: Userspace


:~# mysql_install_db
WARNING: The host 'Romley-EP-Ivy-Refresh-1' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL 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 MySQL privileges !
chown: invalid user: `mysql'
chown: invalid user: `mysql'
chown: invalid user: `mysql'
Installing MySQL system tables...
140717  8:16:12 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

140717  8:16:12 [ERROR] Aborting

140717  8:16:12 [Note] /usr/libexec/mysqld: Shutdown complete

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

You can try to start the mysqld daemon with:

    shell> /usr/libexec/mysqld --skip-grant &

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 --log
gives you a log in /var/mysql that may be helpful.

The latest information about MySQL is available on the web at  Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/scripts/mysqlbug script!

Steps to Reproduce

 --enable-jobs=24 --enable-parallel-pkgbuilds=24  --enable-board=intel-xeon-core --enable-kernel=standard --enable-rootfs=glibc-std --with-layer=/lpg-build/cdc/bsp/wrlinux-6.0/wr-testing/userspace-new,rcfl --with-template=feature/valgrind,feature/libhugetlbfs,feature/lttng2,feature/nfsd,feature/mysql,feature/mysql-odbc,feature/oprofile,feature/syslog-ng-logrotate,feature/target-toolchain --enable-test=yes --enable-addons=wr-rcfl --enable-build=profiling


run image 

do shell command : mysql_install_db

Other Downloads

Live chat