[Koha] change password
rick at praxis.com.au
Tue Jul 3 18:19:58 NZST 2007
mohamed fekry wrote:
> plz any body tell me how i change master password in mySQL and koha .thanx
I think we've been over this once or twice already on the list.
Here goes again.
1. change the password in the /etc/koha.conf:
user=kohaadmin <================== REMEMBER THIS
pass=abc123 <================== CHANGE THIS
2. invoke the following mysql command, changing "kohaadmin"
to the username in the above file (if different) and changing
XXXXXX to the new password:
mysql mysql -e 'update user set password=PASSWORD("XXXXXX") where user="kohaadmin"'
This tells mysql to change the password for username kohaadmin in
the grant tables.
3. Tell mysql to reload the grant tables:
4. Restart Apache so it picks up the changes in /etc/koha.conf. On my
system I restart apache as follows:
sudo /etc/init.d/apache2 restart
How you accomplish the same on your own system depends on a number
of factors that I am not prepared to discuss at this time.
Note that if you do not understand how to use mysql at the command
line level, you are STRONGLY ADVISED to read the mysql documentation
to familiarise yourself with it.
As well, if you do not understand how to use the Apache web server,
especially starting and stopping the daemon, please read the Apache
documentation available at apache.org.
Rick Welykochy || Praxis Services
Our enemies are innovative and resourceful, and so are we. They never stop thinking
about new ways to harm our country and our people, and neither do we.
-- George W Bush, Washington DC, 20040805 (http://www.dubyaspeak.com/)
More information about the Koha