Did you forgot what password your mysql root user uses? Let’s reset it!
To reset root password in mysql follow these steps:
- Kill mysql
sudo kill MYSQL_PROCESS_ID
- Create text file with this content:
sudo mysqld_safe --init-file=/path/to/created/file --skip-syslog &
- Remove the file
- Now you should be able to login as root with the new password