Upgrade MySQL system tables

When you try to create a remote MySQL user, sometimes  you may get the following the error.

ERROR 1146 (42S02): Table ‘mysql.procs_priv’ doesn’t exist


Why this error occurs?

 

MySQL system tables should be updated while upgrading MySQL version in the server and make sure that their structure is up to date. Otherwise, this error will occur when you create a remote user.

You can eliminate this error by executing the command in command prompt. mysql_fix_privilege_tables –password=root_password

 

This command will update MySQL tables and its structure.

Note: Before executing this command, make sure that you have taken the full backup of MySQL.

 

Both comments and pings are currently closed.

Comments are closed.