Hey guys, please help a total database newb here. I am doing a database transfer through phpmyadmin. I have exported the database from the target host into a file.sql I have logged into cpanel of new host, created a database in mysql, added a user to the database and went into phpmyadmin. I have selected the database, and then imported the file.sql to that database. However when I try previewing the site...it keeps telling me Access denied for user 'bigfatty_pps'@'localhost' (using password: YES) I need to finish the db transfer cuz I bought this site...and the seller is pushing me. Please help....big reps for the person who helps me
bigfatty_pps could be the old user password tying to the old site. What you could do is to look at your phpmyadmin database and search for the site's login detail. that means, inside the sql somethere, there is a table to store all the DB details. so, if you change those detail to the right USer name and password of your phpmyadmin, you are safe.
Assuming your using PHP * look for a file called config.php or /includes/config.php * You will need to put the database information you used to 'create' the database in cPanel into the config.php file. It should be approx. similar to ... $db_host='localhost'; $db_user='bigfatty_pps'; $db_password='ToPScrT98765'; I would encourage you to search throught all the files and look for localhost if you cannot find config.php