Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread Jörg Reisenweber
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

Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread John Oxley
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,

Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread J. Martin Petersen
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

RE: groupadd/useradd in FreeBSD?

2005-07-28 Thread Xu Qiang
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

RE: groupadd/useradd in FreeBSD?

2005-07-28 Thread Xu Qiang
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

Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread Dan Nelson
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

RE: groupadd/useradd in FreeBSD?

2005-07-28 Thread Xu Qiang
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

Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread Jörg Reisenweber
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

Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread Dan Nelson
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

RE: groupadd/useradd in FreeBSD?

2005-07-28 Thread Xu Qiang
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

RE: groupadd/useradd in FreeBSD?

2005-07-28 Thread Xu Qiang
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

Re: groupadd/useradd in FreeBSD?

2005-07-28 Thread Dan Nelson
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'