How to Change database password in Koha!!

      Sometime in Koha, we may have to change the password of database i.e MySQL which was provided at the time of installation of the Integrated Library System. To do the same, we have to follow steps below :

Step - 1 : Launch the terminal by pressing Ctrl + Alt + T simultaneously.

Step - 2 : Login as superuser

sudo su

and enter system password

Step - 3 : Login to MySQL database

mysql -uroot -p   

Enter MySQL root password.

Step - 4 : Enter the command to use mySQL

  use mysql;

Step - 5 :  Change Password for database.

SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('library001');

Put the new password at the place of Library001.

 Step - 6 : Grant Permission

 flush privileges;

 Step - 7 : Exit from database

Quit;

Now we have to change the password of koha configuration file at koha-conf.xml

Use leafpad text editor for editing koha configuration file password.

Check here to to install leafpad text editor. And for Ubuntu 19.04 check here

Step - 8 :  change the password of koha configuration file

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

 
It will open a text file and here change the password. Save and Close the file.

All done!