mySQL error 1045

[tsunade]

Okay I just keep getting error 1045 (access denied 'root'@local host) Password:Yes. And I can't seem to fix it. Can some one help

+Rep to those who do.

[TheSpidey]

Are you sure your username and password are correct? :P

[tsunade]

I am sure it is...... This is a totally need account..... I

[**Sweeny**]

What i do when this happens to me, I just turn off firewall and reconfigure mySQL. Try that and see if it works.

[tsunade]

I barely ever turn on my firewall it has been off

[**Sweeny**]

and did you try reconfigure it? or using something like mysql51 or mysql4?

[2dgreengiant]

This error occurs when the mysql username and/or password are incorrect.

[wefwef123]

In your conf files replace LOCALHOST with your ip address, that worked for me.

Also make sure root has GRANT ALL access.
Maybe even make a new SQL accounts, grant it access to the DB and change your conf files to use the new account

[RedFox4]

ok i have fixed this problems many times with my own server! so i have an idea...

1.) open the MySQL command prompt
2.) It will ask for your password, just enter it and then press enter
3.) type this into the MySQL command prompt


the line u type on should look like this

mysql>

type this into the prompt to look like this

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION

this should fix ur problem at least i hope