changed user on a database and now get blank page

[cruzing]

I had forgotten my user password on a database,read u could just delete the one there and add another one to the same database.Did that with no problems,all seemed good.When I looked at my webpage it's blank;I'm getting"[20-Dec-2012 16:10:13] PHP Fatal error: Uncaught Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'xxxxxxxx_pre2'@'localhost' (using password: YES) thrown in /home1/xxxxxxx/public_html/classes/db/DbPDO.php on line 58".I know this is common by looking for answers.This is how line 58 begins "throw new PrestaShopDatabaseException(sprintf(Tools::displayError('Link to database cannot be established: %s'), $e->getMessage()));

}

 

// UTF-8 support

if ($this->link->exec('SET NAMES \'utf8\'') === false)

throw new PrestaShopDatabaseException(Tools::displayError('PrestaShop Fatal error: no utf-8 support. Please check your server configuration.'));"

Is this telling me that I don't have UTF-8 support ".How can I correct this ?

 

Thank You in advance

[tdr170]

Did you correct the user name in settings.inc.php.

[cruzing]

I only changed the "mysql users"on "my sql databases"and added a new user to the same database.'settings.inc.php."I can't locate that file in "file manager".

[tdr170]

it is in the config folder in the root of your install and by the way you can get your original database username & password from here.

[cruzing]

thanks again tdr170

[DoraKalesi]

Hello!

 

I have a similar problem. I get the following error after uploading the prestashop files to a hosting server:

 

[Thu Feb 28 14:57:00 2013] [warn] [client 2.85.14.176] mod_fcgid: stderr: PHP Fatal error: Uncaught Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'r26121cmo2_user'@'localhost' (using password: YES)

[Thu Feb 28 14:57:00 2013] [warn] [client 2.85.14.176] mod_fcgid: stderr: thrown in /var/www/vhosts/mypbx.gr/leds4you/classes/db/DbPDO.php on line 57

 

 

I have modified the settings.inc.php file like this:

 

<?php

define('_DB_SERVER_', 'localhost');

 

define('_DB_NAME_', 'r26121cmo2_leds');

 

define('_DB_USER_', 'r26121cmo2_user');

 

define('_DB_PASSWD_', 'XXX');

 

define('_DB_PREFIX_', 'ps_');

define('_MYSQL_ENGINE_', 'InnoDB');

define('_PS_CACHING_SYSTEM_', 'CacheMemcache');

define('_PS_CACHE_ENABLED_', '0');

define('_MEDIA_SERVER_1_', '');

define('_MEDIA_SERVER_2_', '');

define('_MEDIA_SERVER_3_', '');

define('_COOKIE_KEY_', 'NI0T145oj9BY19sO2xVvCT87EWjNbhecd0Hhuab4hxunwAvArWzqgvLK');

define('_COOKIE_IV_', '7bpEDzSe');

define('_PS_CREATION_DATE_', '2013-01-28');

define('_PS_VERSION_', '1.5.3.1');

 

I don't really understand what is going on on line 57 of the DbPDO.php file and why I'm getting this error and don't know how to solve this.

 

Could you please help me on this?

 

Thank you in advance

Dora Kalesi

Edited April 10, 2013 by DoraKalesi (see edit history)

[sonitormdp]

I been have the same problem

 

 

define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'my new dbase on server');
define('_DB_USER_', 'the new user for my new dbase');
define('_DB_PASSWD_', 'XXXXXXX');

 

error:

Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user...

 

Could you please help me on this?

 

Thank you in advance!

[vekia]

can you connect with this server, user and password from some external software, like heidisql or mysql workbench?

[sonitormdp]

ohoh! I don't know!

[DoraKalesi]

I am not sure if this was the solution to the problem (I can check my files tomorrow), but a quick suggestion is to try to change the 'localhost' info.

[sonitormdp]

I am not sure if this was the solution to the problem (I can check my files tomorrow), but a quick suggestion is to try to change the 'localhost' info.

 

I changed the 'localhost' info.

[DoraKalesi]

I checked my files and this is how the issue was solved. I changed the 'localhost' info to 'db7.papaki.gr:3306', where my website is hosted. Contact your hosting company to make sure that you are using the right parameter.

[vekia]

follow DoraKalesi suggestion, i think that you use wrong connection informations, you should try to connect to your database from external software like heidisql or something, it is easy in use software and you can check the correctness of connection data

[design_sensation]

Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

 

having this problem for my website, i use my database direct from my website, but still having problem, please inform me what to do...

 

thank you !!!

[vekia]

it's because you trying to conntect to "localhost" and your database isn't on localhost, but on remote server.

[design_sensation]

