Bug #66492 bur when running mysql_install_db
Submitted: 22 Aug 2012 7:27 Modified: 22 Sep 2012 8:41
Reporter: Sergio Martinez Cuesta Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.5.27 OS:Linux (2.6-i686)
Assigned to: CPU Architecture:Any
Tags: lc-messages-dir, mysql_install_db

[22 Aug 2012 7:27] Sergio Martinez Cuesta
Description:
I'm trying to install MySQL server. When running mysql_install_db using the following command:

> scripts/mysql_install_db --user=mysql

I got the following error:

---------------------
Neither host 'XXXXXX' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option
---------------------------

when running with --force

> scripts/mysql_install_db --user=mysql

I got the following:

------------------------
chown: changing ownership of `/var/lib/mysql': Operation not permitted
Cannot change ownership of the database directories to the 'mysql'
user.  Check that you have the necessary permissions and try again.
------------------------

when running with sudo:

>sudo scripts/mysql_install_db --user=mysql --force

------------------------
Installing MySQL system tables...
120822  8:24:14 [ERROR] /usr/sbin/mysqld: unknown variable 'lc-messages-dir=/usr/share/mysql/english/..'
120822  8:24:14 [ERROR] Aborting

120822  8:24:14 [Note] /usr/sbin/mysqld: Shutdown complete

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

You can try to start the mysqld daemon with:

    shell> /usr/sbin/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/lib/mysql that may be helpful.

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 http://lists.mysql.com/.

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

please help

How to repeat:
>sudo scripts/mysql_install_db --user=mysql --force

Suggested fix:
No idea
[22 Aug 2012 8:41] Valeriy Kravchuk
Do you run mysql_install_db as root user? What is the output of:

hostname
ping `hostname`

commands in your system?
[22 Aug 2012 8:43] Valeriy Kravchuk
Please, send also the content of:

/etc/my.cnf

or whatever else my.cnf or .my.cnf files you may have in your system.
[23 Sep 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".