Online Learning Academy - LearnAcad.com

... Sharing Knowledge

  • Increase font size
  • Default font size
  • Decrease font size
Home

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

E-mail Print PDF

I am getting the following:

Native table 'performance_schema'.'file_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
...

The problem appears if you have inconsistant data or you have upgraded MySQL

Solution:

Backup your databases first,

reinstall mysql

restore you databases.

OR

run mysql_upgrade

It the root is password protected

mysql-upgrad --password

I hope it will resolve the problem.

 

 

 
Follow us on Twitter

Main Menu

Linux

Islam

Windows

Interview Questions

Database

Internet

Cisco

Entertainment

Networking

Graduate Courses

Psychology

Feed Burner

Subscribe to Welcome to Online Learning Academy by Email

Enter your email address:

Delivered by FeedBurner


Google Groups
Subscribe to LearnAcad
Email:
Visit this group

Login Form