2
6 mysql_fix_privilege_tables - upgrade MySQL system tables
7
9 mysql_fix_privilege_tables --password=root_password
10
12 Some releases of MySQL introduce changes to the structure of the system
13 tables in the mysql database to add new privileges or support new
14 features. When you update to a new version of MySQL, you should update
15 your system tables as well to make sure that their structure is up to
16 date. Otherwise, there might be capabilities that you cannot take
17 advantage of. First, make a backup of your mysql database, and then use
18 the following procedure.
19 Note: As of MySQL 5.0.19, mysql_fix_privilege_tables is superseded by
21 mysql_upgrade, which should be used instead. See mysql_upgrade(1).
22 On Unix or Unix-like systems, update the system tables by running the
24 mysql_fix_privilege_tables script:
25 shell> mysql_fix_privilege_tables
27 You must run this script while the server is running. It attempts to
29 connect to the server running on the local host as root. If your root
30 account requires a password, indicate the password on the command line
31 like this:
32 shell> mysql_fix_privilege_tables --password=root_password
34 The mysql_fix_privilege_tables script performs any actions necessary to
36 convert your system tables to the current format. You might see some
37 Duplicate column name warnings as it runs; you can ignore them.
38 After running the script, stop the server and restart it.
40 On Windows systems, MySQL distributions include a
42 mysql_fix_privilege_tables.sql SQL script that you can run using the
43 mysql client. For example, if your MySQL installation is located at
44 C:\Program Files\MySQL\MySQL Server 5.0, the commands look like this:
45 C:\> cd "C:\Program Files\MySQL\MySQL Server 5.0"
47 C:\> bin\mysql -u root -p mysql
48 mysql> SOURCE scripts/mysql_fix_privilege_tables.sql
49 The mysql command will prompt you for the root password; enter it when
51 prompted.
52 If your installation is located in some other directory, adjust the
54 pathnames appropriately.
55 As with the Unix procedure, you might see some Duplicate column name
57 warnings as mysql processes the statements in the
58 mysql_fix_privilege_tables.sql script; you can ignore them.
59 After running the script, stop the server and restart it.
61
63 Copyright 1997-2007 MySQL AB
64 This documentation is NOT distributed under a GPL license. Use of this
66 documentation is subject to the following terms: You may create a
67 printed copy of this documentation solely for your own personal use.
68 Conversion to other formats is allowed as long as the actual content is
69 not altered or edited in any way. You shall not publish or distribute
70 this documentation in any form or on any media, except if you
71 distribute the documentation in a manner similar to how MySQL
72 disseminates it (that is, electronically for download on a Web site
73 with the software) or on a CD-ROM or similar medium, provided however
74 that the documentation is disseminated together with the software on
75 the same medium. Any other use, such as any dissemination of printed
76 copies or use of this documentation, in whole or in part, in another
77 publication, requires the prior written consent from an authorized
78 representative of MySQL AB. MySQL AB reserves any and all rights to
79 this documentation not expressly granted above.
80 Please email <docs@mysql.com> for more information.
82
84 For more information, please refer to the MySQL Reference Manual, which
85 may already be installed locally and which is also available online at
86 http://dev.mysql.com/doc/.
87
89 MySQL AB (http://www.mysql.com/). This software comes with no
90 warranty.
91