Bug #33418 mysql_install_db: Fails to create mysql db tables
Submitted: 20 Dec 2007 20:54 Modified: 20 Dec 2007 20:59
Reporter: Paul DuBois Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:6.0.5 OS:Any
Assigned to: CPU Architecture:Any

[20 Dec 2007 20:54] Paul DuBois
Description:
This does not occur in any released version. I have seen this only in 6.0.5.
(If it gets fixed in 6.0.5, no changelog entry will be needed.)

mysql_install_db fails to properly create the mysql database. It creates the
data/mysql directory, but no tables in it. On Linux, I see this:

/var/mysql/60005% bin/mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK

... plus the usual rest of output; that is, there is no clue in the output that anything is wrong.
But little has been created:

/var/mysql/60005% ls -R data
data:
mysql  test

data/mysql:

data/test:

On Mac OS X, I see this:

/var/mysql/60005% bin/mysql_install_db
Installing MySQL system tables...
bin/mysql_install_db: line 367: 13461 Broken pipe             cat $create_system_tables $fill_system_tables
OK
Filling help tables...
OK

So there is a slight clue, perhaps. The process seemed to create slightly more files:

/var/mysql/60005% ls -R data
binlog.000001   binlog.000002   binlog.index    mysql           test

data/mysql:

data/test:

Nevertheless, the data/mysql directory remains empty.

This is a real problem; not only does mysql_instal_db fail, it doesn't detect that it has failed.

How to repeat:
See above.
[20 Dec 2007 20:59] Paul DuBois
This looks like a duplicate of Bug#33192.