Resetting MAMP’s MySQL Root User Password

Those of you familiar with MAMP will no doubt know that MAMP’s MySQL root user password is set to root by default and changing it is not as straightforward as it perhaps should be.

I’ve previously described a way of successfully changing the root user password providing, of course, that you know the current password. If you’ve forgotten it, this method will not work and a way of re-setting the password is required.

I’ll be using the Terminal to reset the root password, but first we need to ensure that MAMP’s MySQL server is not running.

If MAMP is running and the When quitting MAMP: Stop Servers option is checked then quitting MAMP will suffice.

MAMP’s Start/Stop Options

If not, click the Stop Servers button.

Stop MAMP’s Apache and MySQL Servers

Next, start MAMP’s MySQL server from the Terminal with the --skip-grant-tables option. As this option allows anyone to connect without a password and with all privileges — albeit temporarily — the --skip-networking option is included to prevent remote access.

Copy and paste the following command into a Terminal window and press ↵:

Dummy Tab

Dummy Content

Code

/Applications/MAMP/Library/bin/mysqld_safe \
--skip-grant-tables \
--skip-networking \
--socket=/Applications/MAMP/tmp/mysql/mysql.sock \
--pid-file=/Applications/MAMP/tmp/mysql/mysql.pid &

When Terminal displays the following message, press ↵ again to return to the Terminal prompt.

mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql

At the prompt type the following command to access the MySQL command interpreter:

Dummy Tab

Dummy Content

Code

/Applications/MAMP/Library/bin/mysql

You should see the MySQL command interpreter prompt: mysql>

At the prompt type:

Dummy Tab

Dummy Content

Code

FLUSH PRIVILEGES;

Press ↵, then type the following replacing NewPassword with the password of your choice (see ¹ below if you’re using MAMP 4.5 or earlier):

Dummy Tab

Dummy Content

Code

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';

Press ↵, then type:

Dummy Tab

Dummy Content

Code

FLUSH PRIVILEGES;

Press ↵. Then, to quit the MySQL command interpreter type:

Dummy Tab

Dummy Content

Code

\q

You should be returned to the Terminal prompt. Copy and paste the following command to shutdown MAMP’s MySQL server. You’ll be prompted for the new root password when you press ↵.

Dummy Tab

Dummy Content

Code

/Applications/MAMP/Library/bin/mysqladmin \
--socket=/Applications/MAMP/tmp/mysql/mysql.sock shutdown -u root -p

Having reset the root user password you should follow the instructions here regarding updating the necessary files in MAMP with the new password.

These instructions were adapted from the official MySQL documentation.

¹ As of MySQL 5.7.6 the PASSWORD() function has been deprecated. This affects versions of MAMP since 5.0 – released on 2018-07-31 – which shipped with MySQL 5.7.21. However, if you’re using MAMP 4.5 – which shipped with MySQL 5.6.38 – or earlier, the command to reset the root password is:

Dummy Tab

Dummy Content

Code

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NewPassword');

MAMP Release Notes

/Applications/MAMP/Library/bin/mysqld_safe \ --skip-grant-tables \ --skip-networking \ --socket=/Applications/MAMP/tmp/mysql/mysql.sock \ --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid \ --log-error=/Users/<your user name>/Desktop/temp.err &

@Anthony @bps @steve

I’ve done a little digging and the culprit is the option
--lower_case_table_names=0

In the version I was using – MAMP 3.5 – the MySQL version is 5.5.42. In MAMP 4.1 the MySQL version is 5.6.34.

With MAMP 3.5, starting MySQL from the Terminal works without issue, but the MySQL error log – /Applications/MAMP/db/mysql/computer-name.local.err – contains the following warning:

[Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system ‘/Applications/MAMP/db/mysql/’ is case insensitive.

Setting --lower_case_table_names to 0 configures MySQL to use case sensitive table names. However, macOS Sierra and previous versions of OS X by default use the HFS+ file system which is not case sensitive, hence the warning.

With MySQL 5.6.34 (MAMP 4.1) this warning has been upgraded to an error causing the process to be aborted. The same error log contains:

4156 [ERROR] The server option ‘lower_case_table_names’ is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination.
4156 [ERROR] Aborting

When starting MySQL via the MAMP GUI the MySQL system variable lower_case_table_names is set to 2.

So, the solution is to either omit the
--lower_case_table_names option or include it with a setting of 2; --lower_case_table_names=2. I’d probably choose the former.

Either way you’ll be able to start the MySQL server from the command line and reset the password.

I’ve amended the instructions to reflect this change.

Hope this helps.

Steve.

Cancel reply

73 Comments

Sam says:

January 10, 2024 at 20:01

Lifesaver!

Jake says:

February 14, 2021 at 20:42

Just a note that for me, I had to use a slight variation of the final command.
Instead of:
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘newpassword’;
I had to use:
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ’newpassword’;

MAMP v6.3, macOS Big Sur, MySql 5.7.32

- Steve says:
  
  February 15, 2021 at 13:21
  
  @Jake,
  
  Still works for me without explicitly specifying an authentication plugin: WITH mysql_native_password, but this may help others.
  
  Thanks, Steve.
  
José says:

November 9, 2020 at 16:41

You are the master, It’s really work!

Thank you

Paulo Roque says:

February 11, 2020 at 02:24

Thank you, Steve 🙂

Excellent tutorial, very easy to use and understand!

Following you!

Silja says:

October 31, 2019 at 13:18

Omg this worked! I was looking for a solution for hours and your easy to follow guide totally saved my day! Thank you so much!!!

Aidan Foster says:

June 7, 2018 at 20:43

Just a note that mamp pro 4.5 has a “change password” button which is enabled when mysql is shut down.

cissy says:

September 3, 2017 at 05:41

hello,

dacdeMacBook-Air:bin cissy$ 170903 12:39:24 mysqld_safe Logging to ‘/Applications/MAMP/db/mysql/dacdeMacBook-Air.local.err’.
170903 12:39:24 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
/Applications/MAMP/Library/bin/mysqld_safe: line 128: /Applications/MAMP/db/mysql/dacdeMacBook-Air.local.err: Permission denied
/Applications/MAMP/Library/bin/mysqld_safe: line 165: /Applications/MAMP/db/mysql/dacdeMacBook-Air.local.err: Permission denied
170903 12:39:24 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
/Applications/MAMP/Library/bin/mysqld_safe: line 128: /Applications/MAMP/db/mysql/dacdeMacBook-Air.local.err: Permission denied

[1]+ Exit 1 /Applications/MAMP/Library/bin/mysqld_safe –skip-grant-tables –skip-networking –socket=/Applications/MAMP/tmp/mysql/mysql.sock –pid-file=/Applications/MAMP/tmp/mysql/mysql.pid
dacdeMacBook-Air:bin cissy$

It’s not work for my mac,
and needs your help,,thanks

- Steve says:
  
  September 3, 2017 at 14:40
  @cissy,
  
  Looks like there’s a permissions issue with the file /Applications/MAMP/db/mysql/dacdeMacBook-Air.local.err, which is a little strange. Are you logged into your Mac as the administrative user when running the Terminal command? You could try changing the command to this:
```
/Applications/MAMP/Library/bin/mysqld_safe \
--skip-grant-tables \
--skip-networking \
--socket=/Applications/MAMP/tmp/mysql/mysql.sock \
--pid-file=/Applications/MAMP/tmp/mysql/mysql.pid \
--log-error=/Users/<your user name>/Desktop/temp.err &
```
  This will direct any errors to the named file circumventing the file /Applications/MAMP/db/mysql/dacdeMacBook-Air.local.err and may help determine if it’s simply a permissions issue or something more sinister. Don’t forget to change <your user name> to your user name.
  
  Regards, Steve.
  - cissy says:
    
    September 10, 2017 at 04:47
    
    thank you, but there still lots of error, I think I need reset….
    
    - Steve says:
      
      September 11, 2017 at 17:20
      
      @cissy,
      
      Sorry to hear you’re still having problems. If you’re thinking of re-installing MAMP, you might want to copy any MySQL databases you’ve created. These can be found in either /Applications/db/mysql or /Applications/db/mysql56 depending on which version of MAMP you’re using. Simply drag either of these folders to your Desktop. You can copy it back once you’ve re-installed MAMP.
      
      Regards, Steve.
      
Maarten says:

July 27, 2017 at 09:51

Hero.

Stan says:

July 2, 2017 at 16:07

It works great!
Thanks a lot, Steve!

moisemoshe says:

May 19, 2017 at 21:46

Thanks mate, worked like a charm

Jonathan Pereira says:

December 13, 2016 at 03:14

Very useful and straight forward! Thank you so much!

steve says:

September 14, 2016 at 04:32

This doesn’t work on a Mac.

Bash command

/Applications/MAMP/Library/bin/mysqld_safe –skip-grant-tables –skip-networking –socket=/Applications/MAMP/tmp/mysql/mysql.sock –lower_case_table_names=0 –pid-file=/Applications/MAMP/tmp/mysql/mysql.pid &

generates this nonsense…

‘/Applications/MAMP/db/mysql56/Steves-MacBook-Pro-2.local.err’.
160913 12:25:23 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql56
160913 12:25:23 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

…and this….

/Applications/MAMP/Library/bin/mysql

…only generates this message…

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)

