en Jump to content
vimal

[PrestaShopException] Link to database cannot be established: SQLSTATE[HY000] [1045]

Recommended Posts

Hi,,

Please help me..

i successfully upload my prestashop 1.7 from local to remote Linux server , also upload the database to a new named database. after that i edit the parameters "parameters.php", but there is one error as bellow

 

Link to database cannot be established: SQLSTATE[HY000] [1045] Access denied for user 'hostinga_admin'@'198.15.115.235' (using password: YES)
at line 120 in file classes/db/DbPDO.php

 

please help me to solve this issue as early as possible, i am running out of time now. 

image.thumb.png.84d4cbc9146aec7cf65f6fc86d26133d.png

Share this post


Link to post
Share on other sites

Hi,

Are you able to login into Database server using the same credentials which you have mentioned in the parameters.php file?

Apart from, Can you please try after replacing DB host i.e. 198.15.115.235 to localhost? (Depends upon hosting).

Also, delete the cache from the folder i.e. app/cache (All folders inside the cache folder) & check again.

 

 

Share this post


Link to post
Share on other sites

hi.. thanks for your reply,

 i try that but at that time it show another type of error, i am new to prestashop and web hosting . please help me , i already clear the cache folder 

image.thumb.png.6bc88b53211ede179fa009559b85eff7.png

Share this post


Link to post
Share on other sites

this is my parameters file

 

<?php return array (
  'parameters' => 
  array (
    'database_host' => '198.15.115.235',
    'database_port' => '3306',
    'database_name' => 'hostinga_awawdeh',
    'database_user' => 'hostinga_admin',
    'database_password' => '***************',
    'database_prefix' => 'ps_',
    'database_engine' => 'InnoDB',
    'mailer_transport' => 'smtp',
    'mailer_host' => '198.15.115.235',
    'mailer_user' => NULL,
    'mailer_password' => NULL,
    'secret' => '7NBAAvK3Arstsk3S1sKNr4RwAJygNJ40ImeR91Uu5ITrE2EKFPQGFu71',
    'ps_caching' => 'CacheMemcache',
    'ps_cache_enable' => false,
    'ps_creation_date' => '2018-05-12',
    'locale' => 'en-US',
    'cookie_key' => 'ghG0prkkydpUkuIom3ckK0pJGtgzHJwgyWT9FQiqrrOm9H2oMX5drKWg',
    'cookie_iv' => 'FsoiZEDT',
    'new_cookie_key' => 'def000002a1b9f33e7a60be29e1052234bc519c2788983ff9f3deaa9d36125364f2b54d6a7acb6bd0006df9869ccc3777cf8b7606b571fa4ba8b5a2996e0dd2cece068c8',
  ),
);

?>

 

this is my php myadmin window 

image.thumb.png.6ba42d59e64ec6d9fcd41caaa0600d30.png

Edited by vimal

Share this post


Link to post
Share on other sites

Hi,

I tried to access the Site from the URL i.e. http://98.15.115.235/awawdeh but it's not accessible but while I tried to access your using the URL i.e. http://hosting.redantonline.com/awawdeh/en/ Its working fine.

Kindly check.

 

To access the site using the IP, you need to contact the hosting provider (It might be shared IP & you will not be able to access the site using the IP). 

 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More