Thanks, it was just about the set the right for the mysql user, as - you already correctly mentioned - mysql runs as user mysql.
Thanks and regards, Stephan Gloor > Stephan Gloor wrote: > >>On Fri, 4 Oct 2002, Stephan Gloor wrote: > >> > >> > >>>When trying to create an index on > >>> > >>>Table ANSCHLUSS: > >>>| ID | int(11) | | PRI | NULL | auto_increment | > >>>| TELEFON | varchar(20) | | MUL | | | > >>>| REGION | int(11) | | | 0 | | > >>>| LAND | int(11) | | | 0 | | > >>>| NETZ | tinyint(4) | | | 0 | | > >>>| PROTOKOLLTYP | tinyint(4) | | | 0 | | > >>>| ANZAHLANRUFE | int(11) | | | 0 | | > >>>| AUSCALLERID | tinyint(4) | | | 0 | | > >>> > >>>containing 481484 records, > >>> > >>>mysql yields > >>> > >>>mysql> CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND, > >>>NETZ); > >>>ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj' > >>>(Errcode: 13) > >> > >>Stephan, > >> > >>tsp@host:~> perror 13 > >>Error code 13: Permission denied > >> > >>It must have to do with permissions; > >>whats the result of 'ls /home/data/mysql/tmp/' ? > >> > >>Thomas > >> > > > > > > > > The mysql is running from the root user the rights for the temp directory > > are: > > drwxr-xr-x 2 root root 35 Oct 4 08:08 tmp/ > > > > > > > >>>Only 18% of the disk are in use, df shows that there are 28'103'092 KB > >>>available. root, the owner has rights enough, mysql is started from the > >> > > root > > > >>>user. > >>>(drwxr-xr-x 2 root root 35 Oct 4 08:08 tmp/) > >>> > >>>OS: Linux > >>> > >>>Thanks and regards for any comment. > >>> > >>>Stephan Gloor > >> > >>filter: sql, query > >> > Hi, > > Are you really sure that mysqld is running as root ? > It runs normally as 'mysql' user unless you explicitely start > safe_mysqld with '--user=root' option (which is a really Bad Idea (TM)). > > Regards > -- > Joseph Bueno --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
