Bug #29594 scripts/mysql_install_db --user=mysql
Submitted: 6 Jul 2007 10:48 Modified: 14 Jun 2008 19:44
Reporter: Thinakaran Chelliah Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:5.0.41 OS:Linux (suse 10)
Assigned to: CPU Architecture:Any

[6 Jul 2007 10:48] Thinakaran Chelliah 
Description:
while giving this command i am getting error.i was using TAR.gz installation.
scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1347  'mysql.db' is not BASE TABLE
070706 15:06:35 [ERROR] Aborting

070706 15:06:35 [Note] ./bin/mysqld: Shutdown complete

Installation of system tables failed!

How to repeat:
while giving this command i am getting error.i was using TAR.gz installation.
scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1347  'mysql.db' is not BASE TABLE
070706 15:06:35 [ERROR] Aborting

070706 15:06:35 [Note] ./bin/mysqld: Shutdown complete

Installation of system tables failed!
[6 Jul 2007 10:49] Thinakaran Chelliah 
thanks in advance
[6 Jul 2007 11:37] Sveta Smirnova 
Thank you for the report.

I can not repeat described behaviour in my environment. Please provide your configuration file.
[6 Aug 2007 23: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".
[23 Mar 2008 19:33] Jennifer Boschen 
I am having this same problem.  Any update on how to address?
[24 Mar 2008 19:04] Sveta Smirnova 
Jennifer,

thank you for the feedback. Please provide your configuration file.
[24 Apr 2008 23: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".
[14 May 2008 19:11] matt davies 
Hello everyone

I've installed mysql5 on a Leopard MacOSX, not intel chip, and I"m seeing this problem.

Here's gubbins that follows the install command.
sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
Installing MySQL system tables...
080514 20:01:18 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql5/ is case insensitive
ERROR: 1347  'mysql.db' is not BASE TABLE
080514 20:01:18 [ERROR] Aborting

080514 20:01:18 [Note] /opt/local/libexec/mysqld: Shutdown complete

Installation of system tables failed!

What's the name of the configuration file you want and any ideas where it might be on my system?

Cheers

Just thought, I probably need to create the mysql user, hmmm.  Maybe the other posters realised how daft they were being and didn't come back.

I, however, am not so precious :-)
[14 May 2008 19:44] Sveta Smirnova 
Matt,

thank you for the feedback. Please read where configuration files are located at http://dev.mysql.com/doc/refman/5.0/en/option-files.html Also, please, try to start mysql_install_db --no-defaults and see if it helps.
[2 Jun 2008 16:26] Isaac Silverman 
The problem lies in your command: sudo ./scripts/mysql_install_db --user=mysql --ldata=/{sqldata} should be sudo ./scripts/mysql_install_db --user=mysql --ldata=/data
[14 Jun 2008 23: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".
[21 Aug 2008 15:34] gopa kumar 
i am also facing the same issue when i am installing the second instance on the same machine 

please guide me 

gopakumar.p@web18.in