CODEWITHSUNDEEP
c#mysql
Witzig Adrien
Witzig Adrien

Reputation: 102

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

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.

Upvotes: 0

Views: 2759

Answers (1)

Bradley Grainger
Bradley Grainger

Reputation: 28162

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.

Upvotes: 1

Related Questions