/
Admin area: Modify HostBill admin password using MySQL

Admin area: Modify HostBill admin password using MySQL

If you've ever forgot your password and password reminder is not working for you (because for example you didn't changed default admin email address) - you can still change it in HostBill database.

To change your password using MySQL:

  1. From (local or server) shell, execute following command to generate (replace mynewadminpassword with your new password):

    php -r "echo password_hash('mynewadminpassword', PASSWORD_DEFAULT), PHP_EOL;"

  2. Copy result, it will look like: $2y$12$SP.voiicbMSX5rPR4KLIse4Gotq6.1O1QJI4teZXJ2ucHXafrOM/6

  3. Login to your HostBill mysql database (i.e: using PhpMyAdmin tool, or mysql cli command)

  4. Update query below with admin username/password hash, and execute query:

UPDATE hb_admin_access SET `password`='$2y$12$SP.voiicbMSX5rPR4KLIse4Gotq6.1O1QJI4teZXJ2ucHXafrOM/6' WHERE username='admin';