Back to main site | Back to man page index

MYSQL_INSTALL_DB()                                                                                 MYSQL_INSTALL_DB()



NAME
       mysql_install_db - initialize MySQL data directory

SYNOPSIS
       mysql_install_db [options]

DESCRIPTION
       mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they
       do not exist.

       To invoke mysql_install_db, use the following syntax:

           shell> mysql_install_db [options]

       Because the MySQL server, mysqld, needs to access the data directory when it runs later, you should either run
       mysql_install_db from the same account that will be used for running mysqld or run it as root and use the
       --user option to indicate the user name that mysqld will run as. It might be necessary to specify other
       options such as --basedir or --datadir if mysql_install_db does not use the correct locations for the
       installation directory or data directory. For example:

           shell> bin/mysql_install_db --user=mysql \
                    --basedir=/opt/mysql/mysql \
                    --datadir=/opt/mysql/mysql/data

       mysql_install_db needs to invoke mysqld with the --bootstrap and --skip-grant-tables options (see
       Section 2.3.2, “Typical configure Options”). If MySQL was configured with the --disable-grant-options option,
       --bootstrap and --skip-grant-tables will be disabled. To handle this, set the MYSQLD_BOOTSTRAP environment
       variable to the full path name of a server that has all options enabled.  mysql_install_db will use that
       server.

       mysql_install_db supports the following options, which can be specified on the command line or in the
       [mysql_install_db] and (if they are common to mysqld) [mysqld] option file groups.

       ·   --basedir=path

           The path to the MySQL installation directory.

       ·   --force

           Cause mysql_install_db to run even if DNS does not work. In that case, grant table entries that normally
           use host names will use IP addresses.

       ·   --datadir=path, --ldata=path

           The path to the MySQL data directory.

       ·   --rpm

           For internal use. This option is used by RPM files during the MySQL installation process.

       ·   --skip-name-resolve

           Use IP addresses rather than host names when creating grant table entries. This option can be useful if
           your DNS does not work.

       ·   --srcdir=path

           Verbose mode. Print more information about what the program does.

       ·   --windows

           For internal use. This option is used for creating Windows distributions.

COPYRIGHT
       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU
       General Public License as published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even
       the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public
       License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the
       Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
       http://www.gnu.org/licenses/.


SEE ALSO
       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and
       which is also available online at http://dev.mysql.com/doc/.

AUTHOR
       Sun Microsystems, Inc. (http://www.mysql.com/).



                                                                                                   MYSQL_INSTALL_DB()