Dear Luke and all, Thanks Luke... my problem was solved ! Also, I would like to say thanks for all of you who try to help me before ! THANKS A LOT ! Thanks again!
Best regards, Kevin Chan < Luke Wrote> > Sounds like you don't have permission to execute the file mysql in > /usr/local/mysql/bin. > > Try chmod a+x "/usr/local/mysql/bin/mysql" while root. > > >Dear Steve and all, > > > >Thanks Steve ! > >Yes Steve, I have no problem to run MySQL with user - 'kevin' when I use > >root telnet to server and the example as below: > > > ># pwd > >/usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin > ># > ># ./mysql -h192.10.0.113 -ukevin -p > >Enter password: > >Welcome to the MySQL monitor. Commands end with ; or \g. > >Your MySQL connection id is 40 to server version: 3.23.46 > > > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > >mysql> > > > > > >But I got an error message when I use kevin's account telent to server and > >try to run MySQL with user - 'kevin' and the example as below: > > > >bash-2.03$ pwd > >/usr/local/mysql/bin > >bash-2.03$ ./mysql -h192.10.0.113 -ukevin -p > >bash: ./mysql: Permission denied > > > > > >The directory of /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin and > >/usr/local/mysql/bin are the same : > ># 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 > > > >Please teach me what is the problem cause the error message "Permission > >denied" when not using root to run the MySQL program? Thanks ! > > > >Thanks again, > >Kevin Chan > > > ><Steve Rapaport Wrote> > > > >> > 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 > >> > >> Kevin, this should be solved at the MySQL user permissions level, > >> not at the UNIX user permissions level, I think. > >> > >> The person who administers MySQL is not necessarily the person who > >> ran the server. > >> > >> Mysqld (the server daemon) > >> should be run by root, when the machine is started, using > >> a startup script. You may also run it manually as root. > >> > >> Then you may create a MySQL "admin" userid within MySQL, with > >> full admin permissions. Give that name and password to your > >> 2 admin people. > >> > >> Either of them can then, from their own unix account, type: > >> > >> mysql -uadmin -p > >> Password: ******* > >> > >> and now they can admin MySQL. > >> > >> For more information read http://www.mysql.com/doc/U/s/User_names.html > >> and http://www.mysql.com/doc/G/R/GRANT.html > >> > >> Good luck, > >> Steve > > > > > >--------------------------------------------------------------------- > >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