CREATE command denied to user

pollo · 2006-03-14 05:27:16

During install, I connected to the database, but then I got 135 errors:
CREATE command denied to user
INSERT command denied to user

over and over again.

What did I do wrong?

Thanks

zem · 2006-03-14 05:36:16

You need to make sure that your MySQL user access settings permit table creation.

pollo · 2006-03-14 06:10:05

zem wrote:

You need to make sure that your MySQL user access settings permit table creation.

How can I do that? I have access to phpmyadmin, can I use that?

Thanks

zem · 2006-03-14 07:07:42

It depends on how your hosting provider has set things up. Often database user management is done with another tool, not phpMyAdmin. You’ll need to ask them.

What you need to do is grant ‘create’ privileges to your database user, for your textpattern db. Simplest method is to grant ‘all’.

pollo · 2006-03-15 03:39:56

Thanks! I contacted them and they fixed the problem!

Textpattern CMS

Textpattern CMS support forum

#1 2006-03-14 05:27:16

CREATE command denied to user

#2 2006-03-14 05:36:16

Re: CREATE command denied to user

#3 2006-03-14 06:10:05

Re: CREATE command denied to user

#4 2006-03-14 07:07:42

Re: CREATE command denied to user

#5 2006-03-15 03:39:56

Re: CREATE command denied to user

Board footer