Reset MYSQL root password

Question

I have windows 7 and MYsql is installed on that. I am facing now and then one big issue ... very frequently the root passwords locks and i get the below error SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES)

Now to resolve this i use the below steps

Stop running Mysql service first (Administrative tools > Services )
Open command prompt (cmd) and reach the directory (using CD command) where Mysql bin is installed (eg: C:/Program Files/Mysql/bin)
type mysqld.exe -u root –skip-grant-tables and press enter (don’t close this command prompt)
Open new command prompt and reach the same Mysql bin directory
type mysql and press enter (This time, it never prompts for any passwords and you can enter mysql console)
type command use mysql to switch your database into mysql
Execute the usual command to change password for rootUPDATE user SET Password = PASSWORD(‘your_new_password’) WHERE User = ‘root’;
Close the command prompts and go to services , start mysql. Now you can login with your new root password

but still this === mysqld.exe -u root –skip-grant-tables does not respond....

Please help with the root cause and resolution

Not responding? What do you mean? If you mean that the console is not released for all the input so it should be. — Adam
– Adam, Commented Oct 29, 2011 at 18:03
Define "now and then", after posting this on the correct website. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Oct 29, 2011 at 18:23
@Adam: Please, if you do not have enough rep to comment then the correct reaction is to wait until you have enough rep before commenting, rather than finding some completely inappropriate place to write your text instead. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Oct 29, 2011 at 23:06

Rich Benner · Accepted Answer · 2016-07-07 15:50:15Z

Follow these steps to hard reset:

Stop Mysql service from task manager
Create a text file and paste the below statement

MySQL 5.7.5 and earlier:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yournewpassword');

MySQL 5.7.6 and later:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'yournewpassword';

Save as mysql-init.txt and place it in 'C' drive.
Open command prompt and paste the following

C:> mysqld --init-file=C:\mysql-init.txt

Collectives™ on Stack Overflow

Reset MYSQL root password

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related