Change Root or master password of Koha

 

Change the Root or master password of Koha

Koha master login username and password are the same as MySQL database (e.g. koha_library), where data is stored.

First change the password of koha_library database.
Then put new password in /etc/koha/sites/library/koha-conf.xml

Apply the following commands in Applications > Accessories > Terminal

sudo mysql -uroot -p  

[enter the MySQL Root password]

use MySQL;
SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('koha123');
flush privileges;
quit;

Need to change the new password in the Koha configuration file.

Open the configuration file using any text editor. Use any text editor, mousepad/leafpad. Install mousepad;

sudo apt-get install mousepad

sudo mousepad /etc/koha/sites/library/koha-conf.xml

The file will open. Scroll to the bottom part of the file and find the line for the password.

You can find the old password. Place your new password.
Save [Ctrl+O] and close [Ctrl+x] the file. Login to Koha using the new password