Failure to install mysql on macOS Mojave

by Projjol   Last Updated September 11, 2019 23:12 PM

I've moved to a new machine and installing MySQL is turning out to be quite an issue (the last time I installed it on a mac it was quite seamless).

I used two approaches to install MySQL: brew and the offical installer

Brew:

I started with brew install mysql. This installed the latest version of MySQL. It initially worked and I could log into the root user without a password. When I tried to set the password for the root account I ended up being locked out of the root account. I proceeded to uninstall that version of MySQL and tried a different version (5.7). When I installed that I got the following error: ERROR 2061 (HY000): Authentication plugin 'sha256_password' reported error: Authentication requires SSL encryption. I ended up uninstalling that version of MySQL as well.

Native Package:

Tried the latest version was asked for a password but could not login to the root user with the password. Received this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'. Additionally I could not run mysql.server start, received the following error: command not found: mysql.server. I did not add anything to my PATH, should I have done that?

Additionally, this is how the MySQL widget in the System Information looks like. I tried pressing Start MySQL Server a bunch of times, it would start and almost immediately stop.

Can anyone suggest a clean way in which I can remove all these defunct installations and have a clean MySQL install?

MySQL server not starting



Related Questions


Is brew using MySQL or MariaDB

Updated January 24, 2019 17:12 PM

How to proper setting root mysql password

Updated April 28, 2019 16:12 PM


Unable to start mysql 5.6

Updated February 24, 2019 22:12 PM