Bug #20125 Problems running mysql_install_db
Submitted: 29 May 2006 13:26 Modified: 30 May 2006 16:16
Reporter: frederic fouchecourt Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.19 OS:HP/UX (HP-UX 11.11)
Assigned to: CPU Architecture:Any

[29 May 2006 13:26] frederic fouchecourt
When i follow the "Installing MySQL on Other Unix-Like Systems" chapter in the SQL manual, i have to launch the following command :

/usr/local/mysql#scripts/mysql_install_db --user=mysql 

This command encounter the following problem :

Installing all prepared tables
060529 15:09:24 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=vienne-bin' to avoid this problem.
./bin/mysqld: File './vienne-bin.index' not found (Errcode: 13)
060529 15:09:24 [ERROR] Aborting

060529 15:09:24 [Note] ./bin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data 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 is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!

How to repeat:
Install mysql-standard-5.0.19-hpux11.11-hppa2.0w.depot on a HP-UX 11.11 platform. Follow the procedure installation step :

shell> swinstall -s /path/to/mysql-standard-5.0.19-hpux11.11-hppa2.0w.depot
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> ln -s mysql-standard-5.0.19-hpux11.11-hppa2.0w mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql

A error append
[29 May 2006 21:47] Valeriy Kravchuk
Thank you for a problem report. Is it a very first installation of MySQL on this machine or you had other versions previously? Do you have any my.cnf file in home directory, data directory or /etc/my.cnf?

Anyway, please, check with the latest version, 5.0.21, and inform about the results.
[30 May 2006 7:31] frederic fouchecourt
Thanks for your responce Valery,

It's not the first installation of mySQL on this machine, but the previous mySQL package and database have been removed.
I have check my server and i see the /etc/my.cnf file.

Must I remove this file to be able to continue the installation ?
Are they other operations necessary ?
[30 May 2006 9:39] frederic fouchecourt
I have removed the old my.cnf file and the installation is successful.
Thanks for all
[30 May 2006 16:16] Valeriy Kravchuk
So, it is not a bug. Thank you for the additional testing.