[MySQL]Access denied for user 'root'@'localhost' (using pass

[BigGiraffe]

I don't even have the server installed yet. I am trying to install MySQL for it, but it keeps giving the "Access denied for user 'root'@'localhost' (using password: YES) " error when setting up security. That is with everything enabled, even when I tried setting it up without having any firewalls at all enabled (even windows firewall disabled)

Navicat gives the same error when I try to connect to it.

The password is correct and I am at a loss about what is wrong with it.

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

[devo]

connecting to the mysql from the same machine?

[BigGiraffe]

Yes, it is on the same machine.

[devo]

mysql is running? you started it?

[BigGiraffe]

Its turned on by the installer program itself.

[LiquidIce]

Using password=YES means that you are inputting a password, when it is not required. That means that you have to re-apply the mysql security settings with a new password, and to be sure if you are, or are not using a password, go to RUN, then type in CMD, when inside CMD, type in mysql, if mysql opens up correctly, that means you have no password assigned, if you type in "mysql" (without " ") and the cmd window closes on you, it means you have a password and it must be inserted the following way... Go to CMD, then type in "mysql -uroot -p(password)" without the " " and the password goes next to the -p without a space.

[BigGiraffe]

Ok, it seems like I don't have a password assigned. That must be because assigning security to mysql in the installer always for some reason fails for me.

How do I give it a password?

[LiquidIce]

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('PASS HERE');

[BigGiraffe]

Typing that in mysql simply gives me a new prompt and the password isn't changed. Is it supposed to be applied or something before leaving?

[devo]

just run mysql wizzard tool, and set password there.

[BigGiraffe]

The wizard tool does not allow me to set security, it gives that error above when trying to set security for mySQL.

[LiquidIce]

Why dont you get a tool i use thats called "WAMP", it brings apache, mysql for all in 1. It works for putting websites on your computer's localhost for tests and all. And there are multiple ways to fix the security settings. Totally reinstall mysql, uninstall mysql, delete the folder, make sure the services are deleted, and then retry it.