1. etc\mysql\mysql.conf.d\mysqld.cnf -> [mysqld] -> add line:
skip-grant-tables
2. systemctl restart mysql
3. run: mysql
4. mysql run: FLUSH PRIVILEGES;
5. create user 'root'@'localhost';
6. grant all on *.* to 'root'@'localhost'
7. update user set `plugin` = 'auth_socket' where `user` = 'root';
8. mysqld.cnf -> remove skip-grant-tables
9. systemctl restart mysql
10 run: mysql
11. mysql run: SELECT CURRENT_USER();
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html#resetting-permissions-unix