• MySQL table collation suddenly changed to “in use”
• Unable to login, registration, reset password

Backup database.

Error occurs when you set the connection collation to anything other then the current server collation.

So

• Repair database (repairing database will fix the “in use” issue)
• Then change the collation to same everywhere.
• You may also check the collation in the config file.

That’s all!