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