mysql - existing database error

Question

I'm building a site on Wordpress and, after a computer shutdown, when I attempt to log back in I'm getting a database error -

This is the abridged version - the actual error message carries on and covers all the tables in the database. The database is definitely there in phpmyadmin. When I look at any of the tables they have these error messages in them, this is the wp_users table -

I've done some background on this and seen that this has come up a few times, I'm not sure if I should simply reinstall wordpress and start again - this would not be a massive issue as I had only just started on the site so I hadn't actually entered anything on the database. However, what if this happens again and I'm quite far down the track - I need to understand how/why this has happened so I can deal with it if it does. Apparently it should involve deleting tables from the database but how do you do that manually (not on command line) ? Any assistance appreciated.

Answer 1

So, basically, I tried dropping the individual tables in the database but that still didn't work. In the end I dropped the entire database, re-installed wordpress and have started again afresh. Luckily I hadn't gotten very far with the site build so it wasn't a major disaster but I think the key here is to keep backing up as said above. I'm still not sure what will happen if this happens again and I'm much further down the track but let's hope this was just a glitch...

Answer 2

It looks like you've killed the mysql db process. You should stoping the process. https://dev.mysql.com/doc/mysql-startstop-excerpt/5.7/en/

MySql is holding some data in the memory of your computer. If you kill the process, these data will not been written in the file system.