MariaDB "Access Denied" on MacOS
If you faced Access Denied while logging to MySQL prompt, Read on.
The issue came after I installed MariaDB on my Mac (Pro, Catalina) using instructions from https://mariadb.com/resources/blog/installing-mariadb-10-1-16-on-mac-os-x-with-homebrew/
mysql -u root -p was repeatedly giving Access Denied. I tried using blank, laptop password. I also tried by supplying installation user to no avail.
Finally, I was able to solve it by going to System Preferences. I could see a MySQL icon.
I went into MySQL, and navigated to Initialize Database.
Entered a password of my choice, and Restarted the DB.
Tried mysql -u root -p, and use password given in last step.
It works now.
The issue came after I installed MariaDB on my Mac (Pro, Catalina) using instructions from https://mariadb.com/resources/blog/installing-mariadb-10-1-16-on-mac-os-x-with-homebrew/
mysql -u root -p was repeatedly giving Access Denied. I tried using blank, laptop password. I also tried by supplying installation user to no avail.
Finally, I was able to solve it by going to System Preferences. I could see a MySQL icon.
I went into MySQL, and navigated to Initialize Database.
Entered a password of my choice, and Restarted the DB.
Tried mysql -u root -p, and use password given in last step.
It works now.
Comments
Post a Comment