During the koha installation, the system provides the alphanumeric MYSQL database password, which is very difficult to remember. We can change the password of the koha database easily.
Koha master login username and password are the same as MySQL database (e.g. koha_library), where the data is stored.
Follow the below steps to change the database password
First, we have to change the password of the koha_library database. After Then we need to change the password in the 'koha-conf.xml' file
Open the terminal (Ctrl + Alt + T) and log in as a root user
sudo su
Hit enter and enter the password
Log in to the MySQL database
mysql -uroot -p
Enter the MySQL password.
Enter the command to use MySQL
use mysql;
Change the Password for the database.
SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('admin@123');
(In the above command the default password is replaced with the admin@123. You should put yours in place of admin@123)
Grant Permission
flush privileges;
Exit from the database
Quit;
Now we have to change the password of the koha configuration file at koha-conf.xml
Open the Koha configuration file with any editor
sudo gedit /etc/koha/sites/library/koha-conf.xml
The following file will open. Scroll the file and find the line for the username and password. Here you find your default password. change it with a new password.
Save and close the file. Now Mysql password has been changed.
0 Comments