mysql_fix_privilege_tables(1)

NAME

       mysql_fix_privilege_tables - Fixes MySQL privilege tables.

SYNOPSIS

       mysql_fix_privilege_tables [mysql_root_password]

DESCRIPTION

       This  scripts  updates  the  mysql.user,  mysql.db,  mysql.host and the
       mysql.func tables to MySQL 3.22.14 and above.

       This is needed if you want to  use  the  new  GRANT  functions,  CREATE
       AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

       If  you  get  'Access denied' errors, run the script again and give the
       MySQL root user password as an argument.

SEE ALSO

       isamchk(1),  isamlog(1),   mysql(1),   mysqlaccess(1),   mysqladmin(1),
       mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysqlshow(1),
       mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL reference manual,  which
       may  already be installed locally and which is also available online at
       http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       This manpage was written by Christian Hammers <ch@debian.org>.

       MySQL is available at http://www.mysql.com/.

MySQL 4.1                        17 March 2003                        mysql(1)