How to run mysql ???
Hi I am new in mysql. I 've compiled and installed mysql-3.23.47 from the source on HPUX version 11.00 platform. I have two questions. first: Is it possible to start mysql from NFS tree Two : when I run ./bin/safe_mysqld or ./bin/safe_mysqld --user=mysql as root, I get the error shown below, but when I run ./bin/safe_mysqld --user=mysql as mysql user, everything works fine!!!, Is it possible to start mysql as root??? Is it safe to run it as mysql user Thanks __Mehdi 020122 10:01:56 mysqld started ^/opt/mysql/libexec/mysqld: File './quioch-bin.1' not found (Errcode: 13) 020122 10:02:00 Could not use quioch-bin for logging (error 13) 020122 10:02:00 /opt/mysql/libexec/mysqld: Can't create/write to file '/opt/mysql/var/quioch.pid' (Errcode: 13) 020122 10:02:00 /opt/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 1 3) 020122 10:02:00 /opt/mysql/libexec/mysqld: Normal shutdown 020122 10:02:00 /opt/mysql/libexec/mysqld: Error on delete of '/opt/mysql/var/quioch.pid' (Errcode: 13) 020122 10:02:00 mysqld ended - 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
Re: How to run mysql ???
Hi, M. Lavasani wrote : Hi I am new in mysql. I 've compiled and installed mysql-3.23.47 from the source on HPUX version 11.00 platform. I have two questions. first: Is it possible to start mysql from NFS tree I have never done it myself but according to posts on this mailing list, it should work. Two : when I run ./bin/safe_mysqld or ./bin/safe_mysqld --user=mysql as root, I get the error shown below, but when I run ./bin/safe_mysqld --user=mysql as mysql user, everything works fine!!!, Is it possible to start mysql as root??? Is it safe to run it as mysql user Generally 'root' is mapped to 'nobody' by NFS servers so it is normal that you get error 13 (permission denied). It is always safer to run an application without root privileges. I don't see why it wouldn't be the case for mysql. Thanks __Mehdi 020122 10:01:56 mysqld started ^/opt/mysql/libexec/mysqld: File './quioch-bin.1' not found (Errcode: 13) 020122 10:02:00 Could not use quioch-bin for logging (error 13) 020122 10:02:00 /opt/mysql/libexec/mysqld: Can't create/write to file '/opt/mysql/var/quioch.pid' (Errcode: 13) 020122 10:02:00 /opt/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 1 3) 020122 10:02:00 /opt/mysql/libexec/mysqld: Normal shutdown 020122 10:02:00 /opt/mysql/libexec/mysqld: Error on delete of '/opt/mysql/var/quioch.pid' (Errcode: 13) 020122 10:02:00 mysqld ended - 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 Hope this helps -- Joseph Bueno NetClub/Trader.com - 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
Re: How can run Mysql program from different user (NOT only root) ?
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
Re: How can run Mysql program from different user (NOT only 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 mysql512 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
Re: How can run Mysql program from different user (NOT only root) ? (Solved !)
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 mysql512 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
Re: How can run Mysql program from different user (NOT only root) ?
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 mysql512 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 other773 Dec 5 16:30 configure drwxr-xr-x 5 mysqlother512 Dec 28 12:00 data drwxr-xr-x 2 root other 1024 Dec 5 16:30 include drwxr-xr-x 2 root other512 Dec 5 16:30 lib drwxr-xr-x 2 root other512 Dec 5 16:30 man -rwxr--r-- 1 root other2324374 Dec 5 16:30 manual.html -rwxr--r-- 1 root other2009009 Dec 5 16:30 manual.txt -rwxr--r-- 1 root other 85339 Dec 5 16:30 manual_toc.html drwxr-xr-x 6 root other512 Dec 5 16:30 mysql-test drwxr-xr-x 2 root other512 Dec 5 16:30 scripts drwxr-xr-x 3 root other512 Dec 5 16:30 share drwxr-xr-x 7 root other512 Dec 5 16:30 sql-bench drwxr-xr-x 2 root other512 Dec 5 16:30 support-files drwxr-xr-x 2 root other512 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
Re: How can run Mysql program from different user (NOT only root) ?
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 only Unix box admin can run the MySQL program ). Does anyone can teach me how to solve my problem ? Thanks ! Thanks a again, Kevin Chan Jaime Teng Wrote 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 mysql512 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 other773 Dec 5 16:30 configure drwxr-xr-x 5 mysqlother512 Dec 28 12:00 data drwxr-xr-x 2 root other 1024 Dec 5 16:30 include drwxr-xr-x 2 root other512 Dec 5 16:30 lib drwxr-xr-x 2 root other512 Dec 5 16:30 man -rwxr--r-- 1 root other2324374 Dec 5 16:30 manual.html -rwxr--r-- 1 root other2009009 Dec 5 16:30 manual.txt -rwxr--r-- 1 root other 85339 Dec 5 16:30 manual_toc.html drwxr-xr-x 6 root other512 Dec 5 16:30 mysql-test drwxr-xr-x 2 root other512 Dec 5 16:30 scripts drwxr-xr-x 3 root other512 Dec 5 16:30 share drwxr-xr-x 7 root other512 Dec 5 16:30 sql-bench drwxr-xr-x 2 root other512 Dec 5 16:30 support-files drwxr-xr-x 2 root other512 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