Database error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Database error

Postby Twinset » 30. September 2016 10:40

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.
Twinset
 
Posts: 4
Joined: 30. September 2016 10:33
XAMPP version: 3.2.2
Operating System: Windows10

Re: Database error

Postby Altrea » 30. September 2016 19:02

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Database error

Postby Nobbie » 30. September 2016 19:10

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.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Database error

Postby Twinset » 03. October 2016 08:59

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.
Twinset
 
Posts: 4
Joined: 30. September 2016 10:33
XAMPP version: 3.2.2
Operating System: Windows10

Re: Database error

Postby Nobbie » 03. October 2016 11:16

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?
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Database error

Postby Twinset » 03. October 2016 13:53

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.
Twinset
 
Posts: 4
Joined: 30. September 2016 10:33
XAMPP version: 3.2.2
Operating System: Windows10

Re: Database error

Postby Nobbie » 03. October 2016 14:31

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.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Database error

Postby Twinset » 03. October 2016 15:09

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.
Twinset
 
Posts: 4
Joined: 30. September 2016 10:33
XAMPP version: 3.2.2
Operating System: Windows10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 130 guests