I bought a wordpress site off someone and Im having alot of trouble moving it to my host. He sent me the .sql file as well as the downloaded Wordpress files in a zip. So Ive uploaded the Wordpress files to my host but now need to restore the database. Ive looked at this site but this process isnt working for me. http://www.tamba2.org.uk/wordpress/restore/#two When I try to import the sql file i get this error: MySQL said: Documentation #1044 - Access denied for user 'user'@'localhost' to database 'db_wrdp1' (I changed the blog and username above). How do i import this database so that my site will be exactly like the one he had on his server?
Does it have PHPMyAdmin? If so there is a "import" option where you can select the SQL file and it'll do the work for you. That error you specified means the information in "wp-config.php" is invalid (for the MySQL database)
Ive imported the database and the content is showing. But its not letting me login! I went into phpmyadmin and changed the admin password according to this tutorial: http://www.tamba2.org.uk/wordpress/phpmyadmin/ But it still wont accept my login. And when I click Forgot Password and tell it to email it me it says my username or email is wrong! But the username and email is right there in the database. Why isnt it letting me login or resend a password?