man pages section 1: User Commands

Exit Print View

Updated: July 2014
 
 

mysql_fix_privilege_tables (1)

Name

mysql_fix_privilege_tables - upgrade MySQL system tables

Synopsis

mysql_fix_privilege_tables --password=root_password

Description




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
         Note

         In MySQL 5.1.7, mysql_fix_privilege_tables was
         superseded by mysql_upgrade, which should be used
         instead. See mysql_upgrade(1).

     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.

     mysql_fix_privilege_tables is an older script that
     previously was used to uprade the system tables in the mysql
     database after a MySQL upgrade.

     Before running mysql_fix_privilege_tables, make a backup of
     your mysql database.

     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 so
     that any changes made to the system tables take effect.

     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



MySQL 5.1            Last change: 07/13/2009                    1






MySQL Database System                        MYSQL_FIX_PRIVILE(1)



     Server 5.1, the commands look like this:

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


         Note

         Prior to version 5.1.17, this script is found in the
         scripts directory.

     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 path names 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 2007-2008 MySQL AB, 2009 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/.



ATTRIBUTES
     See attributes(5) for descriptions of the following
     attributes:





MySQL 5.1            Last change: 07/13/2009                    2






MySQL Database System                        MYSQL_FIX_PRIVILE(1)



     +---------------+-------------------+
     |ATTRIBUTE TYPE | ATTRIBUTE VALUE   |
     +---------------+-------------------+
     |Availability   | database/mysql-51 |
     +---------------+-------------------+
     |Stability      | Uncommitted       |
     +---------------+-------------------+
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/).



NOTES
     This software was built from source available at
     https://java.net/projects/solaris-userland.  The original
     community source was downloaded from
     http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.37.tar.gz

     Further information about this software can be found on the
     open source community website at http://dev.mysql.com/.






























MySQL 5.1            Last change: 07/13/2009                    3