1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help with small website fix

Discussion in 'Hire a Freelancer' started by bh9889, Jun 21, 2013.

  1. bh9889

    bh9889 Junior Member

    Joined:
    May 7, 2011
    Messages:
    138
    Likes Received:
    46
    Just bought a site off of Flippa. Installed the .sql database and the website (wordpress) files into root folder. The website is displaying and functioning properly however I can't log in to wp-admin. I've got $10 via paypal to someone who can fix this for me. Thank you.
     
  2. Conor

    Conor Jr. VIP Jr. VIP

    Joined:
    Nov 7, 2012
    Messages:
    3,356
    Likes Received:
    5,418
    Gender:
    Male
    Location:
    South Africa
    Home Page:
  3. gullsinn

    gullsinn Jr. VIP Jr. VIP Premium Member

    Joined:
    Dec 24, 2009
    Messages:
    2,429
    Likes Received:
    2,210
    Gender:
    Male
    Occupation:
    Jobless :D
    Location:
    Graveyard
    Home Page:
    What error you get? when you try to login?
     
  4. srb888

    srb888 Elite Member

    Joined:
    Jul 30, 2008
    Messages:
    3,260
    Likes Received:
    5,067
    Gender:
    Male
    Occupation:
    WebzSurfer
    Location:
    Sun, Mon, Tue, WTF, Sat!!! :)
    Need the exact details of your problem, but you may also check for the following: (Be careful and keep the original backup handy):

    In cPanel: Check the name of the database in phpMyAdmin of your newly created db and see if it matches exactly with that of the .sql file >> look for this line:
    -- Database: `xxxx_yyyyyy`(xxxx_yyyyyy are just placeholders for the actual database name here.)

    Also see if there is a proper user attached to the database. Note the user name, db name, and the user password

    Using File Manager: In the wp-config.php file, insert those details carefully

    This should help you log in if there are no other major issues.
    The prefix attached to the original database name can be different than that being set for the databases on your hosting. So look at that first. Both database names (the original as well as the one you have created) should exactly match, or you should make necessary changes in the .sql file, and also in the wp-config.php file.


    Else you'll have to go to cpanel and use phpMyAdmin and do more changes in the records (change path, etc,) within the wp-options at least.

    try logging in now.

    P.S.:
    Any thing else, or you are unable to login still then will need to check further...
     
    Last edited: Jun 21, 2013
  5. spmcnerd

    spmcnerd Regular Member

    Joined:
    Dec 20, 2010
    Messages:
    309
    Likes Received:
    106
  6. AnotherOne

    AnotherOne Senior Member

    Joined:
    Nov 28, 2011
    Messages:
    919
    Likes Received:
    187
    Occupation:
    SQA
    Location:
    JMeter & Selenium
    Share your login details via PM and I'll try my best to help you for Free.
     
  7. kaydee

    kaydee Registered Member

    Joined:
    May 21, 2010
    Messages:
    52
    Likes Received:
    21
    Occupation:
    Online marketer
    Location:
    USA
    Did you ask the person you bought the site from what the wp admin details are? Because once you imported the database into your wp install it would revert to whatever he had for the login details.
     
  8. hadoken

    hadoken Regular Member

    Joined:
    Dec 4, 2012
    Messages:
    300
    Likes Received:
    529
    Location:
    Toronto
    Go to phpmyadmin
    Find user table
    Change admin user email to yours

    Go to yoursite.com/wp-login.php
    Click lost password
    Enter the email you entered above

    Send money to worthy cause :)
     
  9. bartosimpsonio

    bartosimpsonio Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 21, 2013
    Messages:
    8,844
    Likes Received:
    7,452
    Occupation:
    ZLinky2Buy SEO Services
    Location:
    ⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩
    Home Page:
    Remember to remove the .SQL file from the root folder once you get the site up and running!
     
  10. RuiGomes

    RuiGomes BANNED BANNED

    Joined:
    Jun 12, 2010
    Messages:
    700
    Likes Received:
    238
    If you can access PHPMyAdmin then this is an easy fix you can do by yourself:

    Go the the users table. Change the password field to: 202cb962ac59075b964b07152d234b70

    That huge messy code you just copied to your database is in fact "123" (without quotes) hashed in MD5, so all you need to do is to access wp-admin and type in the specified username and "123" (without quotes) as the password.
     
    • Thanks Thanks x 1