How to recover MySQL root?

• By okbutfrustrated
• on 01/14/2020

Seems can't. Product seems to work solidly, but we inherited this from people who are no longer around. And now we need to reset things.

Followed Bitnami's directions

/opt/bitnami/mysql/bin/mysqld_safe --pid-file=/opt/bitnami/mysql/data/mysqld.pid --datadir=/opt/bitnami/mysql/data --init-file=/root/mysql_cmds --lower_case_table_names=1 2> /dev/null &

But not working

# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)