Thousands of users? Newbie question

Hi Guys, I intend my online database to be used by 100 or so companies each with up to 100 employees. Each of these employees may add data as required. I don't want to assign one password for an entire company, in case one disgruntled ex-employee decides to post erroneous data. So presumably I

Re: changing mysqld deamon ownership.

-- From: "Kamara Eric R-M" <[EMAIL PROTECTED]> To: "2Hosts.com" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 1:15 AM Subject: Re: changing mysqld deamon ownership. > > Yeah...I don't think you need to make any changes.. > &g

Re: changing mysqld deamon ownership.

t; If you want to use another Linux user account than you will have to create it, > > useradd > passwd > > You will also need to chnage the user and usergrp. > > go to the database directory f.e. > > cd var/lib/mysql > > chown -R * > chgrp -R gr

Re: changing mysqld deamon ownership.

Thanks Kamara, So does that mean I don't need to change anything? > > > [admin admin]$ ps auxw | grep mysqld > > root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh > > /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ > > > Presumably the "root" on line one shows i

Re: changing mysqld deamon ownership.

> or > > [safe_mysqld] > user=mysql > > That should be it. > > Best regards > > Nils Valentin > Tokyo/Japan > > PS: The same question was asked within the last 24 hours. Look for threat > "database permissions" from Ted ;-) > > 2003年 5月 30日 金曜日 16:1

Re: changing mysqld deamon ownership.

Hi Nils, Thanks for your help. I am trying to get my head round it. I'm on a unix Cobalt RaQ 4 which is using Cobalt OS V6 and Cobalt MySQL 3.23.37-1 - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "2Hosts.com" <[EMAIL PROTECTED]&

Re: changing mysqld deamon ownership.

> Hi guys, > > On page 54 of the Sams "teach yourself MySQL in 24 hrs" it says the owner > should not be root, and to change it. I can't seem to find out how to do > this - could anyone guide me in the right direction please? > > I searched the list archives to no avail. > Many thanks. :o) > Sor

changing mysqld deamon ownership.

Hi guys, On page 54 of the Sams "teach yourself MySQL in 24 hrs" it says the owner should not be root, and to change it. I can't seem to find out how to do this - could anyone guide me in the right direction please? I searched the list archives to no avail. Many thanks. :o) -- MySQL General

.ezm files

sorry for being a thikky, but how do i open a .ezm file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

timestamps and time zones

Bearing in mind the international nature of the internet, how do I make a timestamp local to the user rather than local to my webserver in Canada? If a user is adding a record to my database from England, I want the timestamp to be GMT rather than PST, and the same for my Australian clients, and s