i was working on my localhost it wasnt working, my server dont want to take database, then i try again direct from server but still same problem.

 

please tell me how i find database for my localhost?

 

thank you !!!

[vekia]

sorry i totally don't understad now

 

so i've got simple question: you have got database on localhost? or not?

[design_sensation]

yes i did make database on phpmyadmin when i start my prestashop setting.

[design_sensation]

i want to upload my website from WAMP server to ONLINE, what can i do?

[design_sensation]

Error

SQL query:

--

-- Database: `sensation`

--

CREATE DATABASE IF NOT EXISTS `sensation` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said:

#1044 - Access denied for user 'sensahncxh_1'@'%' to database 'sensation'

 

 

giving mt this error when i am uploading database

[vekia]

upload all prestashop filesystem, export database from localhost and then import database it on your remote server.

and the most important thing: make sure that you use correct database SERVER, database name, prefix, username and password in config/settings.inc.php file

[design_sensation]

Error

SQL query:

--

-- Database: `sensation_db1`

--

CREATE DATABASE IF NOT EXISTS `sensation_db1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said:

#1044 - Access denied for user 'sensahncxh_1'@'%' to database 'sensation_db1'

 

 

Same problem happening in import,

do i have to change config/settings.inc.php before import or after?

[moustapha]

Tanks tanks tanks

[GeorgeVE]

Hello,i had problem with the category,and after that i had done a rollback to an earlier version,but it totaly did crap my site.

I had done everthing backup up,so after deleting everthing from the server,i did do an restore to everthing,but now i have only a blank webpage,how can i fix this?

Thank you

site http://sokolatea.eu

Edited April 18, 2015 by Gve (see edit history)

[sameerscn]

Link to database cannot be established: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) 

 

 

i am getting this problem while trying to install prestashop in a server. i created database, user, password but still i am unable to install.

 

 

 

<?php

define('_DB_SERVER_', 'localhost');

define('_DB_NAME_', 'prestashop');

define('_DB_USER_', 'root');

define('_DB_PASSWD_', 'iltpc100');

define('_DB_PREFIX_', 'ps_');

define('_MYSQL_ENGINE_', 'InnoDB');

define('_PS_CACHING_SYSTEM_', 'CacheMemcache');

define('_PS_CACHE_ENABLED_', '0');

define('_COOKIE_KEY_', '33O4t14Q9X4jxvhp0bRzHNWPRGX3YG9Fxwo0nTW5rR5DrJfHbMJuXone');

define('_COOKIE_IV_', 'YzOXXRpW');

define('_PS_CREATION_DATE_', '2015-07-15');

if (!defined('_PS_VERSION_'))

define('_PS_VERSION_', '1.6.1.0');

define('_RIJNDAEL_KEY_', 'wjBxoN6Q4DoHUewozKfpi5PT3woKgUwH');

define('_RIJNDAEL_IV_', 'fM8B0vxdHa4F35MjHQGtmQ==');

[jerrypereres]

 

I am changing host for my website and it contains a lot of data. I moved all the data in my domain folder under Public_html directory and then imported all of the DB from PhpMyAdmin. Before importing the database it was showing twenty thirteen theme and Hello world post but after importing it just shows a blank page without giving any error. Although the /wp-admin URL works fine.

[Luk007]

hello every one, im new in this forum, can some one help me solving this error

Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

 

and i have change all my settings to my new dbname, username and password to my new one.

 

it was working fine offline but now i move online it showing me this error

 

im hosting with GODADDY.COM

 

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'xxxx');
define('_DB_USER_', 'xxxx');
define('_DB_PASSWD_'xxxx'');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheMemcache');
define('_PS_CACHE_ENABLED_', '0');
define('_COOKIE_KEY_', 'SKUQJbgR0oLQIB4eK4viYRtg55DHyw4oB3GB9TJwW8HuSfvpgxXftuh6');
define('_COOKIE_IV_', 'mcyaAGPU');
define('_PS_CREATION_DATE_', '2016-02-10');
if (!defined('_PS_VERSION_'))
    define('_PS_VERSION_', '1.6.1.4');
define('_RIJNDAEL_KEY_', 'gDvE3hjZAUWL9PhjSw4KIRmg7dtbG2WX');
define('_RIJNDAEL_IV_', 'uQzUXZ7mK/NHY7fvemkE+A==');
 

 

thank you.

[Luk007]

hello any one there to help please....

[Luk007]

after i change the dbname, usrname and pass. if i visit the site it showing unable to connect and the url address it show "http://localhost/mudatex/index.php?". while i put the normal doname name www.mudatex.co

please help.

 

 

thank you.