A wonderful problem with MySQL

It's also a small problem. But small problems also need time to solve. It's not good to deal with it. There are also tutorials online. But always remind yourself that your brain is alive. Can't copy.

1 The cause of the problem, a project of the company, the MySQL backup data of different computers, is to copy the database folder. Don't know what the reason is (operating system?) , MYSQL version? , file corruption? The old prompt table is corrupted when you run the project (when you open the Web project).

2 The tedious solution is that the export is imported once again on the line. But it's too cumbersome. First find the MySQL repair command online. But after repairing a table, it also suggests that another table is bad. (The project One controller also how many use several table association) then looked for a method mysqlcheck can be repaired in batches. "Mysqlcheck-r--database db1 db2-uroot-p"

3 The problem is: cmd command line run this command, prompt password is empty unsafe, do not let me run! (Experience: Different MySQL versions will have various limitations)

4. So you have to change the password, the Web-based tutorial is basically running a SQL, update the root password. Here's the problem. Run this SQL, the next is also reported password cannot be empty!

5 Well, I didn't know how to solve it later. This is a temporary record.

A wonderful problem with MySQL