Page 1 of 1

Database error

PostPosted: 30. September 2016 10:40
by Twinset
Hello,
I just reinstalled Xampp because of an error message I could not resolve.
I saved my htdocs files and the data in Myphp file.
Now while opening the local host I have got the following warnings :

Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'CharpentierBois'@'localhost' (using password: YES) in C:\xampp\htdocs\charpentier-bois\wp-includes\wp-db.php on line 1529

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\charpentier-bois\wp-includes\wp-db.php on line 1559

Warning: mysql_connect(): Access denied for user 'CharpentierBois'@'localhost' (using password: YES) in C:\xampp\htdocs\charpentier-bois\wp-includes\wp-db.php on line 1559
Erreur lors de la connexion à la base de données

What could be the problem, now ?
Thanks you for your help.

Re: Database error

PostPosted: 30. September 2016 19:02
by Altrea
Hi,

The user you are trying to use to access the database does not exist or does not have permission.
Recreate the user with phpmyadmin.

best wishes,
Altrea

Re: Database error

PostPosted: 30. September 2016 19:10
by Nobbie
Twinset wrote:Access denied for user 'CharpentierBois'@'localhost' (using password: YES)


What and who is "CharpentierBois"?? That is not Xampp configuration, you must have applied that.

Re: Database error

PostPosted: 03. October 2016 08:59
by Twinset
Thank you for your help.
@Nobbie : CharpentierBois wes my username before I reinstalled my Xampp.

@Altrea : I just recreated the user, thanks, but now Wordpress wants to be reinstalled, and it doesn't work because the databas already exists (I obtain several pages of error messages, I can send you a copy but it is too long to be posted here).

I would like to use my existing database and not recreate it, but perhaps the way to use it is not the good one.

Re: Database error

PostPosted: 03. October 2016 11:16
by Nobbie
Twinset wrote:(I obtain several pages of error messages, I can send you a copy but it is too long to be posted here).

I would like to use my existing database and not recreate it, but perhaps the way to use it is not the good one.


Send it to a WordPress Forum, not to Xampp, as this is a plain WordPress issue. We cannot support third party tools like WordPress here. As far as I know, there is plenty of WordPress documentation about export/import (i.e. also moving from one server to another), did you follow that documentation?

Re: Database error

PostPosted: 03. October 2016 13:53
by Twinset
I did Nobbie.
My problem is difficult to explain : I am using Windows10, I do not know if this is the cause of all the difficulties I have to continue with Xampp.
After several error messages with my control panel I reinstalled Xampp for the second time, but without saving my wordpress sites in developpement. I only kept the Mysql>Data file and the sites in the Htdocs file.
Now Xampp asks me to recreate my database for the site I want to develop, instead of using the one I saved. I know how to create some new databases, but not how the use the one I saved.

Re: Database error

PostPosted: 03. October 2016 14:31
by Nobbie
Twinset wrote:but without saving my wordpress sites in developpement.


Twinset wrote:Now Xampp asks me to recreate my database for the site I want to develop, instead of using the one I saved. I know how to create some new databases, but not how the use the one I saved.


Its a bit confusing, you said "without saving" and then you speak about "the one i saved"?? Anyway, you *should* have done an export of the database, if you are planning to install a new Xampp.

Re: Database error

PostPosted: 03. October 2016 15:09
by Twinset
I did not export my site in development : I just copied the data file before I desinstalled Xampp because I could not access anymore to my localhost when the problem occurred. I could not export the database for the same reason.