Mysql < fix_priv_tables Run mysql_upgrade From Command Line Mysqlcheck -all-databases -check-upgrade -auto-repair Mysql_upgrade executes the following commands to check and repair tables and to upgrade the system tables: It supersedes the older mysql_fix_privilege_tables script, which should no longer be used. Mysql_upgrade should be executed each time you upgrade MySQL. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added. Mysql_upgrade examines all tables across all databases for incompatibilities with the current version of MySQL Server. The simple fix to this problem is to run the mysql_upgrade command from the command line. This happens due to schema changes required for different MySQL server versions. MySQL will sometimes return the error message “Cannot load from mysql.proc.
0 Comments
Leave a Reply. |