ERREUR 1045 MYSQL

Question

Hello,

I'm cracking up: I followed the book to the letter to install MySQL and everything is going well except that at the end it gives me error 1045
access denied for user 'root'@'localhost' (using password YES)

What should I do?

Thank you for your help because I'm at my wit's end!

Configuration: Windows XP Internet Explorer 6.0

xian95 · Accepted Answer

With WAMP, you need to go to the config.inc.php file in wamp\apps\phpmyadmin3.1.1
and add the password in this file
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'yourpassword';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

I often had to find this file and after that everything goes well.

Emma · Answer

I am encountering the same difficulty even though I have disabled the Windows Firewall.  Thank you in advance for your help.

diwan-bzh · Answer

Hello,

Quote from malicia669: "I followed the book to the letter to install mysql"

___Yes, Mysql is installed, but it cannot connect without the password,

Quote from Emma: "I'm facing the same difficulty even though I've disabled the Windows Firewall."

___Ouch, no relation to the firewall, Mysql just needs a valid password: "(using password YES')"

Just follow the procedure at this address: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Good luck!

Link to the manual: http://dev.mysql.com/doc/refman/5.0/en/index.html

Emma · Answer

Thank you for your response. In fact, the password is valid on my end. I will look into the link you provided when I'm done with the Tomcat configuration!  For now, have a great day  Emma

mollarev · Answer

Hello, here is the message I see when I try to connect to a site... MySQL Error : 1045 - Access denied for user: 'dbo209435432@localhost' (Using password: YES) What is the cause? Thank you.

penegale · Answer

Hi! Well, it's just that the website is poorly designed... Let me explain, the password used by the site to connect to their database is incorrect ^^  This has nothing to do with you.

scoubidou944 · Answer

glop glop,  I just fixed a similar problem. Indeed, it seems to not want strong passwords with punctuation marks ([,$,(...) So it remains: a-z, A-Z, 0-9  ++

ladin · Answer

malicia669 how did you manage to get through it because for me until now it’s still not working error

Stéphanie · Answer

Hello, I have practically the same problem: "error 1045: access denied for user 'root'@'localhost' but it says no for the password: "(using password NO')" How can access be denied if it doesn't ask for a password?

Can you help me?
Thank you

xian95 · Answer

I noticed that I had a lot of config.inc.php files on my hard drive: I looked at where they were located.
I kept only the one I had in xxx/wamps/apps and I checked that it had the password I wanted.
Good luck!

Miloud_J2EE · Answer

Often this is due to a poor uninstallation of a MYSQL component.
This results in security entries in the registry. The best way is to format your computer if you cannot get rid of these entries. I have the same error:
1045 - Access denied for user: 'dbsa@localhost' (Using password: YES)
I started with a completely fresh registry and I managed to get mySQL working completely
Miloud_J2ee

Nwolk · Answer

I've followed this tutorial about ten times (and Jujuzilla's one too) but I couldn't connect. However, I eventually succeeded by using radical means (I admit I didn't believe it would work, but it did).

1/ Uninstall Wamp (don't forget to manually delete the Wamp folder in C:)

2/ Unplug the modem

3/ Use CCleaner and delete absolutely everything

4/ Plug the modem back in

5/ Reinstall Wamp

ERREUR 1045 MYSQL

12 answers

How to delete quarantine files in defender?

Https://www.youtube.com/@topblazo

Unable to type the at-sign

Reinstallation of w11 impossible after pc crash...

Download impossible for visual petanque

Connect external dvd player to samsung tablet

Phone not receiving certain sms

Images from videos - retrieval

Chkdsk /f and sfc /scannow okay, but startup impossible.

Recover deleted messages