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.

Comments

Popular posts from this blog

AWS RDS incompatible-parameters solved

504 Gateway Timeout on Amazon AWS ELB (Elastic Load Balancer)