mysql_fix_privilege_tables.1 5.07 KB
Newer Older
1
'\" t
2
.\"     Title: \fBmysql_fix_privilege_tables\fR
3 4
.\"    Author: [FIXME: author] [see http://docbook.sf.net/el/author]
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
5
.\"      Date: 04/06/2010
6 7
.\"    Manual: MySQL Database System
.\"    Source: MySQL 5.1
8
.\"  Language: English
9
.\"
10
.TH "\FBMYSQL_FIX_PRIVILE" "1" "04/06/2010" "MySQL 5\&.1" "MySQL Database System"
11 12 13
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
14 15 16 17
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
18 19 20 21 22 23
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.\" mysql_fix_privilege_tables
.\" upgrading: grant tables
.\" grant tables: upgrading
24 25 26
.SH "NAME"
mysql_fix_privilege_tables \- upgrade MySQL system tables
.SH "SYNOPSIS"
27
.HP \w'\fBmysql_fix_privilege_tables\ \-\-password=\fR\fB\fIroot_password\fR\fR\ 'u
28 29
\fBmysql_fix_privilege_tables \-\-password=\fR\fB\fIroot_password\fR\fR
.SH "DESCRIPTION"
30
.if n \{\
31
.sp
32 33
.\}
.RS 4
34 35 36 37
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
38
.ps +1
39
\fBNote\fR
40 41
.ps -1
.br
42
.PP
43
In MySQL 5\&.1\&.7,
44
\fBmysql_fix_privilege_tables\fR
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
was superseded by
\fBmysql_upgrade\fR, which should be used instead\&. See
\fBmysql_upgrade\fR(1)\&.
.sp .5v
.RE
.PP
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\&.
.PP
\fBmysql_fix_privilege_tables\fR
is an older script that previously was used to uprade the system tables in the
mysql
database after a MySQL upgrade\&.
.PP
Before running
\fBmysql_fix_privilege_tables\fR, make a backup of your
mysql
database\&.
64 65 66 67 68
.PP
On Unix or Unix\-like systems, update the system tables by running the
\fBmysql_fix_privilege_tables\fR
script:
.sp
69 70 71
.if n \{\
.RS 4
.\}
72 73 74
.nf
shell> \fBmysql_fix_privilege_tables\fR
.fi
75
.if n \{\
76
.RE
77
.\}
78
.PP
79 80
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
81 82 83
root
account requires a password, indicate the password on the command line like this:
.sp
84 85 86
.if n \{\
.RS 4
.\}
87 88 89
.nf
shell> \fBmysql_fix_privilege_tables \-\-password=\fR\fB\fIroot_password\fR\fR
.fi
90
.if n \{\
91
.RE
92
.\}
93 94 95
.PP
The
\fBmysql_fix_privilege_tables\fR
96
script performs any actions necessary to convert your system tables to the current format\&. You might see some
97
Duplicate column name
98
warnings as it runs; you can ignore them\&.
99
.PP
100
After running the script, stop the server and restart it so that any changes made to the system tables take effect\&.
101 102
.PP
On Windows systems, MySQL distributions include a
103
mysql_fix_privilege_tables\&.sql
104 105
SQL script that you can run using the
\fBmysql\fR
106 107
client\&. For example, if your MySQL installation is located at
C:\eProgram Files\eMySQL\eMySQL Server 5\&.1, the commands look like this:
108
.sp
109 110 111
.if n \{\
.RS 4
.\}
112
.nf
113 114 115
C:\e> \fBcd "C:\eProgram Files\eMySQL\eMySQL Server 5\&.1"\fR
C:\e> \fBbin\emysql \-u root \-p mysql\fR
mysql> \fBSOURCE share/mysql_fix_privilege_tables\&.sql\fR
116
.fi
117
.if n \{\
118
.RE
119 120 121
.\}
.sp
.if n \{\
122
.sp
123 124
.\}
.RS 4
125 126 127 128
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
129
.ps +1
130
\fBNote\fR
131 132
.ps -1
.br
133
.PP
134 135 136
Prior to version 5\&.1\&.17, the
mysql_fix_privilege_tables\&.sql
script is found in the
137 138 139 140
scripts
directory\&.
.sp .5v
.RE
141 142 143 144 145
.PP
The
\fBmysql\fR
command will prompt you for the
root
146
password; enter it when prompted\&.
147
.PP
148
If your installation is located in some other directory, adjust the path names appropriately\&.
149 150 151 152 153 154
.PP
As with the Unix procedure, you might see some
Duplicate column name
warnings as
\fBmysql\fR
processes the statements in the
155 156
mysql_fix_privilege_tables\&.sql
script; you can ignore them\&.
157
.PP
158
After running the script, stop the server and restart it\&.
159
.SH "COPYRIGHT"
160
.br
161
.PP
162
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
163 164 165 166 167
.PP
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.
.PP
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.
.PP
168 169
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/.
.sp
170 171 172 173 174
.SH "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/.
.SH AUTHOR
175
Sun Microsystems, Inc. (http://www.mysql.com/).