Textpattern CMS

#1 2006-06-08 20:39:40

ktinkel

Member

Registered: 2004-06-04

Posts: 16

Another case of installation errors

I received 135 errors all of the general form:

INSERT [or CREATE]command denied to user: ‘desktopp_fub4@localhost’ for table ‘txp_[various]’

During the Setup process, Textpattern refused to ‘see’ (recognize) the DB until I created temporary tables; then it let me move to the next step.

But then we got stuck on that list of errors.

Could this be a permissions problem? The directories I checked were set at 755; the iles at 644. I changed permissions to 777 on several directories, including my root directory for the Textpattern installation, textpattern, and a few others, but it made no difference. (I did not change every single subdirectory and files, however.)

I have installed Textpattern on several different hosts (though not this one), and have never seen these errors. (And I have installed vBulletin, WordPress, and Joomla on this host, with no MySQL errors.)

But I am pretty much of a techie idiot, so need some advice.

#2 2006-06-08 20:50:46

Walker

Plugin Author

From: Boston, MA

Registered: 2004-02-24

Posts: 592

Website

Re: Another case of installation errors

Yes…..use was able to access MySQL but was not allowed to create, edit, or delete tables in the DB right here:

<code>INSERT [or CREATE]command denied to user: ‘desktopp_fub4@localhost’ for table ‘txp_[various]’</code>

---

Me, Myself, and I

#3 2006-06-08 20:55:36

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Another case of installation errors

It is a permissions problem, but not the sort you’re thinking of: your database user is not allowed to add tables to your database. Make sure that:

• your names and passwords are all correct
• that your user has been “added” to your database
• that your user has permissions to add tables to your database

#4 2006-06-08 21:14:17

ktinkel

Member

Registered: 2004-06-04

Posts: 16

Re: Another case of installation errors

Mary wrote:

It is a permissions problem, but not the sort you’re thinking of: your database user is not allowed to add tables to your database. Make sure that:

• your names and passwords are all correct
• that your user has been “added” to your database
• that your user has permissions to add tables to your database

You are so right. When I thought I was asking the system to create temporary tables earlier, I was actually limiting my user to that function. Sigh.

All better now — on to the next step.

Thanks very much for your rapid reply.

#5 2006-06-08 21:15:15

ktinkel

Member

Registered: 2004-06-04

Posts: 16

Re: Another case of installation errors

Walker wrote:

Yes…..use was able to access MySQL but was not allowed to create, edit, or delete tables in the DB . . .

Right you are. I did it to myself. Thanks very much for the help.