Database_Exception [ 1044 ]: Access denied for user \'\'@\'localhost\' to database \'


#1

Hi,

I’d like to try SwiftRiver. I cloned the repo on GitHub and followed the installation instruction at https://wiki.ushahidi.com/display/WIKI/Installing+SwiftRiver.

I of course configured the database.php file with the right db and credential.

When I try to open the index page I get:

Database_Exception [ 1044 ]: Access denied for user ‘’@‘localhost’ to database ‘kohana’

MODPATH/database/classes/Kohana/Database/MySQL.php [ 108 ]

 

In the instruction I can’t find any referral to kohana database … May be I have to create it?

In addition: the error says Access denied for user ‘’ … semms using no user.

Any help?

Thank you

Lorenzo.


#2

Hey Lorenzo,

This looks like an issue with the mysql server authentication. Have you added the correct username and password information to connect to the database?

Angela


#3

If you refer to

Update the database configuration

as explained in https://wiki.ushahidi.com/display/WIKI/Installing+SwiftRiver  … yes, I did.

 


#4

Have a look at this section.

‘connection’ => array(

            ‘hostname’   => ‘localhost’,

            ‘database’   => ‘’,

            ‘username’   => ‘’,

            ‘password’   => ‘’,

            ‘persistent’ => FALSE,

        ),

The ‘database’ field should be the name of your swiftriver database, ‘username’ should be the username you use to log into your mysql server e.g ‘root’ or whatever you set it as before, and ‘password’ should be the password corresponding to the username given above.

Are all these details in your configuration file correct?


#5

Yes

I changed the default file with the information required.

I’ll verify again asap, but I’m sure of the changing.

Any other possible cause? the error message talk about a kahana database (that is not the name of my swiftriver db…)


#6

I verified the file. As I remembered, I made the required changes, using my swiftriver database name, user and password.

:frowning:


#7

Lorenzo,

Mind sending me your configuration file to angela@ushahidi.com?

Angela