Re: groupadd/useradd in FreeBSD?
Hi, Am 28.07.2005 um 11:11 schrieb Xu Qiang: I need create some user account rather than root by the command groupadd mysql and useradd -g mysql mysql. pw groupadd mysql ; pw useradd mysql -g mysql Jörg___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: groupadd/useradd in FreeBSD?
On Thu, Jul 28, 2005 at 05:11:29PM +0800, Xu Qiang wrote: Hi, all: I am installing MySQL 4.1.13 into my machine. It has finished successfully. But before or after that, I need create some user account rather than root by the command groupadd mysql and useradd -g mysql mysql. However, these commands are not found in my FreeBSD 5.3 system. Try pw groupadd help and pw useradd help. -John smime.p7s Description: S/MIME cryptographic signature
Re: groupadd/useradd in FreeBSD?
Xu Qiang wrote: Hi, all: I am installing MySQL 4.1.13 into my machine. It has finished successfully. But before or after that, I need create some user account rather than root by the command groupadd mysql and useradd -g mysql mysql. However, these commands are not found in my FreeBSD 5.3 system. Any help on this issue? You're looking for adduser(8). If you install MySQL from ports, though, the user will be added automatically. Martin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: groupadd/useradd in FreeBSD?
Jörg Reisenweber wrote: pw groupadd mysql ; pw useradd mysql -g mysql Thanks for providing the correct usage of pw useradd. At first sight, I thought your pw useradd mysql -g mysql is a typo, which misplaced the first mysql and -g option, so I used pw useradd -g mysql mysql, but got an error saying pw: user name or id required Then I man pw, and found the usage of (pw) user add is a little different from the standard ones: pw [-V etcdir] useradd [name|uid] [-C config] [-q] [-n name] [-u uid] [-c comment] [-d dir] [-e date] [-p date] [-g group] [-G grouplist] [-m] [-k dir] [-w method] [-s shell] [-o] [-L class] [-h fd | -H fd] [-N] [-P] [-Y] In FreeBSD, it should be pw useradd username -g groupname, and not pw useradd -g groupname username. Last but not least, thanks for everyone who helped me in this thread. Regards, Xu Qiang ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: groupadd/useradd in FreeBSD?
Btw, Just think of this problem: Although I have added the user mysql to my machine, I didn't set its password. When does this newly added user get his/her password and change it? thanks, Regards, Xu Qiang ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: groupadd/useradd in FreeBSD?
In the last episode (Jul 28), Xu Qiang said: Btw, Just think of this problem: Although I have added the user mysql to my machine, I didn't set its password. When does this newly added user get his/her password and change it? No-one usually logs in as the mysql user, so you don't need to set one. Mysqld will automatically setuid() itself to the mysql user when it starts up. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: groupadd/useradd in FreeBSD?
Dan Nelson wrote: No-one usually logs in as the mysql user, so you don't need to set one. Mysqld will automatically setuid() itself to the mysql user when it starts up. Suppose it is a general scenario, not restricted to MySQL setup. How to set up a user's password after creating his/her uid/username? thanks, Regards, Xu Qiang ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: groupadd/useradd in FreeBSD?
Am 29.07.2005 um 02:53 schrieb Xu Qiang: Suppose it is a general scenario, not restricted to MySQL setup. How to set up a user's password after creating his/her uid/username? as root do a passwd user. Jörg ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: groupadd/useradd in FreeBSD?
In the last episode (Jul 29), Xu Qiang said: Dan Nelson wrote: No-one usually logs in as the mysql user, so you don't need to set one. Mysqld will automatically setuid() itself to the mysql user when it starts up. Suppose it is a general scenario, not restricted to MySQL setup. How to set up a user's password after creating his/her uid/username? You can use the passwd command as root, or if you want to set it from a script, you can use the -h option to pw usermod. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: groupadd/useradd in FreeBSD?
Maybe it is an off-topic question. I cd /usr/local/mysql/sql-bench and perl run_all_tests, just to get the following error: - Got error: 'Access denied for user 'root'@'localhost' (using password: NO)' when connecting to DBI:mysql:database=test;host=localhost with user: '' password: '' - By the way, before doing the bench test, I did this operation: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h gso_dev_2.workgroup password 'new-password' Is this the cause? Dan, I remember you said that mysqld will automatically setuid() itself to the mysql user when it starts up. How to let the bench test run? Thanks in advance, Regards, Xu Qiang ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: groupadd/useradd in FreeBSD?
Dan Nelson wrote: You set a password on mysql's root user, and probably didn't tell sql-bench about it. Take a look at the the sql-bench documentation or look at the run_all_tests script to find out how to tell it what the password is. Sorry I didn't read the file README in the sql-bench directory before asking the question. Now I run the test with perl run-all_tests --user=mysql, and it can run now. Thanks for pointing our that. :) Regards, Xu Qiang ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: groupadd/useradd in FreeBSD?
In the last episode (Jul 29), Xu Qiang said: Maybe it is an off-topic question. I cd /usr/local/mysql/sql-bench and perl run_all_tests, just to get the following error: - Got error: 'Access denied for user 'root'@'localhost' (using password: NO)' when connecting to DBI:mysql:database=test;host=localhost with user: '' password: '' - By the way, before doing the bench test, I did this operation: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h gso_dev_2.workgroup password 'new-password' You set a password on mysql's root user, and probably didn't tell sql-bench about it. Take a look at the the sql-bench documentation or look at the run_all_tests script to find out how to tell it what the password is. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]