Click to See Complete Forum and Search --> : Problem creating table


Perfidus
05-07-2008, 10:49 AM
Hi there; I'm using phpmyadmin to create a table in a database that I havent create myself, it looks like I'm missing some permissions or something is wrong because it doesn't allw me to write:
THE QUERY

CREATE TABLE `commonusers` (

`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT ,
`user` VARCHAR( 20 ) NOT NULL ,
`pass` VARCHAR( 20 ) NOT NULL ,
`dep` VARCHAR( 100 ) NOT NULL ,
`priv` VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( `id` )
)


THE ERROR MESSAGE:
#1 - Can't create/write to file './thedatabase/usuarios.frm' (Errcode: 13)

Does anybody have a hint for me about what can be going on?
The mysql manual is really poor about this issue.

chazzy
05-07-2008, 12:16 PM
it's exactly what you just said. the user that the web server is running under doesn't have access to the directories the DB is in.

Perfidus
05-07-2008, 12:21 PM
Yeah, is exactly this, the access was only granted under plesk...
Thank's for your tip.