How to reset mysql server root password on Unix,MacOS(2024)

preview_player
Показать описание
There can be chances you lost root password and need to reset it. Following are steps mentioned below.
Error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Steps :

System Preferencs
Stop mysql server

Login to terminal
Sudo pkill mysqld
cd /usr/local/mysql/bin
Sudo mysqld_safe --skip-grant-tables --skip-networking
cd /usr/local/mysql/bin
mysql -u root
FLUSH PRIVILEGES;
FLUSH PRIVILEGES;
Quit;
Sudo pkill mysqld
Рекомендации по теме
Комментарии
Автор

It's giving error
mysql -u root

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

AdityaKumar-cuzg
Автор

On new versions of mac, I do not see the system preferences it is showing system settings instead.

jadvindersingh