CODE EXAMPLE FOR SQL

how to reset forgotten root password in mysql

#****** please note that this process is unsafe and it stops once you run
# 'sudo service mysql stop'

# type this in your terminal or cmd
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
# then run this command
mysql -uroot