mysql_fix_privilege_tables

• 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 MySQL is updated, the system tables should also be updated to make sure their structure is up-to-date.
  • First, make a backup of the mysql database, and then run the following command

    mysql_fix_privilege_tables

  • After running the script, stop the server and restart it.

• The mysql_fix_privilege_tables script performs any actions necessary to convert the system tables to the current format.
  • One might see some Duplicate column name warnings as it runs; which can be ignored.

• As of 5.0.19 mysql_fix_privilege_tables has been superceded by mysql_upgrade

What is mysql_install_db?

---

---

© 2007 John Michael Pierobon

Notes