Cannot log in to MySQL

This error typically occurs when MySQL didn't shut down properly, often due to:

• Power outages or sudden server crashes
• Forced termination of the MySQL service
• Improper system shutdown procedures

Resolution Steps:

1. Check if MySQL is running
   sudo service mysql status

2. Attempt to Restart MySQL
   sudo service mysql start

3. Try to recover
   sudo mysql_upgrade --force
   sudo service mysql start

4. Restart the server
   sudo init 6

If these steps don’t resolve the issue, you may need to:

1. Completely remove MySQL
2. Perform fresh MySQL installation
3. Restore from your most recent backup

NOTE: This should be done if all other recovery methods fail. Always ensure you have a valid backup before proceeding.

For persistent issues, check error logs:
sudo tail -n 50 /var/log/mysql/error.log