Textpattern CMS

#1 2006-03-19 16:54:46

cmachine

New Member

Registered: 2006-03-19

Posts: 3

Database Connection Problems ..

I’ve installed TextPattern on my website but I’m having trouble configuring it.

The details are:

Database Name: d60209056
Host: MYSQLHOST
User: u70220892

I’m entering the following information in the Textpattern setup screen:

MySQL login: MYSQLHOST_u70220892
MySQL password: password
MySQL server: localhost
MySQL database: MYSQLHOST_d60209056
Table prefix:

On entering this information, I’m getting the following error:

<strong>Checking database connection…

Warning: mysql_connect(): Access denied for user ‘MYSQLHOST_u70220’@‘anyhost’ (using password: YES) in /mnt/web_w/d05/s15/b0274934/www/myblog/textpattern/setup/index.php on line 188

Can’t connect to database</strong>

Sorry I’m very new to all of this, appreciate all the help I can get. :)

#2 2006-03-19 17:42:09

mrdale

Member

From: Walla Walla

Registered: 2004-11-19

Posts: 2,215

Website

Re: Database Connection Problems ..

are you sure the setting ‘localhost’ is correct? Your setup looks similar to 1and1 hosting, and I know that they require you to specify a path to your server. Just a thought.

You might also try connecting to your database via the command line.

1. SSH into your host.
2. login to mysql
3. use ‘database_name’

If you can get to your db that way, you should be able to get to it with TXPs settings…

Hope this helps.

#3 2006-03-19 17:54:23

cmachine

New Member

Registered: 2006-03-19

Posts: 3

Re: Database Connection Problems ..

I’m with Netfirms. The path to my server would be www.domain-name.com?

How do I SSH? I can add admin accounts to the database via the cpanel.

Thanks.

#4 2006-03-19 20:18:51

mrdale

Member

From: Walla Walla

Registered: 2004-11-19

Posts: 2,215

Website

Re: Database Connection Problems ..

Here is a wealth of info on database management at netfirms. Found it with this amazing thing called google.

Looks like you need to use mysqlhost for a host name rather than localhost

hope this helps…

#5 2006-03-19 22:21:46

cmachine

New Member

Registered: 2006-03-19

Posts: 3

Re: Database Connection Problems ..

That worked.

The other mistake I was doing was entering MYSQLHOST_u70220892 where I should’ve only entered u70220892, that instructions (yourhostID_databaseUserID) threw me off there.

Anyway thanks a lot mrdale. :)