ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: john2 on August 30, 2004, 02:23:13 pm

Title: Moved to a new host server - cannot access database
Post by: 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

Title: Moved to a new host server - cannot access database
Post by: DW 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.

Title: Moved to a new host server - cannot access database
Post by: john2 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

Title: Moved to a new host server - cannot access database
Post by: john2 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