To reset MySQL root password on Bitnami server, first check MySQL server version you are running.
1 |
mysql --version |
Create a file
1 |
vi /tmp/mysql-init |
Add following text For MySQL 5.7 or MySQL 8
1 2 |
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEW_PASSWORD'; ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'NEW_PASSWORD'; |
For MySQL 5.6
1 2 |
UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; |
In above code, replace NEW_PASSWORD with your new MySQL root password. Stop MySQL
1 |
/opt/bitnami/ctlscript.sh stop mysql |
Reset MySQL root password by running […]