Bug #24938 mysql_install_db creates nothing
Submitted: 9 Dec 2006 18:43 Modified: 9 Dec 2006 23:00
Reporter: Robin Wheeler Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:5.0.27 OS:Solaris (Solaris 9)
Assigned to: CPU Architecture:Any
Tags: installation, mysql_install_db

[9 Dec 2006 18:43] Robin Wheeler
Description:
After a pkgadd installation I run the mysql_install_db script, which reports no errors, but /opt/mysql/mysql/data/mysql and /opt/mysql/mysql/data/test are both empty. mysqld of course then won't start, complaining that it can't find mysql.host. This happens whether I run the scripts as mysql or as root.

How to repeat:
pkgadd -d mysql-standard-5.0.27-solaris9-sparc-64bit.pkg.gz
cd /opt/mysql/mysql
scripts/mysql_install_db --user=mysql
ls /opt/mysql/mysql/data/mysql

Suggested fix:
No idea.
[9 Dec 2006 18:44] Robin Wheeler
I've also tried the current 5.1 package, same result. I must be doing something wrong, but I can't see what.
[9 Dec 2006 23:00] Robin Wheeler
Problem solved: need to specify data dir: mysql_install_db --datadir=/usr/local/mysql/data/ --user=mysql