Running MySQL on Mac

[scripting]

Installing and running MySQL on Linux is quick and easy. But on a Mac? I can't seem to get it to start. I have it installed.

Notes --

1. I want to access the database in Terminal. I don't want to use anything else.

2. I don't want MAMP. I just want MySQL.

3. I basically want what I have on Linux running on my Mac.

UPDATE -- problem solved. Thanks to @papascott.

[scripting]

I've been really clear about what I want to do. Instead of answering suggestions that I do something else with "No I don't want to do that' -- I'm just going to delete them. Don't be offended.

[papascott]

I think it depends on how you installed it. If you installed the package from mysql.com, they put the binaries in /usr/local/mysql/bin. They also offer a Preference Pane for MacOS for the MacOS System Preferences to start and stop the server. That might be the easiest way to set it up so the server always runs (just like in Linux 😃)

[scripting]

Hi Scott, yes I installed from mysql.com. And when I cd'd to that directory, that is where the mysql app is. I started it via the Control Panel, and then --

mysql --password

And when prompted entered the password I set up for root when I installed MySQL and got this error message.

ERROR 1045 (28000): Access denied for user 'davewiner'@'localhost' (using password: NO)

So I tried

sudo mysql --password

It asked for two passwords, the system password and the root user password for MySQL and voila I'm where I wanted to be.

[scripting]

I memorialized this in a howto so hopefully next time I need to do this I'll be able to reuse the learning here.

http://scripting.com/2019/01/27/182812.html