access denied for user 'root'@'localhost' (using password no) mac solved

How to solve Access denied for user 'root'@'localhost' using password: YES or Access denied for user 'root'@'localhost' (using password: NO) or reseting the mysql password or how to solve forget password in mac, How to reset forgotten MySQL ROOT password in mac

[kathleendavis]

I spent an entire day trying to figure this out before I found your video. You're a genius. Thank you!

[adityarprasanna]

after wasting more than half a day on a billion forums and videos, this 3 minute video was all i needed. thank you :')

[mayyadanartun]

When I write" update user set authentication_String = PASSWORD("newpass") where user='root'; "
this error occurs "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '("123456") where user = 'root'' at line 1 "

[Mary-xwwj]

Can't believe I've spent hours looking for something that would solve my problem before I found this video. Thank you so so so soooo much!

[carloscontreras]

THANK YOU!

List of codes for copy paste:

cd /usr/local/mysql/bin
./mysql -u root -p

sudo --skip-grant-tables
sudo /usr/local/mysql/bin/mysql -u root

Use mysql;

update user set authentication_String = PASSWORD (“PUT THE NEW PASSWORD YOU WANT TO USE”) where user='root';
FLUSH PRIVILEGES;
\q;

cd /usr/local/mysql/bin
./mysql -u root -p

In the last password don’t use your Mac’s password, use the one you used in this code:update user set authentication_String = PASSWORD (“PUT THE NEW PASSWORD YOU WANT TO USE”) where user='root' ;

(In that code he uses “newpass” as an example but you can put whatever you want.)

[sakanolio]

Almost gave up on solving this til I found this video...Thank you so much!!

[jakestewart]

MySQL 8+ do this after skip grant tables:

UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;

mysql -u root

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

[cassandralehman]

THIS SAVED MY LIFE!! I have spent the entire day trying to get into the workbench. THANK YOU FOR THIS TUTORIAL!!!

[zl]

you save my life! I can't believe I wasted so much time on resetting pwd.. wish I could hit the like buttons more than once

[itsmia]

THANK YOU! This was very helpful, I wish I could have found your video sooner. In 3 minutes you solved my problem and I wasted hours & hours in forums looking for a solution... Thank you, again :)

[jofrosti]

THANK YOU SO MUCH!!!! I've been trying to fix this for the past hour and a half. This helped tremendously.

[IRLVaporwave]

this topic deserves such an epic intro

[bazarsadtsogtjargal]

After 3 weeks of struggling, this 3 minutes of video helped. thank you!

[rupalagrawal]

thanks a lot. The only solution on the internet that works as stated!

[Worldexplorer]

That’s all it takes?! 3 minutes?! Been stuck for hours :(. Thank you!

[Sejfullah]

SOMEBODYYYY GIVE THIS MAN COOOKIEEE THANK YOU! THANK YOU! THANK YOU!!!!

[sherrylii]

Thanks for your help. maybe there's new syntax update in MySQL 8, when I came to the step " update user set authentication_String = PASSWORD("newpass") where user='root'; "
this "ERROR 1064 (42000) occurs

[quyetbuihuu]

Thank you so much! I was so confused about mysql and you video helped me solve my problem.

[jwalandapariyar]

Thank you so much.. i was about to throw my laptop from the window.

[Snyoreetaaa]

Thank you so much!! i have been stuck from completing my senior project because of this issue and finally i can use workbench!! you are my hero XD