Install failed (access denied) creating MySQL database
I have a Fedora Core 5 box, MySQL 5.0.27 and Koha 2.2.9. During the creating database stage of the install I get a failure with: ERROR 1045 (28000):Access denied for user 'kohaadmin'@'localhost' (using password: YES) Some of the searches I come accross suggest that there is a problem with Koha 2.2 and mySQL 5. Is this the case or it there some other setup problem? Anyone out there using this combo and if so how did you get it installed? Or do I have to uninstall mySQL 5 and go back to 4. Any write ups on how to do this? Dave -- View this message in context: http://www.nabble.com/Install-failed-%28access-denied%29-creating-MySQL-data... Sent from the Koha - Discuss mailing list archive at Nabble.com.
Hi , This is due to your mysql user kohaadmin permission plz check your kohaadmin user permission. DBurgess wrote:
I have a Fedora Core 5 box, MySQL 5.0.27 and Koha 2.2.9. During the creating database stage of the install I get a failure with:
ERROR 1045 (28000):Access denied for user 'kohaadmin'@'localhost' (using password: YES)
Some of the searches I come accross suggest that there is a problem with Koha 2.2 and mySQL 5. Is this the case or it there some other setup problem?
Anyone out there using this combo and if so how did you get it installed? Or do I have to uninstall mySQL 5 and go back to 4. Any write ups on how to do this?
Dave
----- Amit Gupta +91-9891559754 -- View this message in context: http://www.nabble.com/Install-failed-%28access-denied%29-creating-MySQL-data... Sent from the Koha - Discuss mailing list archive at Nabble.com.
On 2008/04/15, at 4:18 PM, amitg wrote:
Hi , This is due to your mysql user kohaadmin permission plz check your kohaadmin user permission.
DBurgess wrote:
I have a Fedora Core 5 box, MySQL 5.0.27 and Koha 2.2.9. During the creating database stage of the install I get a failure with:
ERROR 1045 (28000):Access denied for user 'kohaadmin'@'localhost' (using password: YES)
Hiya Dave Try something like this first on your DB... mysql> grant all on koha.* to kohaadmin@localhost identified by 'mypassword'; Then check your koha.conf file to confirm your password in there, is the same.. That should solve your access issue. Cheers, Mason
Installed phpMyAdmin, not sure how but the kohaadmin user created during setup not associated with localhost. Added a new kohaadmin/localhost with all required privilages. Deleted database and ran insaller successfully. Thanks for the help. Mason James-5 wrote:
On 2008/04/15, at 4:18 PM, amitg wrote:
Hi , This is due to your mysql user kohaadmin permission plz check your kohaadmin user permission.
DBurgess wrote:
I have a Fedora Core 5 box, MySQL 5.0.27 and Koha 2.2.9. During the creating database stage of the install I get a failure with:
ERROR 1045 (28000):Access denied for user 'kohaadmin'@'localhost' (using password: YES)
Hiya Dave
Try something like this first on your DB...
mysql> grant all on koha.* to kohaadmin@localhost identified by 'mypassword';
Then check your koha.conf file to confirm your password in there, is the same..
That should solve your access issue.
Cheers, Mason
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Install-failed-%28access-denied%29-creating-MySQL-data... Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (3)
-
amitg -
DBurgess -
Mason James