Mysql 5.7.17:

1. mysql -u root mysql -p
2. flush privileges;
3. ALTER USER ‚root’@’localhost‘ IDENTIFIED BY ‚NEW-ROOT-PASSWORD‘;
4. ‚flush privileges;

Links

• https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords
• https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html