Saminnet-Search Article Wiki Forum Blog SNS Cloud
Bitnami MySQL reset

  • Data-Articles
    • Slower CKD stage (3) Wed12,16:41pm

      Having your kidneys work 窶 even a little 窶 can help you feel better and live longer. If you can slow your CKD, you can delay the need for treatment of kidney failure. The types of changes you might make to help your heart or the rest of your body will help your kidneys, too. Here are some things you can do 窶 or avoid 窶 to protect your kidneys: r Blood Sugar In The Target Range.…

      Read More...

Bitnami MySQL reset

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窶冲 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

Add comment


Articles by Date

TweetTweet Share on LinkedInShare on LinkedIn Share on Google+Google+ Submit to RedditReddit Publish on WordPress WordPress Send emailSend email