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

[Chris Nighswonger]

Hi Sven,

On Fri, Feb 19, 2010 at 6:05 AM, Sven Jankofsky
<sven.jankofsky at 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 at 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 at foundations.edu]
> Gesendet: Donnerstag, 18. Februar 2010 14:15
> An: Sven Jankofsky
> Cc: koha at lists.katipo.co.nz
> Betreff: Re: [Koha] Access denied 'koha'@'localhost'
>
> Hi,
>
> 2010/2/18 Sven Jankofsky <sven.jankofsky at 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
>
>