Reset MySQL 8 Database root user password on MacOS Big Sur

Reset MySQL 8 Database root user password on MacOS Big Sur. If you forgot MySQL root user password on your macOS operating system. No problem! This video will help you reset root user password on MySQL database. In this video tutorials we will two types of error message.
Solution: This error is caused when your MySQL server instance is not running. We will learn how to start MySQL database server instance.
Error 2: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Solution: This error is caused when you enter invalid database user password. We will learn how to reset MySQL non root user account password, as well as root user account password.
Follow the password reset steps given in this video tutorial and let me know if it works for you. If you encounter errors or didn't understand something, feel free to ask me questions in comments section of this video.

# Chapters #

0:00 Introduction
02:56 Fix Error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
03:58 Reset MySQL database non root user account password
07:45 Reset MySQL database root user account password
13:36 End message, try yourself, ask question

#ResetMySQLPassword #MacOS #MySQL #MySQL8 #Password #Reset

[atombarako]

Thank you very much for the step-by-step instructions. I spent quite some time searching online and could not make it work until I found your video!

[shivashankarirajaram]

OH MY GOD!!! YOU ARE A SAVIOUR!!! Out of like honestly several videos that lead me nowhere, this was the most useful video that helped me reset my MySQL root password!! IT WORKED!!! I'm super excited because the struggle is REAL!!

[edrod]

Thank you man! You're the boss! I had a few school projects I wanted to get back to and could not remember my password for the life of me.

[kishanpatel]

Hi Pradnyankur.

Whenever I am trying to run the mysql server it's automatically stop's running server will you please help me out for this?

[ianmonat]

I'm at 11:04 in the video entering mysql -u root and getting this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)...any idea what's happening?

[monkey.d.gojira]

Thank you this was very helpful!
People ensure to check if conda is deactivate in both terminals if you are facing issues.

[Артём-фбю]

You just best! I couldn't solve this problem for a long time, but you really help me. Thank you so much!

[arihajain]

mysql -u root command didn't work for me! it gave error. any other alternative or suggestion on this?

[oxide_digno]

After mysql -u root -p ask for my root password and that’s what I don’t remember and i tried one says error 1045 ( 28000) pla sir help me

[bearinny]

Whenever Im in the step of " sudo mysqld_safe ... --skip-networking ", I always get " sudo: mysqld: command not found " . What should I do in this case? I was keep trying to find a way for sudo command to work, but it didn't work

[munirh]

Easy to follow just what I was looking for. Thank you

[Miki-frbu]

i have a problem that when i start mysql server from the settings, its just remain 2-3 seconds and stoped alone, it keep starting and stoping, how can i solve this sir?

[ahmedhashmi]

for me, it says that mysql not found under the directory you've mentioned "/usr/local/mysql/bin" How do I reset the password then?

[sandeepsanyal]

Thank you. Learnt a very important thing.

Can you make a tutorial on how to move mysql data to an external hdd and load sql from there? Need this as my mac does not have enough space to hold mysql tables. Will appreciate it.

[abdulraqibabdulmajeed]

Hello, my sql server keeps blinking red and green on my Mac, I uninstalled it and reinstalled.. but nothing . I also tried installing it using brew on my terminal but got too many errors, please I need help

[adielortega]

What if you can't access your mysql from your terminal it says no such file or directory. How to fix it and access the file. I am using XAMPP to connect to phpmyadmin.

[AliHasan-qo]

Hi sir for me its showing access denied to the bin folder. Can you help ?

[BBUNNYop]

my sql server getting close immediately when i started the server from setting, what to do ?

[miguelaquilesplazarosillon]

Thanks a lot! It really helped me recovering the root password

[abhijith]

for me is it showing
sudo: mysqld_safe: command not found
when i type sudo mysqld_safe --skip-grand-tables --skip-networking
so pls help me out