How do I reset the xibo_admin account password?

If you’ve forgotten your xibo_admin account password and don’t have any way to recover access to your Xibo system, reset following the steps below.

Connect to the Xibo database and run the following SQL. This can be done from the mysql command line application, or via a web interface such as PHPMyAdmin:

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

Your xibo_admin password will then be “password”, so ensure to change it as soon as possible.

If you have a Docker based install, use the below page link for further guidance:

How can I run a SQL command when using a Docker install?

If you are using PHPMyAdmin, follow these steps to run the above SQL command:

• On left side click on Xibo database. (The name may be different in your installation)

• On top menu click on “SQL” label

• Copy/Paste this command on text area and click “Go” button.

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

You will see that the password was been reset

Thanks to @eduardo for contributing the above steps

Hashed Password Security

Xibo uses PHP password_hash() function to generate secure hashes for password storage, which uses the PHP default algorithm. At the time of writing, the default is bcrypt. As time passes, and PHP update that default, passwords will be upgraded automatically as users log in to more secure formats.