Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2008-03-22 07:28:41

jm
Plugin Author
From: Missoula, MT
Registered: 2005-11-27
Posts: 1,746
Website

Re: Error during set up

If you’re still getting the access denied error, it means your user doesn’t have access to the database. Have you checked your host’s help docs on databases?

Also, if you want a faster way to check your connection errors, upload this file to your web root as cnx.php:

<?php
//uri: http://example.com/cnx.php
$link = mysql_connect('localhost', 'db_username', 'password') or die(mysql_error());
$db = mysql_select_db('database_name') or die(mysql_error());
?>

Last edited by jm (2008-03-22 07:30:01)

Offline

#14 2008-03-22 07:39:14

rendesign
Member
Registered: 2008-03-22
Posts: 12

Re: Error during set up

WHAT? Ask my provider for help? Well yes I could but Id have to wait a week for a reply and throw a bomb under him. Im only with him because when I was due to renew he doubled my space for nothing….yay….

He had aggravated me so much with slow service sometimes taking a week to reply to one question that I bought new space from another provider and their server crashed within a week of me signing up.

Asking my old provider for help is out of the question I dont want to wait a week for a reply.

Offline

#15 2008-03-22 07:40:43

rendesign
Member
Registered: 2008-03-22
Posts: 12

Re: Error during set up

I have a question do any files or folders need to be changed to 777 using CHMOD? because I cant see that mentioned in the instructions and you need to do that for Serendipity and a lot of other things Ive installed.

Offline

#16 2008-03-22 07:51:17

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: Error during set up

Yes, you possibly might. But no, you don’t need to change file permissions for, nor during, the setup, as Textpattern doesn’t create any files nor folders during the “amazing” installation (actually even it wouldn’t require permission changes as server can do it with out any hazzle). TXP just inserts couple tables and columns to your database. But if you want to upload images / files via TXP backend, you must change permissions for images and files directory – but it has nothing, read zero, to do with your installation hazzle & puzzle.

Last edited by Gocom (2008-03-22 07:52:48)

Offline

#17 2008-03-22 08:06:20

jm
Plugin Author
From: Missoula, MT
Registered: 2005-11-27
Posts: 1,746
Website

Re: Error during set up

OK so back to the database. Upload the cnx.php file to avoid any confusion. Here are a few possible explanations for whatever errors you encounter:

  1. Your user does not exist.
  2. The user password is incorrect.
  3. The user does not have appropriate permissions.
  4. The database does not exist.

Offline

#18 2008-03-22 09:07:28

rendesign
Member
Registered: 2008-03-22
Posts: 12

Re: Error during set up

Ok what do I do when it is uploaded

Offline

#19 2008-03-22 09:43:17

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: Error during set up

Ok what do I do when it is uploaded

Open the uploaded cnx.php with your browser, but also remember to change the values in the script to correspond your details. Then, paste the outputed error here or use your brainz. :)

Last edited by Gocom (2008-03-22 09:43:54)

Offline

#20 2008-03-22 09:50:42

rendesign
Member
Registered: 2008-03-22
Posts: 12

Re: Error during set up

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘helen62_text’@‘localhost’ (using password: YES) in /home/helen62/public_html/myblog/cnx.php on line 3
Access denied for user ‘helen62_text’@‘localhost’ (using password: YES)

Thats my database name. I chose TEXT during the wizard set up and it told me the full name was helen62_text

Last edited by rendesign (2008-03-22 09:51:57)

Offline

#21 2008-03-22 10:12:37

rendesign
Member
Registered: 2008-03-22
Posts: 12

Re: Error during set up

I just tried to install Serendipity and had the same problem it looks like my provider has done something so I cant upload my own stuff. I had to put a bomb under his butt not long ago because when I bought my space again he had removed Fantastico. I had to get quite aggressive to get him to reinstall it because after 2 months of promises it wasnt done.

Offline

#22 2008-03-22 11:33:45

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Error during set up

Have you considered switching to a different hosting company?

Offline

#23 2008-03-22 12:02:49

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: Error during set up

ruud wrote:

Have you considered switching to a different hosting company?

Ruud is right. It may take more money, but good host or service isn’t cheap. Cheap is in most cases reseller or one person with one server that is absolutely too loaded. Couple dollars more per month isn’t bad deal, if it brings better service aka a real company with a good and friendly support. If some cheap or almost free host says that they provide 100 GB space and unlimited bandwidth, it’s possibly a full lie. In reality their website is awesome, brizes are awesome, but they have only couple servers, 10 000 sites hosted and no real support service that can keep up with their clients. Also, every week new host pops out and then after a year goes goner…

Offline

#24 2008-03-22 18:32:11

jm
Plugin Author
From: Missoula, MT
Registered: 2005-11-27
Posts: 1,746
Website

Re: Error during set up

Textbook: Web hosts. I’d add your current host to the “Hosts to avoid” list.

Offline

Board footer

Powered by FluxBB