unable to get past: sudo /usr/local/mysql/bin/mysql

[bmiddaugh]

Hi everyone and thanks in advance for any help that can given on this.
I've hunted all over the net on a way to solve this issue but nothing is working for me, so I figured I'd give a shot with the experts.

I have a mac mini running high sierra as a media server in our home and have finally decided to use MRMC properly by setting up mysql and running a DB from there to keep the multiple apple tv's we have in sync.

I've installed mysql no issue but when I go to run the first command:
sudo /usr/local/mysql/bin/mysql
It asks for a password.
I initially assumed it was for the mysql install that just completed but that does not work.
I then thought well maybe it is the admin password for the mac machine. So I put that in and when I do that I get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I've tried to run commands to reset passwords on mysql and all the "google tips" I could find but nothing would work.
Has anyone experienced this on their installs?
And if so, how did you work around it.
Thanks again.
Brett

[amet]

It’s your sudo password, password for the user that’s logged in currently

And then you need the below command to specify the user

$mysql -u root -p

[bmiddaugh]

when i use that it gives me this error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[bmiddaugh]

I don't think the tutorial supplied on the wiki is up to date.
I've checked to see if the "myhuge.cnf" file is in this path: /usr/local/mysql/support-files/ and it isn't

Either way I am still unable to get past this command: sudo /usr/local/mysql/bin/mysql

Thank you for your help though.

[amet]

Did you setup root user?

And command is:

sudo /usr/local/mysql/bin/mysql -u root -p

[bmiddaugh]

I am also using mysql 8.0.19 on high sierra.

[amet]

I am also using mysql 8.0.19 on high sierra.

It’s MySQL question, not really something we provide support for... but linked instructions worked fine for many users.

You keep mentioning root user, our instructions mention mrmc user

[bmiddaugh]

every command I try gives me: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I'm not familiar with using mysql, but I figured I'd give this a shot.
Everything else works out well, probably have to pass on this capability.

[amet]

(using password: NO) Means just that, did you use the command I pasted?

[bmiddaugh]

Hi Amet,
Thanks for sticking with me on this, I don't want to bog you down with it.

These are the exact commands I am trying and the results I am getting

Code: Select all

Cottages-Mac-mini:~ cottageconundrumserver$ sudo /usr/local/mysql/bin/mysql
Password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Cottages-Mac-mini:~ cottageconundrumserver$ mysql -u root -p
-bash: mysql: command not found
Cottages-Mac-mini:~ cottageconundrumserver$ sudo /usr/local/mysql/bin/mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Cottages-Mac-mini:~ cottageconundrumserver