So, there is no way to know or change the root password. QED.

- Steve says:
  
  September 19, 2016 at 20:58
  
  @steve,
  
  Works perfectly on my Mac running 10.11.6.
  
  The problem is there are syntax errors in the command you pasted in your comment that’ll give you the exact same errors you’re receiving. Note that two leading hyphens are required and not the one hyphen as in your command.
  
  It should be:-
  --skip-grant-tables not –skip-grant-tables,
  --skip-networking not –skip-networking and so on.
  
  Regards, Steve.
  
  - Anthony Sykes says:
    
    January 7, 2017 at 05:47
    
    Bash command
    
    /Applications/MAMP/Library/bin/mysqld_safe -–skip-grant-tables –-skip-networking –-socket=/Applications/MAMP/tmp/mysql/mysql.sock –-lower_case_table_names=0 –-pid-file=/Applications/MAMP/tmp/mysql/mysql.pid &
    
    generates this nonsense…
    
    ‘/Applications/MAMP/db/mysql56/Steves-MacBook-Pro-2.local.err’.
    160913 12:25:23 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql56
    160913 12:25:23 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
    
    …and this….
    
    /Applications/MAMP/Library/bin/mysql
    
    …only generates this message…
    
    ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
    
    I entered the command with “–” instead of “-” and encountered the same issue. I also tried running it with sudo leading it. Is it still not working. Does anyone have a fix when encountering this issue?
    
    - Steve says:
      
      January 11, 2017 at 13:31
      
      @Anthony @bps @steve
      
      I’ve done a little digging and the culprit is the option
      --lower_case_table_names=0
      
      In the version I was using – MAMP 3.5 – the MySQL version is 5.5.42. In MAMP 4.1 the MySQL version is 5.6.34.
      
      With MAMP 3.5, starting MySQL from the Terminal works without issue, but the MySQL error log – /Applications/MAMP/db/mysql/computer-name.local.err – contains the following warning:
      
      [Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system ‘/Applications/MAMP/db/mysql/’ is case insensitive.
      
      Setting --lower_case_table_names to 0 configures MySQL to use case sensitive table names. However, macOS Sierra and previous versions of OS X by default use the HFS+ file system which is not case sensitive, hence the warning.
      
      With MySQL 5.6.34 (MAMP 4.1) this warning has been upgraded to an error causing the process to be aborted. The same error log contains:
      
      4156 [ERROR] The server option ‘lower_case_table_names’ is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination.
      4156 [ERROR] Aborting
      
      When starting MySQL via the MAMP GUI the MySQL system variable lower_case_table_names is set to 2.
      
      So, the solution is to either omit the
      --lower_case_table_names option or include it with a setting of 2; --lower_case_table_names=2. I’d probably choose the former.
      
      Either way you’ll be able to start the MySQL server from the command line and reset the password.
      
      I’ve amended the instructions to reflect this change.
      
      Hope this helps.
      
      Steve.
      
  - bps says:
    
    December 28, 2016 at 02:53
    
    Having the same troubles as Steve, but from copying and pasting exactly what you had in the tutorial.
    
Natalie says:

July 13, 2016 at 03:41

Somehow, I changed the MySQL root password in MAMP and now I am locked out of localhost. I can’t connect via localhost at all and I can’t access by databases. I have Googled information on how to reset the root password, but I have only been able to find information on MAMP for MAC. I have MAMP for Windows. What are my options, if any? I appreciate any help you can give me. Thank you.

Natalie Davis says:

July 12, 2016 at 12:22

Hello,

I have a Windows 10 system. For some reason, I can’t move past the skip-grant-tables command. When I paste it into my terminal window and press ‘enter’, it returns “the system cannot find the path specified.” What am I doing wrong?

- Steve says:
  
  July 15, 2016 at 07:34
  
  @Natalie
  
  According to this document MAMP for windows is installed in C:\MAMP and not /Applications/MAMP as it is on a Mac – hence the error message.
  
  I have no experience using MAMP on Windows but I assume to start MAMP’s MySQL server from the Windows command line you’d need to replace all occurrences of /Applications/MAMP in the command with C:\MAMP.
  
  For example:
  
  C:\MAMP\Library\bin\mysqld_safe –skip-grant-tables –skip-networking –socket=C:\MAMP\tmp\mysql\mysql.sock –lower_case_table_names=0 –pid-file=C:\MAMP\tmp\mysql\mysql.pid &
  
  Regards, Steve.
  
Denise says:

June 25, 2016 at 15:03

Been struggling with this for days. You deserve an Oscar.

Jennie says:

February 28, 2016 at 07:31

You just saved my life. Thank you.

Uche says:

December 12, 2015 at 22:52

Very helpful post! I ran into these issues when conflicts arose between my MAMP package and my Mac server instances of apache and a prior installed standalone instance of MySQL. Helped with finding the path to MAMP running things again.

asmau says:

November 19, 2015 at 01:18

You are a life saver…I am a mediocre programmer and i almost ripped my hair out for this. BOOKMARKED!!!!

James says:

October 6, 2015 at 08:45

This was awesome, thanks!

Birodh says:

August 2, 2015 at 11:40

This really helped my. Tons of thanks.

Alki says:

July 16, 2015 at 07:27

Thaaaank you! You saved my night and the whole day tomorrow! Why don’t you post this answer to stackoverflow, people are struggling for this answer there…

Anyway, many thanks!

exoboy says:

June 3, 2015 at 18:07

Thanks! This just saved me TONS of grief!

Isuru says:

May 17, 2015 at 00:41

Thank you very much for this article. Helped me.

wurk says:

May 5, 2015 at 22:15

Thanks a bunch, the config file from mamp didnt work for me. this did!

Andre says:

April 16, 2015 at 11:49

Solved my problem!

Nasim says:

April 13, 2015 at 13:39

Thank you very much!! It nice solution it solved my problem!

Amir says:

February 26, 2015 at 04:32

Thank you very much!!! You are my hero today!!!

Fernando says:

February 20, 2015 at 21:52

Thank you so much! Simple explanation.

Brian says:

January 24, 2015 at 02:05

Thank you

Dougal Crowder says:

January 16, 2015 at 20:46

Thank you so much. This was a real timesaver.

John Robinson says:

January 8, 2015 at 20:44

Thanks so much for this Steve. You’re a scholar and a gentleman!

- Steve says:
  
  January 9, 2015 at 14:40
  
  Thanks John. Glad you found it useful.
  
Liam says:

January 7, 2015 at 22:52

Took me a few minutes to solve an hour long headache. Thank you!

abdallah nofal says:

December 21, 2014 at 22:34

awesome! really thanks…solved my problem

David says:

December 5, 2014 at 05:59

Nice Solution! It the one that solves me the problem! Regards!

Marcel Delfino says:

November 5, 2014 at 12:16

Awesome! thanks…worked a treast

- Steve says:
  
  November 6, 2014 at 06:11
  
  @Marcel,
  
  Glad you found it useful.
  
  Regards, Steve.
  
Dan Jesse says:

September 2, 2014 at 07:56

Cheers for this, helped me out so quickly. Really appreciate you taking the time to make it so easy for less clever people like myself 😀

- Steve says:
  
  September 2, 2014 at 14:06
  
  @Dan,
  
  Glad you found helpful.
  
  Regards, Steve.
  
flo says:

August 23, 2014 at 23:57

Hello Steve, I tried your solution, it first didn’t work and then after quitting Terminal and opening it again.

At the first step I got this: “mysqld_safe Logging to ‘/Applications/MAMP/db/mysql/MYCOMPUTER.local.err’.
chown: /Applications/MAMP/db/mysql/MYCOMPUTER.local.err: Operation not permitted”, but then with “mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql” as you wrote.

By pressing enter and typing “/Applications/MAMP/Library/bin/mysql” I’ve got this:

“/Applications/MAMP/Library/bin/mysql
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
MYCOMPUTER:~ MYCOMPUTERACCOUNT$ 140823 16:48:17 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended”

I’m a bit desesperate then it’s already a long time that I can’t do anything because can’t come into localhost…

- Steve says:
  
  August 24, 2014 at 10:07
  
  @Flo,
  
  Was unable to replicate the error in this situation, but got the same error message when using /Applications/MAMP/bin/startMysql.sh then /Applications/MAMP/Library/bin/mysql. If MAMP’s MySQL server was running I’d expect to see the file mysql.pid in the /Applications/MAMP/tmp/mysql folder, but it wasn’t there.
  
  Not sure why this happened, but in this situation a simple computer restart fixed the issue.
  
  Regards, Steve.
  
  - flo says:
    
    August 25, 2014 at 06:35
    
    Thank you so much Steve for your answer and your helpfulness !
    
    It first did not work and I had to do it again, start Disk Utilities programm to repair the Mac autorisations, restart the computer, and the same again. After a while the conection to MySQL server worked finally, a big surprise! …But very shortly then came error 2002 ! Then again Disk Utilities and restart, now it works !!!
    
    Thank you so much !!!
    
    - Steve says:
      
      August 25, 2014 at 15:51
      
      @Flo
      
      Glad to hear you’ve got it working.
      
      Regards, Steve.
      
Joanne says:

August 15, 2014 at 15:47

Thank you so much!
It helps me a lot! 🙂

PAUL says:

August 13, 2014 at 02:26

last line didn’t work for me. I got

/Applications/MAMP/Library/bin/mysqladmin: shutdown failed; error: ‘Access denied; you need (at least one of) the SHUTDOWN privilege(s) for this operation’

any guesses?

Killed the processes myself and everything worked. Thanks for the post!

- Steve says:
  
  August 13, 2014 at 13:49
  
  @PAUL
  
  As the error implies the MySQL user doesn’t have SUPER or SHUTDOWN privileges in order to shutdown the MySQL server which seems odd if it’s the root user. I have no suggestions other than using kill -SIGTERM pid-of-mysqld-process in Terminal which worked for you.
  
  Regards, Steve.
  
Patrick says:

July 1, 2014 at 12:43

I’m not sure if you’re still following this comment thread, Steve, but I’ve got a quick question: when I get to the last step of your guidelines to enter the new password in the ‘Enter Password:’ line, Terminal won’t let me type anything. It’s like it is frozen. When I press enter it gives me the error: ‘Access denied for user ‘root’@’localhost’ (using password: YES)’.

Any thoughts on why it won’t let me enter my new password?

Thanks,

Patrick

- Steve says:
  
  July 1, 2014 at 13:43
  
  @Patrick,
  
  In Terminal the cursor will not move when you enter the password. This is normal behaviour.
  
  Alternatively, instead of ending the command -u root -p and waiting for the password prompt you could add the new password to the end of the command like so -u root -pNewPassword which will circumvent the password prompt. Make sure there is no space between -p and NewPassword
  
  Regards, Steve.
  
  - Patrick says:
    
    July 1, 2014 at 23:23
    
    Beautiful! Thank you, Steve!
    
    - Steve says:
      
      July 2, 2014 at 06:04
      
      You’re welcome Patrick.
      
      Regards, Steve.
      
Dominic says:

June 29, 2014 at 00:53

Brilliant, thank you so much! After an hour of trying to reset my password this sorted me out. You’re a good man.

- Steve says:
  
  June 29, 2014 at 13:36
  
  @Dominic,
  
  You’re welcome.
  
  Regards, Steve.
  
Klara Charlton says:

June 9, 2014 at 10:56

Thank you so much for this excellent blog! As someone pointed out above, basically everything else on the web seems cobbled together in a half-baked manner. You have been of great help today. I am so glad that I found your website! Thank you 🙂

- Steve says:
  
  June 9, 2014 at 12:20
  
  @Klara,
  
  You’re welcome. Glad you found it useful.
  
  Regards, Steve
  
Michael says:

May 27, 2014 at 22:36

Thanks for this, worked perfectly. (Until I found your site I felt like I was in a loop where everywhere I went said something to the effect of “this is a common problem, go find the answer somewhere else”.)

- Steve says:
  
  May 28, 2014 at 07:24
  
  @Michael,
  
  Glad you found it helpful.
  
  Regards, Steve.
  
DMZ says:

May 23, 2014 at 07:56

This was amazingly helpful where other pages failed. Two corrections:
FLUSH… needs a ; at the end
And then for the last command, you may be bomb out if you don’t specify -u root -p (and then enter the password when prompted)

- Steve says:
  
  May 23, 2014 at 14:48
  
  @DMZ
  
  Thanks. Have made the necessary corrections.
  
  Regards, Steve
  
MehmetD. says:

May 4, 2014 at 06:29

Thank you, it worked perfect. this issue was about to kill me 🙂

Bobby Digital says:

February 27, 2014 at 06:36

Awesome! I was trying other solutions and this is the only one that actually worked. Simple copy and paste solution!

Antónia says:

February 5, 2014 at 02:51

Hello,

Thanks!
It was the only thing that solves my problem, of connecting to mysql server.

Toby Couchman says:

January 24, 2014 at 17:12

Just spent around an hour before I came across your site. The tutorial got me up and running in about 5 minutes!

Thanks a bunch!
Toby

jon says:

October 28, 2013 at 00:54

I was struggling all day with this issue — “error: 1045: Access denied for user ‘root’@’localhost'” — only your solution got to the root of it! Thanks a lot!

- Steve says:
  
  October 28, 2013 at 06:51
  
  @jon
  
  Glad you found it useful.
  
  Regards, Steve.

4 Pingbacks

MAMP MySQL Migration Configuration Terminal Commands | says:

October 27, 2017 at 15:24

[…] Reset MAMP MySQL Root Password […]
A Solution Made (a little too) Easy with MAMP Pro - Janel Lucia says:

December 30, 2016 at 09:51

[…] Once MAMP Pro was successfully installed I went to the MySQL tab and changed my password. You don’t have to know your old password to change it here, it’s that easy. Not knowing my old password was the main problem I was having. (if you know your old password and want to change it, view the terminal instructions here) […]
A Solution Made (a little too) Easy with MAMP Pro | Janel Lucia says:

November 16, 2016 at 12:45

[…] Once MAMP Pro was successfully installed I went to the MySQL tab and changed my password. You don’t have to know your old password to change it here, it’s that easy. Not knowing my old password was the main problem I was having. (if you know your old password and want to change it, view the terminal instructions here) […]
mysql: Reset root password without knowing it (Mac MAMP) | Mixed Pickles says:

January 26, 2016 at 20:34

[…] So here is an easy way how to reset your root password. I got it from here: […]

Resetting MAMP’s MySQL Root User Password

About the author

77 responses

Cancel reply

73 Comments

4 Pingbacks

Recent Comments

Recent Posts

About the author

77 responses

Cancel reply

73 Comments

4 Pingbacks

Read more

Recent Comments

Recent Posts