Force change/reset mysql password?

I'm having trouble with my MAMP installation where I can't seem to connect to the database.

I thought I knew the password, but it doesn't work and I can't log into mysql manually with it.

I want to hard reset the root password for the MAMP installation of mysql, can I do that?

Answers


start mysql with --skip-grant-tables to bypass the login system. that'll let you in as a superuser, and you can modify user accounts.

Afterwards, use flush privileges to restore the access control system.


Type this in your terminal:

/Applications/MAMP/Library/bin/mysqladmin -u root -p password <YOUR_PASS> 

If your password not working, use flush privileges


Need Your Help

NVD3.js (d3.js) Scale Break

d3.js scale nvd3.js

I want to create a chart with scale break on y axis. I don't want to use a non-linear scale but using a scale break make lower values more visible when having data anomalies.

HttpClient retrieve all headers

c# http http-headers windows-phone-8 dotnet-httpclient

Currently, I am working on API wrapper. If I send a bad Consumer Key, the server will return Status as 403 Forbidden in the header. It will also pass custom headers. How do I actually retrieve these