Saminnet-Search Article Wiki Forum Piwigo SNS Cloud vtiger Sugar
Bitnami MySQL reset

  • Data-Articles
    • Desa Nelayan Makmur (175) Fri02,20:43pm

      KALAUΒ dilihat Desa Bendar tidaklah berbeda dengan desa-desa lainnya. Berada di tepi sungai Juwana, kecamatan Juwana, kabupaten Pati, Jawa Tengah. Pun, tempat ini memiliki pelelangan ikan pula. Yang membedakan dengan desa-desa nelayan lainnya adalah rumah-rumah kokoh dan besar. Ya, desa nelayan ini bukanlah sembarangan desa nelayan. Kebanyakan warga desa ini adalah pengusaha kapal penangkap ikan.…

      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’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

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