Author Topic: Moved to a new host server - cannot access database (Read 2170 times)

john2 · « **on:** August 30, 2004, 02:23:13 pm »

Dean:

I'm getting access denied errors from config.php. It's trying to connect with both USER@localhost as well as root@localhost.

Database is installed correctly, all the tables are there. Also I verified username and PW are correct with the entries in config.php.

What am I missing?

john

DW · « **Reply #1 on:** September 13, 2004, 12:10:41 pm »

It looks like a problem with your MySQL username, password, database, or hostname.

Are you sure you have created a database, set up a username and password, and also (on some servers) added the user to have permission to the database?

Most hosts use "localhost" as the hostname, but your host could use something else. This could be mentioned in your hosting FAQ or your MySQL control panel / setup page.

john2 · « **Reply #2 on:** September 14, 2004, 09:09:52 am »

Sorry for the new post. Forgot I'd posted it earlier.

I've checked username, pw, database, and localhost are all as set in config.php (lines 13-17). They appear correct I'm stumped.

john

john2 · « **Reply #3 on:** September 14, 2004, 10:16:11 am »

Dean:

I got it! The problem was the new server now required the full syntax of

mysite_username.

On the previous server apparently it only required the username without the mysite_ prefix, because that was missing when I copied the files.

I'm posting this so others can follow. Thanks.

john