It's even worse than it appears.
Sunday January 27, 2019; 1:28 PM EST
Dave's howto for MySQL on Mac
This is how you start from scratch with MySQL on the Mac, assuming all you want is the same experience as what you have on Linux.
and install the package from mysql.com. In the process you will choose a password for the root user. This is important.
In the Mac system settings app, there should be a
for MySQL. Open it and be sure MySQL is started.
In a new Terminal window:
sudo mysql --password
It will ask for two passwords, your Mac system password to authenticate as root, and the password you chose for MySql in the first step. Once you enter both correctly you'll be able to type SQL commands. From here it should behave just like Linux.
for the outstanding support, as always.
Last update: Sunday January 27, 2019; 2:13 PM EST.