java.sql.SQLException: Native table 'performance_schema'.'session_variables' has the wrong structure

254
July 21, 2017, at 05:00 AM

Previously I accidentally dropped 'performance_schema' and 'sys' from DB. I ran mysql_upgrade -u root -p --force --skip-version-check in order to recreate those two. They were successfully recreated. I couldn't restart the MySQL service because I couldn't find MySQL running in Administrative Tools -> Services.

So I think some of the database has broken and now every time I try to run my game server I get this error: java.sql.SQLException: Native table 'performance_schema'.'session_variables' has the wrong structure

What can I do to get it fixed?

I tried using this thread - Native table 'performance_schema'.'???' has the wrong structure but no success.

By the way, not sure it's important but I'm on Windows 10 and using MySQL Query Browser.

READ ALSO
ambiguous mysql statement using AND and OR need help to structure correctly

ambiguous mysql statement using AND and OR need help to structure correctly

I have a sql statement that I already know is not structured correctly using a SELECT with AND and ORI have tried several variations but I can't seem to get it to work

128
#2002 - Unable to find the socket transport “tcp”

#2002 - Unable to find the socket transport “tcp”

2002 - Unable to find the socket transport "TCP" - did you forget to enable it when you configured PHP? — The server is not responding (or the local server's socket not set correctly)

119
How can i make website that deals with data previously saved as Microsoft excel files? [on hold]

How can i make website that deals with data previously saved as Microsoft excel files? [on hold]

I want to make a website that deals with data about persons that is updated weekly and was previously saved as Microsoft excel files but the problem with excel is that is was very difficult to edit and update and it can’t be accessed from anywhere so How can I make a website...

131
Database Ruined by BackUpWordpress Plugin. Can not access it?

Database Ruined by BackUpWordpress Plugin. Can not access it?

I installed a plugin named,BackUpWordpressSite was working fine and I do receive backup regularly

139