Need help with small website fix

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.

What happens when you try log in dude? I might be able to help you.

What error you get? when you try to login?

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...

functions.php Have you changed the sites URL? May have to do it FTP http://codex.wordpress.org/Changing_The_Site_URL

Share your login details via PM and I'll try my best to help you for Free.

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.

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

Remember to remove the .SQL file from the root folder once you get the site up and running!

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.