- MySQL table collation suddenly changed to “in use”
- Unable to login, registration, reset password
Error occurs when you set the connection collation to anything other then the current server collation.
- 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.