Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Native table 'performance_schema'.'???' has the wrong structure

Tags:

mysql

I am getting the following:

Native table 'performance_schema'.'file_instances' has the wrong structure Native table 'performance_schema'.'cond_instances' has the wrong structure Native table 'performance_schema'.'rwlock_instances' has the wrong structure Native table 'performance_schema'.'mutex_instances' has the wrong structure ... 

And on it goes These errors come up when I restart MySql. It seems to cause MySql Administrator to become unstable, I get a lot of:

"MySQL server has gone away" 
like image 382
P Hemans Avatar asked Jun 09 '11 04:06

P Hemans


1 Answers

Try following command in shell (the root user here is the mysql root user, not the system root)

sudo mysql_upgrade -u root -p  sudo service mysql restart 

Make sure to restart mysql after running this (All credit to @Mikepote in the comments.)

like image 163
Musa Avatar answered Oct 18 '22 03:10

Musa