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