Dev {Tricks}

You are here: Home / Archives for Server and Hosting

by

MySQL database table “in use” problem

  • 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!

by

How to change default website

Instructions on how to change default website by the hostname or IP address. 

To edit default index file:
Go to Folder

vi /usr/local/apache/htdocs/

and edit index.html file

Apache Logs are in:

vi /usr/local/apache/logs/