Problem resetting mysql password in mac OS

Question

0.00/5 (No votes)

See more:

So i need to reset my MySQL password after installing it. I have used some commands in terminal but nothing seems to be working..

I have looked everywhere and I can't find a solution to this problem...

I am new to programming, and haven't needed to use terminal as of yet. If anyone could explain this to me in simple terms that would be great..

Also, if there are any resources anyone could recommend on using terminal that would be great..

Cheers!

What I have tried:

sudo mysqld_safe --skip-grant-tables comes up as 'command not found'

Posted 20-Mar-18 17:20pm

wilma2202

Updated 20-Mar-18 17:34pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Accepted Answer · 2018-03-20T17:35:00

Solution 1

Have you tried what is indicated here?
MySQL :: MySQL 5.7 Reference Manual :: B.5.3.2 How to Reset the Root Password[^]

Posted 20-Mar-18 17:35pm

phil.o

Comments

wilma2202 20-Mar-18 23:48pm

No, that reference manual doesn't have anything on Mac OS..

But in general, every guide I have been to (and I tried several, including videos) doesn't have a solution to my issue. Or, its skipped over because maybe its assumed knowledge?

I'm not sure, but from the manuals I have read, terminal should run the command just fine. I have copied and pasted the above command, it isn't an syntax error.

phil.o 21-Mar-18 6:47am

Since december 1996, Mac OS is built upon a unix kernel. So I assume the commands for Unix/Linux, indicated in the link I provided, will work.
Thus, corresponding section you should have a look at is B.5.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems

wilma2202 21-Mar-18 7:55am

Ok, thats handy to know. Thanks

First up I entered: $ --user=mysql

and the terminal returned:
-bash: --user=mysql: command not found

It seems like a lot of common commands related to MySQL are not working for me..
I don't fully understand this, but in my limited knowledge of terminal commands it seems like it might be related to the path to MySQL, but I don't know how to sort this.

phil.o 21-Mar-18 8:47am

--user=mysql is not a command, it is an option to the command which starts the daemon.
I don't know what to say further, all you need is indicated in the manual. Perhaps you should take a quick tutorial on unix/linux commands?

wilma2202 21-Mar-18 17:44pm

That's what I've been avoiding but I think I'll have to start there.. thanks