This document is a Mac OS X manual page. Manual pages are a command-line technology for providing documentation. You can view these manual pages locally using the man(1) command. These manual pages come from many different sources, and thus, have a variety of writing styles.

This manual page is associated with Mac OS X Server. It is not available on standard Mac OS X (client) installations.

For more information about the manual page format, see the manual page for manpages(5).

MYSQL_FIX_PRIVILE(1)                        MySQL Database System                       MYSQL_FIX_PRIVILE(1)



NAME
       mysql_fix_privilege_tables - upgrade MySQL system tables

SYNOPSIS
       mysql_fix_privilege_tables --password=root_password

DESCRIPTION
       Some releases of MySQL introduce changes to the structure of the system tables in the mysql database
       to add new privileges or support new features. When you update to a new version of MySQL, you should
       update your system tables as well to make sure that their structure is up to date. Otherwise, there
       might be capabilities that you cannot take advantage of. First, make a backup of your mysql database,
       and then use the following procedure.

       Note: As of MySQL 5.0.19, mysql_fix_privilege_tables is superseded by mysql_upgrade, which should be
       used instead. See mysql_upgrade(1).

       On Unix or Unix-like systems, update the system tables by running the mysql_fix_privilege_tables
       script:

          shell> mysql_fix_privilege_tables

       You must run this script while the server is running. It attempts to connect to the server running on
       the local host as root. If your root account requires a password, indicate the password on the
       command line like this:

          shell> mysql_fix_privilege_tables --password=root_password

       The mysql_fix_privilege_tables script performs any actions necessary to convert your system tables to
       the current format. You might see some Duplicate column name warnings as it runs; you can ignore
       them.

       After running the script, stop the server and restart it.

       On Windows systems, MySQL distributions include a mysql_fix_privilege_tables.sql SQL script that you
       can run using the mysql client. For example, if your MySQL installation is located at C:\Program
       Files\MySQL\MySQL Server 5.0, the commands look like this:

          C:\> cd "C:\Program Files\MySQL\MySQL Server 5.0"
          C:\> bin\mysql -u root -p mysql
          mysql> SOURCE scripts/mysql_fix_privilege_tables.sql

       The mysql command will prompt you for the root password; enter it when prompted.

       If your installation is located in some other directory, adjust the pathnames appropriately.

       As with the Unix procedure, you might see some Duplicate column name warnings as mysql processes the
       statements in the mysql_fix_privilege_tables.sql script; you can ignore them.

       After running the script, stop the server and restart it.

COPYRIGHT
       Copyright 1997-2007 MySQL AB

       This documentation is NOT distributed under a GPL license. Use of this documentation is subject to
       the following terms: You may create a printed copy of this documentation solely for your own personal
       use. Conversion to other formats is allowed as long as the actual content is not altered or edited in
       any way. You shall not publish or distribute this documentation in any form or on any media, except
       if you distribute the documentation in a manner similar to how MySQL disseminates it (that is,
       electronically for download on a Web site with the software) or on a CD-ROM or similar medium,
       provided however that the documentation is disseminated together with the software on the same
       medium. Any other use, such as any dissemination of printed copies or use of this documentation, in
       whole or in part, in another publication, requires the prior written consent from an authorized
       representative of MySQL AB. MySQL AB reserves any and all rights to this documentation not expressly
       granted above.

       Please email <docs@mysql.com> for more information.

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
       MySQL AB (http://www.mysql.com/)  This software comes with no warranty.



MySQL 5.0                                        07/04/2007                             MYSQL_FIX_PRIVILE(1)