Skip to content

Instantly share code, notes, and snippets.

@mucyomiller
Last active March 5, 2020 12:39
Show Gist options
  • Save mucyomiller/7f22210fd83b59772bc6dcfe7c5b604f to your computer and use it in GitHub Desktop.
Save mucyomiller/7f22210fd83b59772bc6dcfe7c5b604f to your computer and use it in GitHub Desktop.
Changing MariaDB password on Mac Catalina
$ mysql.server stop 

or

$ brew services stop mariadb 

or

$ mysqladmin shutdown

then start mariab db with

$ mysqld --skip-grant-tables &

open new terminal tab and run

$ mysql

then flush privileges

MariaDB [(none)]> flush privileges;

now set your new password as eg: 1234

MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment