Re: How can run Mysql program from different user (NOT only root) ?

2002-01-02 Thread Steve Rapaport
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

Re: How can run Mysql program from different user (NOT only root) ?

2002-01-02 Thread Kevin Chan
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.

Re: How can run Mysql program from different user (NOT only root) ? (Solved !)

2002-01-02 Thread Kevin Chan
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.

Re: How can run Mysql program from different user (NOT only root) ?

2002-01-01 Thread Jaime Teng
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

Re: How can run Mysql program from different user (NOT only root) ?

2002-01-01 Thread Kevin Chan
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