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'@'localh

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 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 DBI:mysql:

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.

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 ". Jörg ___ freebsd-questions@freebsd.org mailing lis

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 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

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 mailin

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

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 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". > >

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

groupadd/useradd in FreeBSD?

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