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 > > > --------------------------------------------------------------------- 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
