0

My c# program give me this error:

MySql.Data.MySqlClient.MySqlException : 'Table 
'performance_schema.session_variables' doesn't exist'

Then I came across this answer: Table 'performance_schema.session_variables' doesn't exist

I don't know where to write this command, knowing that I use EasyPhp.

Is this the Windows command prompt?

Is it mysql shell?

Thank you in advance for helping me to see things more clearly.

Bender Bending
  • 729
  • 8
  • 25
Witzig Adrien
  • 102
  • 12

1 Answers1

1

The command you linked to (mysql_upgrade -u root -p --force) is run on the MySQL Server, either at a Windows Command Prompt (if a Windows server) or a bash (or similar Unix shell prompt) on Linux. You may need to get your server administrator to run it for you.

The performance_schema.session_variables table is only available in MySQL Server 5.7.6 and later. If you're running an earlier version (or a different DB server, such as MariaDB), this table may not exist, causing the error you're seeing.

Bradley Grainger
  • 27,458
  • 4
  • 91
  • 108