Name
mysql_fix_privilege_tables
Synopsis
mysql_fix_privilege_tables
At various points in time, the user security database
mysql
underwent some changes: the complexity of the
passwords was changed, more privileges were added, etc. To make
upgrading an existing database easier, you can use this utility to
implement the changes between versions. Be sure to restart the MySQL
server when you are finished running this utility for the changes to
take effect. As of version 5.0.19 of MySQL, this utility has been
replaced by mysql_upgrade
. It performs the same
functions and has other capabilities.
The only options for the program are
--password
, in which the root
password is given, and --verbose
to display more
information when running the program.
This program is not available on Windows systems. However, there
is an SQL file, mysql_fix_privilege_tables.sql,
that may be run with the mysql
client as
root to perform the same tasks. The SQL file is
located either in the scripts or the
share directory where MySQL is installed.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.