[Koha] change password

Rick Welykochy 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:

    mysqladmin reload

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 mailing list