PLEASE CC ME BECAUSE I'M NOT IN THE LIST... Thanks! I'm having a problem:
ERROR 1017: Can't find file: './mysql/adminedit.frm' (errno: 13) I've searched in the archive and find a solution. It says that is a permission problem and to make all the files owned by mysql.mysql. This works, but I want to make some users to have they own databases. I thought making something like this: drwxrws--- 2 user mysql 1024 Jun 12 18:21 user -rw-rw---- 1 user mysql 75602 Sep 2 13:12 user/table.ISD -rw-rw---- 1 user mysql 6144 Sep 2 13:12 user/table.ISM -rw-rw---- 1 user mysql 8654 Jun 12 18:21 user/table.frm So the user own the table but mysql can read/write to database (as well as administrators that belongs to mysql group). The problem is I still getting this error... the only way to avoid it is to set mysql user as owner... why is this? Is there a way to do what i want to do? Why even when mysqld is running as mysql (in mysql group) or root it can't read the files? root 8703 0.0 0.0 2460 0 ? SW Oct17 0:00 [safe_mysqld] mysql 8737 0.0 2.4 37348 1124 ? S Oct17 0:00 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my mysql 8740 0.0 2.4 37348 1124 ? S Oct17 0:01 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my mysql 8741 0.0 2.4 37348 1124 ? S Oct17 0:00 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my mysql 8742 0.0 2.4 37348 1124 ? S Oct17 0:00 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my Thanks! -- LUCA - Leandro Lucarella ------------------------ [EMAIL PROTECTED] http://www.luca.2y.net LICQ UIN: 2847576 ------------------------ Usando Debian GNU/Linux --------------------------------------------------------------------- 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