MySQL - resetting root password

In order to reset your root password for mysql:

1. Find mysqld_safe application (usually in /usr/bin/mysqld_safe)
2. 
   
3. Stop currently running mysqld process:
   
/etc/init.d/mysqld stop

   


4. Start mysql in a safe mode with --skip-grant-tables option using previously found path of mysqld_safe. This gives full access for all users with no passwords:
   
/usr/bin/mysqld_safe --skip-grant-tables &

   


5. Enter mysql:
   
mysql

   


6. Type:
   UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

   Mind that UPDATE and FLUSH should be in different lines.
   


7. Restart mysql with usual settings:
   
/etc/init.d/mysqld restart

   

Mail from command line

To send an email from command line you can use "mail" command.
Example:
echo "Message body" | mail -s "Test_subject" example@exampledomain.com
Sends message "Message body" with a subjects "Test_subject" to example@exampledomain.com