Resetando a senha do mysql macos

reset-password-mysql-macos

If you don't remember the password you set for root and need to reset it, follow these steps:

    Stop the mysqld server, this varies per install
    Run the server in safe mode with privilege bypass

sudo mysqld_safe --skip-grant-tables;

    In a new window connect to the database, set a new password and flush the permissions & quit:

mysql -u root

For MySQL older than MySQL 5.7 use:

UPDATE mysql.user SET Password=PASSWORD('your-password') WHERE User='root';

For MySQL 5.7+ use:

USE mysql;

UPDATE mysql.user SET authentication_string=PASSWORD("your-password") WHERE User='root';

Refresh and quit:

FLUSH PRIVILEGES;

\q