Hi Alastair, Yip somebody pointed me towards the address from the returned mail ;-p. Now for the answers to your questions:
1. I did create a user and a group for mysql by using: shell> chown -R root /usr/local/mysql shell> chown -R mysql /usr/local/mysql/data shell> chgrp -R mysql /usr/local/mysql shell> chown -R root /usr/local/mysql/bin 2. Here is the output for the permissions: ls -l /usr/local ===================================== george@linux:~> ls -l /usr/local total 9163 drwxr-xr-x 2 root root 35 Sep 22 15:08 bin drwxr-xr-x 2 root root 35 Sep 22 15:08 etc drwxr-xr-x 2 root root 35 Sep 22 15:08 ftp drwxr-xr-x 2 root root 35 Sep 22 15:08 games drwxr-xr-x 4 root root 80 Feb 21 10:18 httpd drwxr-xr-x 2 root root 35 Sep 22 15:08 include drwxr-xr-x 2 root root 35 Feb 21 10:25 info drwxr-xr-x 2 root root 35 Sep 22 15:08 lib drwxr-xr-x 12 root root 257 Feb 21 08:45 man lrwxrwxrwx 1 root mysql 39 Feb 21 10:35 mysql -> mysql-max-4.0.1-alpha-pc-linux-gnu-i686 drwxrwxrwx 13 505 mysql 516 Dec 23 17:45 mysql-max-4.0.1-alpha-pc-linux-gnu-i686 -rwxr-xr-x 1 root root 9372593 Feb 20 22:48 mysql-max-4.0.1-alpha-pc-linux-gnu-i686.tar.gz drwxr-xr-x 2 root root 35 Sep 22 15:08 sbin drwxr-xr-x 2 root root 35 Sep 22 15:08 share drwxr-xr-x 2 root root 35 Sep 22 15:08 src ls -l /usr/local/mysql ===================================== ls -l /usr/local/mysql lrwxrwxrwx 1 root mysql 39 Feb 21 10:35 /usr/local/mysql -> mysql-max-4.0.1-alpha-pc-linux-gnu-i686 ls -l /usr/local/mysql/data ===================================== ls -l /usr/local/mysql/data total 13 -rw-r--r-- 1 mysql root 9900 Feb 21 11:34 linux.err drwxrwxrwx 2 mysql mysql 506 Feb 21 10:45 mysql drwxrwxrwx 2 mysql mysql 35 Dec 23 17:44 test Thanks, George (mysql, query) On Saturday 23 February 2002 00:50, alastair wrote: > On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote: > > I posted a question but received a message stating the file was to large? > > Look at the message. Some idiot's mailbox is over the limit. Anytime I > post to this list I get 2 return mails bounced from lusers. > > With regards to your problem - > > 1) don't yopu really want to create a mysel user/group and use that as > an arg to --user? > > 2) what are the exact permissions to your data dir? > > ls -l /usr/local > ls -l /usr/local/mysql > ls -l /usr/local/mysql/data > > Cheers, --------------------------------------------------------------------- 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