Shulou(Shulou.com)05/31 Report--

This article introduces how to upgrade the system table in MySQL, the content is very detailed, interested friends can use for reference, I hope it can be helpful to you.

On Unix or Unix systems, run the mysql_fix_privilege_tables script to update the system table:

Shell > mysql_fix_privilege_tables

You must execute the script while the server is running. It attempts to connect to a server running with root on this machine. If the root account requires a password, give the password on the command line as follows:

Shell > mysql_fix_privilege_tables--password=root_password

The mysql_fix_privilege_tables script can perform any action that converts the system table to the current format. You may see some Duplicate column name warnings at run time; you can ignore them.

After running the script, stop the server and restart.

In Windows, the MySQL distribution includes mysql_fix_privilege_tables.sql SQL scripts, which you can run with the mysql client. For example, if MySQL is installed to C:Program FilesMySQLMySQL Server 5.1, the command should be:

C: > C:Program FilesMySQLMySQL Server 5.1inmysql-u root-p mysqlmysql > SOURCE C:/Program Files/MySQL/MySQL Server5.1/scripts/mysql_fix_privilege_tables.sql

If you install to a different directory, change the pathname accordingly.

The mysql command prompts for the root password; follow the prompts for the password.

In Unix, when mysql processes statements in mysql_fix_privilege_tables.sql script scripts, you may see some Duplicate column name warnings; you can ignore them.

On how to upgrade the system table in MySQL to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.