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: database=Koha hostname=furnique.local 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. HTH! cheers rickw -- _________________________________ 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/)
Rick Welykochy <rick@praxis.com.au> wrote:
4. Restart Apache so it picks up the changes in /etc/koha.conf [...]
This step isn't required for a password change. Koha (C4::Context I think) reads koha.conf, not Apache. You only need to restart Apache if you update koha-httpd.conf (move files or hostnames around, or so). Hope that helps, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
participants (3)
-
MJ Ray -
mohamed fekry -
Rick Welykochy