WordPress.org

1. rdkilby
   Member
   Posted 2 weeks ago #

   I need to move a couple sites to a new server. I have backed up the database per the instructions in the codex. The problem is restoring the database on the new server. I get an access denied message. I have tried the same username/pw config that the old server had as well as different username/pw configs. In the codex about restoring the database it doesn't mention a username and pw at all. My error is below.

   Error

   SQL query:

   --
   -- Database: kilby_family_blog
   --
   CREATE DATABASE kilby_family_blog DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

   MySQL said: Documentation
   #1044 - Access denied for user 'kilby_blogger'@'%' to database 'kilby_family_blog'

2. wordprest
   Member
   Posted 2 weeks ago #

   well,

   you have to specify new credentials for new db...

3. songdogtech
   Member
   Posted 2 weeks ago #

   Your database hasn't been created. wp-config.php presents your database login and password, etc., but your database has to be created first. Ask your hosting company to be sure the "blank" database has been created; once it has been created, then WP can write the tables to it.

4. imaginhost
   Member
   Posted 2 weeks ago #

   Hello, first you do have to enter your new database details in wp-config.php, but did you also make sure to set the new location for your Wordpress installation under the "Settings" page before you exported the database? It's a good idea to export the database before (as a backup, just in case) and after you change the location settings in your Wordpress installation, then import your database at your new host and enter your new database details in wp-config.php. I hope that helps. Good luck with your site!

   [sig removed per forum rules]

Reply

You must log in to post.