Hi Jaime and all, Thanks Jaime to reply me message so fast ! I would like to set 2 different user to maintance MySQL machine. 1st user can maintance the Unix box and MYSQL program 2nd user ONLY can maintance the MySQL program
That's why I need to set another user to run MySQL program ( Now only Unix box admin can run the MySQL program ). Does anyone can teach me how to solve my problem ? Thanks ! Thanks a again, Kevin Chan <Jaime Teng Wrote> > Hi, > > Wasnt MySQL supposed to run as SU or ROOT or Administrator and > then create users within MySQL with restrictions? > > What you trying to do was give "RUN MySQL rights" to your unix > users. What if 3 unix users tried running mysql independently > of each other and each mySQL process were trying to open the > same database? > > Jaime > > At 11:03 AM 1/2/02 +0800, Kevin Chan wrote: > >Dear all, > > > >How I can set a different user to run MySQL (only root can run this program > >now) ? > > > >Error message when run the program from user: > > > >bash-2.03$ ./mysql --host=192.10.0.113 > >bash: ./mysql: Permission denied > > > >Is it something have been change on the usr/group setting for the mysql > >directory? > > > ># ls -l /usr/local/ > >lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql -> > >mysql-3.23.46-sun-solaris2.8-sparc > >drwxr-xr-x 13 root mysql 512 Dec 5 16:30 > >mysql-3.23.46-sun-solaris2.8-sparc > ># > ># ls -l > >total 9400 > >-rwxr--r-- 1 root other 19106 Dec 5 16:30 COPYING > >-rwxr--r-- 1 root other 47577 Dec 5 16:30 COPYING.LIB > >-rwxr--r-- 1 root other 122213 Dec 5 16:30 ChangeLog > >-rwxr--r-- 1 root other 147258 Dec 5 16:30 INSTALL-BINARY > >-rwxr--r-- 1 root other 1976 Dec 5 16:30 README > >drwxr-xr-x 2 root other 1024 Dec 5 16:29 bin > >-rwxr--r-- 1 root other 773 Dec 5 16:30 configure > >drwxr-xr-x 5 mysql other 512 Dec 28 12:00 data > >drwxr-xr-x 2 root other 1024 Dec 5 16:30 include > >drwxr-xr-x 2 root other 512 Dec 5 16:30 lib > >drwxr-xr-x 2 root other 512 Dec 5 16:30 man > >-rwxr--r-- 1 root other 2324374 Dec 5 16:30 manual.html > >-rwxr--r-- 1 root other 2009009 Dec 5 16:30 manual.txt > >-rwxr--r-- 1 root other 85339 Dec 5 16:30 manual_toc.html > >drwxr-xr-x 6 root other 512 Dec 5 16:30 mysql-test > >drwxr-xr-x 2 root other 512 Dec 5 16:30 scripts > >drwxr-xr-x 3 root other 512 Dec 5 16:30 share > >drwxr-xr-x 7 root other 512 Dec 5 16:30 sql-bench > >drwxr-xr-x 2 root other 512 Dec 5 16:30 support-files > >drwxr-xr-x 2 root other 512 Dec 5 16:30 tests > > > >Please teach me, what I should change to make the program can run from > >different user (NOT only root)? Thanks a lot ! > > > > > >Thanks ang regards, > >Kevin Chan --------------------------------------------------------------------- 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
