Forgot Password 1.8.1 Docker


#1

Hi,

How do you reset your admin password for 1.8.1 when its running on Docker?

Thanks


Forgot password
#2

You will need to run sql command (similar to 1.7 series) on the web container.

Please see here how to access mysql on docker - How can I run a SQL command when using a Docker Install?

ie
docker ps (to learn the web container name)

docker exec -it <container_name> bash

mysql -hmysql -ucms -p <your_password> (The password will be the one you set in config.env when you installed Xibo.)

then make sure that you have database selected, you can run use <databaseName> if it’s not selected (default database name is cms)

then finally run the command to change the password ie

UPDATE user set UserPassword = MD5(‘password’), CSPRNG = 0 WHERE UserID = 1 LIMIT 1;

Where ‘password’ will be your new password.

Alternatively install PhpMyAdmin as docker container and run the sql command from there (process described in the link I’ve mentioned).