Error in database

zaryab_helperst

• August 06, 2020 12:42

I have facing the following issue. Please help me what is that.

PDOException Object ( [message:protected] => SQLSTATE[HY000] [1045] Access denied for user 'helperst_referral'@'localhost' (using password: YES) [string:Exception:private] => [code:protected] => 1045 [file:protected] => /home1/helperst/public_html/lib/lib-db.php [line:protected] => 17 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home1/helperst/public_html/lib/lib-db.php => 17 [function] => __construct [class] => PDO [type] => -> [args] => Array ( [0] => mysql:host=localhost;charset=utf8;dbname=helperst_new [1] => helperst_referral [2] => R^]J[aRz-QPN [3] => Array ( [3] => 2 [19] => 2 [20] => ) ) ) [1] => Array ( [file] => /home1/helperst/public_html/1-new-referral.php => 7 [function] => __construct [class] => DB [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => [errorInfo] => )

• 

  andrew.n

  • August 06, 2020 19:46

  Looks like you are either using the wrong database password or when you created the database you didn't set the privileges for the user you are using.

  0
• 

  cPanelLauren

  • August 06, 2020 22:13

  I would be inclined to agree with @andrew.n here how did you create the database and did you create the connection using the correct user/pass through your application?

  0
• 

  zaryab_helperst

  • August 07, 2020 11:37

  I imported some sql tables. But i do not know how to allot privileges to them?

  0
• 

  andrew.n

  • August 09, 2020 09:36

  Login to cPanel, choose MySQL databases, and from that page you can assign privileges to the user.

  0
• 

  zaryab_helperst

  • August 09, 2020 11:32

  No there is not option for imported table. As in cpanel, MYSQL database privileges only allotted to created user.

  0
• 

  andrew.n

  • August 09, 2020 13:03

  There is no difference just re-apply the settings and it should work.

  0

Please sign in to leave a comment.