Oracle 5.0, Reference Manual

Page: 277 / 3232

mysqlbug
— Generate Bug Report
257
Specify the temporary location.
4.4.4.
mysqlbug
— Generate Bug Report
This program enables you to generate a bug report and send it to Oracle Corporation. It is a shell script
and runs on Unix.
The normal way to report bugs is to visit http://bugs.mysql.com/ , which is the address for our bugs
database. This database is public and can be browsed and searched by anyone. If you log in to the
system, you can enter new reports. If you have no Web access, you can generate a bug report by
using the
mysqlbug
script.
mysqlbug
helps you generate a report by determining much of the following information automatically,
but if something important is missing, please include it with your message.
mysqlbug
can be found
in the
scripts
directory (source distribution) and in the
bin
directory under your MySQL installation
directory (binary distribution).
Invoke
mysqlbug
without arguments:
shell> mysqlbug
The script will place you in an editor with a copy of the report to be sent. Edit the lines near the
beginning that indicate the nature of the problem. Then write the file to save your changes, quit the
editor, and
mysqlbug
will send the report by email.
4.4.5.
mysql_fix_privilege_tables
— Upgrade MySQL System 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 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.
mysql_fix_privilege_tables
is an older script that previously was used to uprade the system
tables in the
mysql
database after a MySQL upgrade.
Note
As of MySQL 5.0.19,
mysql_fix_privilege_tables
is superseded
by
mysql_upgrade
, which should be used instead. See Section 4.4.9,
“
mysql_upgrade
— Check Tables for MySQL Upgrade” .
Before running
mysql_fix_privilege_tables
, make a backup of your
mysql
database.
On Unix or Unix-like systems, update the system tables by running the
mysql_fix_privilege_tables
script:
shell> mysql_fix_privilege_tables
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
root
account requires a password, indicate the password on the command
line like this:
shell> mysql_fix_privilege_tables --password=root_password
The
mysql_fix_privilege_tables
script performs any actions necessary to convert your system
tables to the current format. You might see some
Duplicate column name
warnings as it runs; you
can ignore them.
After running the script, stop the server and restart it so that any changes made to the system tables
take effect.