Database passwords in wp-config

  • Resolved Bernard46

    (@bernard46)


    9 years, 3 months ago

    I’ve downloaded my site to a Windows PC running MAMP and it works fine apart from one niggle. I couldn’t get it to work initially with the userid/password that was in the downloaded wp-config file. I can get the connection working by using root/root in wp-config but I would rather not continue using this combination! There is an underscore and a percentage sign in the userid and password in the live website and I have used Windows Notepad to insert these into the local wp-config file – I think this should eliminate any possibility of other characters being substituted. I have searched various forum entries and they all seem to suggest that a typo is to blame but I have tried retyping the two parameters many times, all to no avail. I have used the MAMP phpMyAdmin to define the userid and password for the database on the same PC so again hopefully my instructions have been followed by phpMyAdmin. Could anyone suggest anything else I can try doing?

Viewing 8 replies - 1 through 8 (of 8 total)
  • InterServer

    (@interservernet-web-hosting)

    What I am suggesting is that create a new a user and password for the database through phpMyAdmin. Then replace user and password in wp-config.php with the new one created.

    Thread Starter Bernard46

    (@bernard46)

    I’ve tried this but I’ll give it another go. I can’t see how to include a picture of the definition so let me describe it – I used a userid of Newuser and a password of Newpassword I left the Anyhost field with the % character in it and I left the tick in the field “Grant all privileges on database “southamlocal”” and “Global Privileges” had a tick in it. The result was

    User Host Type Privileges Grant Action
    Newuser % global ALL PRIVILEGES Yes Edit Privileges
    database-specific ALL PRIVILEGES No Edit Privileges

    I don’t know why Grant was set to “No” in the database-specific line – I have tried changing this to “Yes” but although the change was accepted the “Yes” value made no difference to the problem’ and I still end up with “Error Establishing Database Connection” when trying to access the web site even though phpMyAdmin assures me that Newuser has access to the database “southamlocal”. I’m stumped!

    i am trying to install wordpress 4.2.2 on xampp by localhost.
    but its need to mysql database username and password.
    so how can i find these?

    hi,
    i used WordPress 4.2.2 on localhost.i want to use landing page plugins 2.0.3 but its not working.
    what can i use it?
    thanks

    Thread Starter Bernard46

    (@bernard46)

    jhvidyut, I’m not sure what your comments have to do with the problem in the initial post. Would you mind opening your own thread please and not attaching your problem to this post – thank you.You will stand a better chance of getting a relevant answer.

    @bernard46 –

    Just tried this on my local Windows MAMP and yep, as you are experiencing, get the DB connection error.

    What fixed it? Use local instead of the %

    Additionally, as you may or may not be aware, the user name and password are case-sensitive. Verified by changing Newuser to newuser; connection error ??

    Cheers!
    Lyle

    Thread Starter Bernard46

    (@bernard46)

    Well blow me down! Brilliant, you’re dead right.

    Can I just ask one more question – what does the % sign mean in the Host field when one first gets to the Add new user screen. I had wrongly assumed that since I had anyhost and the % sign was filled in it would be OK, but obviously not.

    Thanks for your help.

    Glad it worked but I really can’t answer why … perhaps take a look at the phpMyAdmin docs ??

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Database passwords in wp-config’ is closed to new replies.