Database Access Denied issue

[eric.toronto]

There seems to be an issue with my database. is this an issue you have to correct on your end or is it something I can on my end? The issues are listed below.

[Dbase Select failed] ( 1044 : Access denied for user 'efran_efran'@'int.chopin.x10hosting.com' to database 'efran_efran' )

Can't connect to database! Please notify webmaster

Thank you.
Eric

 

[vishal]

The db server name should be localhost

 

[galaxyAbstractor]

Have you created that user in your cPanel, and assigned it with correct privilegies to the database?

 

[eric.toronto]

the database has been working fine until yesterday. i did a check on it and these results came back ok. I would have no reason to change anything and when i went into hesk install/setup i get this:

Hesk 0.94.1 installation script


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

INSTALLATION STEPS:
1. License agreement -> 2. Check setup -> 3. Database settings -> 4. Setup database tables

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


Database settings
Hesk will not work unless the information below is correct and database connection test is successful. For correct database information contact your hosting company, I cannot help you find this information!

Database Host:
Database Name:
Database User (login):
User Password:



Database Check through cPanel:

Checking Database
efran_efran is now being checked.

efran_efran.hesk_attachments OK efran_efran.hesk_categories OK efran_efran.hesk_replies OK efran_efran.hesk_std_replies OK efran_efran.hesk_tickets OK efran_efran.hesk_users OK efran_efran.livehelp_autoinvite OK efran_efran.livehelp_channels OK efran_efran.livehelp_config OK efran_efran.livehelp_departments OK efran_efran.livehelp_identity_daily OK efran_efran.livehelp_identity_monthly OK efran_efran.livehelp_keywords_daily OK efran_efran.livehelp_keywords_monthly OK efran_efran.livehelp_layerinvites OK efran_efran.livehelp_leavemessage OK efran_efran.livehelp_messages OK efran_efran.livehelp_modules OK efran_efran.livehelp_modules_dep OK efran_efran.livehelp_operator_channels OK efran_efran.livehelp_operator_departments OK efran_efran.livehelp_operator_history OK efran_efran.livehelp_paths_firsts OK efran_efran.livehelp_paths_monthly OK efran_efran.livehelp_qa OK efran_efran.livehelp_questions OK efran_efran.livehelp_quick OK efran_efran.livehelp_referers_daily OK efran_efran.livehelp_referers_monthly OK efran_efran.livehelp_sessions OK efran_efran.livehelp_smilies OK efran_efran.livehelp_transcripts OK efran_efran.livehelp_users OK efran_efran.livehelp_visit_track OK efran_efran.livehelp_visits_daily OK efran_efran.livehelp_visits_monthly OK

Check Complete

Any suggestions would be appreciated.

thanks again.

Eric

 

[eric.toronto]

ok i resolved the issue. even though all the boxes had a check mark in them, i had to place a check mark in the "ALL PRIVILEGES" and update before it would actually allow me to access the database properly.

please close this ticket.

thank you for your help.

eric


ALL PRIVILEGES SELECT CREATE INSERT ALTER UPDATE DROP DELETE LOCK TABLES INDEX REFERENCES CREATE TEMPORARY TABLES CREATE ROUTINE