Restored tables in read-only mode

[Paul Ashton]

Hi all - normally figure things out myself, but this time I'm stuck :(

I shall start at the beginning! I had a Windows 2008 R2 server that crashed and needed rebuilding, it had MySQL 5.7 on it running WordPress and a few other web applications...

Everything is restored ok now - and my WordPress website is working, but I cannot log onto WordPress. It transpires that all of the MySQL tables are in read-only mode.

My first issue was that I could not log on to the workbench as performance_schema.session_variables doesn't exist. This sent me down the route of running mysql_upgrade with the force parameters, unfortunately I get lots of errors saying that the tables are read only.

Could someone help point out how to make the tables editable - from my my.ini I can see that the data is physically located here:
D:\Databases\MySQL

I can administer using phpmyadmin, but any help would be appreciated!

Thanks in advance.

Paul