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
