Learn about Centmin Mod LEMP Stack today
Become a Member

Reset user/pass for phpmyadmin (htpass)

Discussion in 'Add Ons' started by hkim, Mar 21, 2019.

  1. hkim

    hkim New Member

    24
    2
    3
    Feb 14, 2019
    Ratings:
    +3
    Local Time:
    2:54 PM
    How can I reset user/pass for htaccess for phpmyadmin? I can see the user/pass in htpassphpmyadmin but apparently the password is wrong?

    2019/03/20 21:57:08 [error] 3756#3756: *67 user "xxxx": password mismatch, client:
     
    Last edited: Mar 21, 2019
  2. eva2000

    eva2000 Administrator Staff Member

    40,190
    8,888
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,698
    Local Time:
    10:54 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    For phpmyadmin installed via phpmyadmin.sh addon at phpmyadmin.sh Addon, what you see is the hashed version of the actual password and not the actual password. You can fine existing user and password in phpmyadmin log in /root/centminlogs in file centminmod_phpmyadmin_install_${DT}.log where ${DT} is date timestamped

    or you can re-create that using this command
    Code (Text):
    python /usr/local/nginx/conf/htpasswd.py -c -b /usr/local/nginx/conf/htpassphpmyadmin YOURUSERNAME YOURPASSWORD

    replacing YOURUSERNAME YOURPASSWORD with your actual desired username and password.
     
  3. drmohansingh

    drmohansingh New Member

    6
    0
    1
    Apr 13, 2019
    Ratings:
    +0
    Local Time:
    6:24 PM
    Nginx Version
    MariaDB 10
    Thanks for sharing
     
..