SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry set a root password mysql in MAMP

    Hi, everyone I'm new here I'm learning php from a book called developing applications with php and mysql the book is very clear, but I could not change the root password mysql in MAMP someone can give me a complete toturial on how I do.
    I have a IMAC OSX 10.9.2 2013 last sofware.
    I followed all the directions of the book but I could not hope someone can help me step by step: Mad:

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,014
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    I've never used MAMP, does it have PHPMyAdmin available? If it does it'll probably be easier to change the root password via that
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello thank you for having responded to me I PHPMYADMIN available only if you change the password I am told by them MAMP MAMP error can not turn on because it also needs to know what is the new password.

  4. #4
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,014
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by LorenzoFRS View Post
    Hello thank you for having responded to me I PHPMYADMIN available only if you change the password I am told by them MAMP MAMP error can not turn on because it also needs to know what is the new password.
    Look in PHPMyAdmin's folder for a file called "config.inc.php', in that file you'll need to change the value for the password to match what you've just changed it to
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  5. #5
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've done it now gives me the error 1045 when I try to log in on phpadmin denied what should I do?

  6. #6
    Is Still Alive silver trophybronze trophy RetroNetro's Avatar
    Join Date
    Jul 2003
    Location
    Texas
    Posts
    6,883
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    The original password for the root user is root, have you tried that?

    http://www.mamp.info/en/documentation/#q9

  7. #7
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bring up a terminal window and it should have installed the relevant mysql binaries so you can run:

    mysqladmin -u root -p password <my_new_password>

    enter the old password (which from above seems to be root) when it asks you. Replace <my_new_password> with what you want the password to be.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •