One of the most frustrating things is installing MySQL and then forgetting what password you set for the root user. This has happened to me on more than one occasion. You can reset the password with the following procedure.
Databases
MSSQL: How To Get Database Out of Single User
The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state.
MSSQL: How to Get Database Out of “Restoring” State
When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this.