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

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.


Popular posts from this blog

AWS RDS incompatible-parameters solved

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