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

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
BigGiraffe
Posts: 7
Joined: Tue Aug 15, 2006 9:52 pm

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

Post by 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:
User avatar
devo
Posts: 798
Joined: Mon Jun 15, 2009 1:19 pm

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

Post by devo »

connecting to the mysql from the same machine?
A hero of war is that what they see...
BigGiraffe
Posts: 7
Joined: Tue Aug 15, 2006 9:52 pm

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

Post by BigGiraffe »

Yes, it is on the same machine.
User avatar
devo
Posts: 798
Joined: Mon Jun 15, 2009 1:19 pm

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

Post by devo »

mysql is running? you started it?
A hero of war is that what they see...
BigGiraffe
Posts: 7
Joined: Tue Aug 15, 2006 9:52 pm

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

Post by BigGiraffe »

Its turned on by the installer program itself.
User avatar
LiquidIce
Posts: 90
Joined: Wed Oct 18, 2006 4:17 pm
Location: Spain

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

Post by 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.
When the rich wage war, its the poor who die.
BigGiraffe
Posts: 7
Joined: Tue Aug 15, 2006 9:52 pm

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

Post by 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?
User avatar
LiquidIce
Posts: 90
Joined: Wed Oct 18, 2006 4:17 pm
Location: Spain

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

Post by LiquidIce »

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('PASS HERE');
When the rich wage war, its the poor who die.
BigGiraffe
Posts: 7
Joined: Tue Aug 15, 2006 9:52 pm

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

Post by 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?
User avatar
devo
Posts: 798
Joined: Mon Jun 15, 2009 1:19 pm

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

Post by devo »

just run mysql wizzard tool, and set password there.
A hero of war is that what they see...
BigGiraffe
Posts: 7
Joined: Tue Aug 15, 2006 9:52 pm

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

Post by BigGiraffe »

The wizard tool does not allow me to set security, it gives that error above when trying to set security for mySQL.
User avatar
LiquidIce
Posts: 90
Joined: Wed Oct 18, 2006 4:17 pm
Location: Spain

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

Post by 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.
When the rich wage war, its the poor who die.
Post Reply