MySQL Bugs: #1515: error in setup documentation

Bug #1515	error in setup documentation
Submitted:	10 Oct 2003 4:17	Modified:	4 Aug 2004 15:13
Reporter:	Rickey Costas	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:		OS:
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
doing the following as root:

shell> scripts/mysql_install_db

may make initial mysql tables which the mysql user cant subsequently read. giving the slightly confusing

Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

in the logs.

How to repeat:
do a fresh install as root, with no tables at all in the place where mysql stores tables (/var/db/mysql/ on my machine).

Suggested fix:
do:

shell> scripts/mysql_install_db --user=mysql

instead.  Also doing:

shell> scripts/mysql_install_db --help

doest seem to give you help on the mysql_install_db command.

Hope it helps,

Rickey.

For to avoid the problem you are reporting I use the below compilation option:

miguel@hegel:~/build/mysql-4.0> ./configure --help
..........................................................................

--with-mysqld-user=username
                          What user the mysqld daemon shall be run as.
..........................................................................

Anyway I am assigning our Production Engineer for further analyze.

Our binaries are compiled with setting "mysql" as the default user. Paul, can you check if it would make
sense to document the "--user" option in the installation chapter? Thanks!

Actually, I just noticed that the --user option is already documented in the manual.
Closing this bug report.