Re: [Koha] Access denied 'koha'@'localhost'

19 Feb 2010

      Hi Sven,

On Fri, Feb 19, 2010 at 6:05 AM, Sven Jankofsky
<sven.jankofsky@tfh-wildau.de> wrote:
...
Thanks for the help.
I tried to change the mysql pw by using webmin. There are two pw possible but both did not work. could you tell me where to check the pw koha is using?
Run the mysql client from a terminal window as your kohauser and do this:

SHOW GRANTS\G

The results should look something like this:

mysql> SHOW GRANTS\G
*************************** 1. row ***************************
Grants for kohaadmin@localhost: GRANT ALL ON koha.* TO
'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD '<password hash>'

If it does not, you need to:

1. exit the mysql client
2. log back into the client as user root
3. execute something like this:

GRANT ALL ON koha.* TO 'kohaadmin'@'localhost' IDENTIFIED BY
'<superSECRETpassword>';

4. verify that the username/password used here match that in koha-conf.xml

This information can also be found in the INSTALL.* file in the root
of the directory where you extracted the Koha archive or the root of
the git repo which matches your platform.

Kind Regards,
Chris
...
-----Ursprüngliche Nachricht-----
Von: Chris Nighswonger [mailto:cnighswonger@foundations.edu]
Gesendet: Donnerstag, 18. Februar 2010 14:15
An: Sven Jankofsky
Cc: koha@lists.katipo.co.nz
Betreff: Re: [Koha] Access denied 'koha'@'localhost'
Hi,
2010/2/18 Sven Jankofsky <sven.jankofsky@tfh-wildau.de>:
...
Hi,
 I got the following message after updating Lib::XML and Lib::XSLT :
Access denied for user 'koha'@'localhost' (using password: YES) at
/usr/share/koha/lib/C4/Context.pm line 646.
Unless you changed the koha username for mysql, it is 'kohaadmin'
rather than 'koha'
If you did, it appears there may be a permissions issue in mysql.  Log
in to mysql using your 'koha' user and check 'SHOW GRANTS;'
Kind Regards,
Chris