Modify the MySQL administrator password

Change the MySQL root password

You can modify the MySQL password using the following command at the shell prompt. Replace the NEW_PASSWORD placeholder with the actual password you wish to set.

$ /opt/bitnami/mysql/bin/mysqladmin -p -u root password NEW_PASSWORD

Reset the MySQL root password

If you don’t remember your MySQL root password, you can follow the steps below to reset it to a new value:

• Create a file in /home/bitnami/mysql-init with the content shown below (replace NEW_PASSWORD with the password you wish to use):

  UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root';
  FLUSH PRIVILEGES;
  

  If your stack ships MySQL v5.7.x, use the following content instead of that shown above:

  UPDATE mysql.user SET authentication_string=PASSWORD('NEW_PASSWORD') WHERE User='root';
  FLUSH PRIVILEGES;
  

  TIP: Check the MySQL version with the command /opt/bitnami/mysql/bin/mysqladmin --version or /opt/bitnami/mysql/bin/mysqld \--version

• Stop the MySQL server:

  $ sudo /opt/bitnami/ctlscript.sh stop mysql
  

• Start MySQL with the following command:

  $ sudo /opt/bitnami/mysql/bin/mysqld_safe --pid-file=/opt/bitnami/mysql/data/mysqld.pid --datadir=/opt/bitnami/mysql/data --init-file=/home/bitnami/mysql-init 2> /dev/null &
  

• Restart the MySQL server:

  $ sudo /opt/bitnami/ctlscript.sh restart mysql
  

• Remove the script:

  $ rm /home/bitnami/mysql-init