Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Feb 2012
    Posts
    85
    Thanks
    8
    Thanked 0 Times in 0 Posts

    MySQL password - uploading to live site

    Hi, Just wondering how this would work.

    So when you install MAMP..you are given a root username and password (of root/root) right?

    So say you create a site locally using this, then you want to upload it to a web hosting site so it can go live on the web, you wouldn't want to be using the default root username and password for your local MySQL server would you? Or does it not matter?

    Do people tend to install MAMP and change this immediately so its done for future? if so, how do you change? I'm going to re-install MAMP and do this if this is the case.

    Thanks in advance
    Don't Click Here!

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,622
    Thanks
    80
    Thanked 4,635 Times in 4,597 Posts
    Well, I certainly wouldn't leave it as root/root even on my local server.

    In any case, if you are uploading the database to some web host, more than likely they will assign both the user name and password to you. It's extremely unlikely that they will give you root access. (I know, for example, that GoDaddy doesn't allow this when you ask them to set up a MySQL DB for you.)
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New Coder
    Join Date
    Feb 2012
    Posts
    85
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    Well, I certainly wouldn't leave it as root/root even on my local server.

    In any case, if you are uploading the database to some web host, more than likely they will assign both the user name and password to you. It's extremely unlikely that they will give you root access. (I know, for example, that GoDaddy doesn't allow this when you ask them to set up a MySQL DB for you.)
    Do you know how to change it mate for local use? Ive troed a couple of things from google and neither have worked
    Don't Click Here!

  • #4
    New Coder
    Join Date
    Feb 2012
    Posts
    85
    Thanks
    8
    Thanked 0 Times in 0 Posts
    This is driving me mad now! Managed to change the password, however when I stop and start the MAMP servers I get this error shown in the screenshot? There must be some file somewhere that still thinks I am using the old password!?!?!

    Any ideas guys?
    Attached Thumbnails Attached Thumbnails MySQL password - uploading to live site-screen-shot-2013-04-03-18.59.43.jpg  
    Don't Click Here!

  • #5
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,622
    Thanks
    80
    Thanked 4,635 Times in 4,597 Posts
    Never used MAMP. Just installed MySQL by itself. Never seen that type of screen.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #6
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,696
    Thanks
    25
    Thanked 658 Times in 657 Posts
    Evolution - The non-random survival of random variants.

    "If you leave hydrogen alone, for long enough, it begins to think about itself."


  •  

    Posting Permissions

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