Quote from A1 Computers on January 7, 2023, 7:48 pm

Assuming our new password is somenewpassword, type the following from linux command prompt:

echo -n 'somenewpassword' | sha1sum | cut -d' ' -f1

You will get a long number like:

a1f987f8dgtifjle073349cf718d9rt

log in to asterisk database

mysql -u AMPDBUSER -p asterisk

Replace AMPDBUSER with the value found in /etc/freepbx.conf or /etc/amportal.conf. When it asks for password, use the value of AMPDBPASS in the same files.

Alternatively, you can log in with root user. If you cannot get root access to MySQL because you don't know the password, then this article explains how to change it.

Check that the default user is admin, otherwise replace with the alternate username.

mysql> select * from ampusers;

Now enter the following command from mysql command prompt mysql>.

mysql> update ampusers set password_sha1 = 'e8c36c9b6fee0e438e15aa073349cf718ddd2f29'
where username = 'admin' limit 1;

Now you should be able to log into the Admin GUI with username: admin, password: somenewpassword
Don't forget to change it!