Data base error

[Susan Rae Bates]

This happened yesterday. I cannot log in to our organization forum,either as a participant or an admin.Can anyone help? I am told that our members are receiving the same message. I have no clue what happened.


SQL error: Access denied for user 'susanrb'@'localhost' (using password: NO)

SQL error code: 1045

Date: Thursday 06th November 2014 08:10:47 PM

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Date: Thu, 06 Nov 2014 20:10:47 +0000

Error: 1045 - Access denied for user 'susanrb'@'localhost' (using password: NO)

IP Address: 199.15.219.25 - /index.php?app=core&module=global&section=login&do=process

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

| File | Function | Line No. |

|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

| admin/sources/handlers/han_login.php | [login_external].authenticate | 671 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

| admin/sources/handlers/han_login.php | [han_login].loginAuthenticate | 319 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

| admin/applications/core/modules_public/global/login.php | [han_login].verifyLogin | 445 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

| admin/applications/core/modules_public/global/login.php | [public_core_global_login].doLogin | 107 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

| admin/sources/base/ipsController.php | [public_core_global_login].doExecute | 302 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

[Aiwa]

Error: 1045 - Access denied for user 'susanrb'@'localhost' (using password: NO)

Using password... no???

Check your conf_global.php file and make sure the sql_host, sql_user and sql_pass vars are set and make sure they are correct for your sql_database.

[ASTRAPI]

As Aiwa says check the settings on your conf_global.php - (database, user, password)

You may run this command to add the user to database and give permissions also with a password that you can add after that on your conf_global.php.

GRANT ALL PRIVILEGES ON *.* TO 'susanrb'@'localhost' IDENTIFIED BY 'newpasswordhere';

You may want to replace the *.* with your database name or you can try it as it is and see if it works....

Then run:

FLUSH PRIVILEGES;

You can also check for any setting related to bind-address = in your /etc/my.cnf

Try them and let us know :smile: