Sign in
Categories
Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

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)


  • By Vinod
  • on 01/18/2020

Root password for MySQL is same as application password. It is stored in cat ~/bitnami_credentials in bitnami userid