Error Flushing Privileges: Incorrect information in file: './mysql/procs_priv.frm'

dmacleo

dmacleo

Verified User
Joined
Jun 21, 2012
Messages
631
seeing this on every database when trying to change any permissions.
no idea when this started.
cannot see anything from searches, any ideas?
 
so I am looking this all over and I decide to do a ./build msql to see what shows
I see this during the build

mysql.general_log
Error : Incorrect information in file: './mysql/general_log.frm'
error : Corrupt
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.innodb_index_stats
Error : Incorrect information in file: './mysql/innodb_index_stats.frm'
error : Corrupt
mysql.innodb_table_stats
Error : Incorrect information in file: './mysql/innodb_table_stats.frm'
error : Corrupt
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv
Error : Incorrect information in file: './mysql/procs_priv.frm'
error : Corrupt
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist
status : Operation failed
mysql.slow_log
Error : Incorrect information in file: './mysql/slow_log.frm'
error : Corrupt
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK

Repairing tables
mysql.general_log
Error : Incorrect information in file: './mysql/general_log.frm'
error : Corrupt
mysql.innodb_index_stats
Error : Incorrect information in file: './mysql/innodb_index_stats.frm'
error : Corrupt
mysql.innodb_table_stats
Error : Incorrect information in file: './mysql/innodb_table_stats.frm'
error : Corrupt
mysql.procs_priv
Error : Incorrect information in file: './mysql/procs_priv.frm'
error : Corrupt
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist
status : Operation failed
mysql.slow_log
Error : Incorrect information in file: './mysql/slow_log.frm'
error : Corrupt
Running 'mysql_fix_privilege_tables'...
ERROR 1033 (HY000) at line 80: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 86: Incorrect information in file: './mysql/general_log.frm'
ERROR 1243 (HY000) at line 87: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1033 (HY000) at line 94: Incorrect information in file: './mysql/slow_log.frm'
ERROR 1243 (HY000) at line 95: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1033 (HY000) at line 719: Incorrect information in file: './mysql/general_log.frm'
ERROR 1033 (HY000) at line 730: Incorrect information in file: './mysql/slow_log.frm'
ERROR 1033 (HY000) at line 849: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 853: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 857: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 861: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 865: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 1125: Incorrect information in file: './mysql/procs_priv.frm'
ERROR 1033 (HY000) at line 1144: Incorrect information in file: './mysql/procs_priv.frm'
Click to expand...

I am using myisam (I did use innodb at one time) not sure if that matters.
the .frm files are not really readable so not sure how to fix this.
this is using 5.5, wonder if maybe upgrading to 5.6 would force something?
 
update to 5.6 fixed that.
so then tied backing down to 5.5 again as 5.6 has issues with some stuff I use and 5.5 gives the damned pid error and I cannot get around it.
any PMA backup done now (even on 5.6) won't import due to 1064 errors.
sigh
 
forgot to update this, to roll back to 5.5 I needed to delete all logs and all innodb files.
however its back to the
Error Flushing Privileges: Incorrect information in file: './mysql/procs_priv.frm
 
You must log in or register to reply here.
Back
Top