MySQL Forums
Forum List  »  Install & Repo

Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES)
Posted by: Linda Carlos
Date: February 24, 2010 09:15AM

Adam M Wrote:
-------------------------------------------------------
> I had this same problem, annoyed me for hours...
>
> What I have realised is that the "MySQL Server
> Instance Config Wizard" does NOT set your
> password!
>
> This is what I did....
>
> I clicked Skip on the dialog that states the Error
> 1045...
> Then cancelled the "MySQL Server Instance Config
> Wizard"
>
> Now...
>
> Open a command prompt type "mysql -u root -p" then
> hit enter again when it requests a password.
>
> You should now have access to the mysql
> monitor...
>
> type the following at the prompts...
>
> mysql>use mysql
> mysql>select user, host, password from user;
> # Now you should see that u have 3 entries
> +-----------------------------+
> | user | host | password |
> +-----------------------------+
> | root | localhost | |
> | root | 127.0.0.1 | |
> | | localhost | |
> +-----------------------------+
>
> mysql> delete from user where host="localhost" and
> user="";
> mysql> update user set password=password("xxxx")
> where user="root";
> mysql> flush tables;
> mysql> flush privileges;
> mysql> quit
>
> Now the mysql table should be updated and
> everything fixed.
>
> Try it out...
>
> At the command prompt type "mysql -u root -p" then
> hit enter your new password when it requests.
>
> As long as you have allowed an exception for MySQL
> on port 3306 in either windows firewall or any
> other firewall software you're using, things
> should work fine...

I still someone that could help me with this if possible...

Options: ReplyQuote


Subject
Written By
Posted
August 23, 2010 05:37AM
October 08, 2010 02:25PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES)
February 24, 2010 09:15AM
October 15, 2011 11:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.