Re: Mysqld running as root.

2001-04-20 Thread Sean Strycker

Thankx,

That did the trick!  So simple yet so. well... simple!

- Original Message -
From: Gerald Clark <[EMAIL PROTECTED]>
To: Sean Strycker <[EMAIL PROTECTED]>
Cc: MySQL <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 6:27 AM
Subject: Re: Mysqld running as root.


> add user=mysql to the [mysqld] section of /etc/my.cnf
> EX:
>
> [mysqld]
> user=mysql
>
> Sean Strycker wrote:
> >
> > Hello,
> >
> > I'm a newbe to Linux and MySQL, but I'm finding it very interesting.
> >
> > I'll cut right to the chase - I've followed the directions in the manual
for the binary install on Linux.  but every time I start up the mysql daemon
and do a pstree -laup, it's running as root.
> >
> > This is on a development / play machine so it's not that big a deal, but
my system admin says that I have to run it as user=mysql.
> >
> > I've tried changing the mysql.server script, the my.cnf file, etc.  I
cant figure it out  - how to make it start up and run as user=mysql!?!
> >
> > Anywho - any help would be appreciated.
> >
> > Thanks,
> >
> > Sean.
>
> -
> 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: Mysqld running as root.

2001-04-20 Thread Gerald Clark

add user=mysql to the [mysqld] section of /etc/my.cnf
EX:

[mysqld]
user=mysql

Sean Strycker wrote:
> 
> Hello,
> 
> I'm a newbe to Linux and MySQL, but I'm finding it very interesting.
> 
> I'll cut right to the chase - I've followed the directions in the manual for the 
>binary install on Linux.  but every time I start up the mysql daemon and do a pstree 
>-laup, it's running as root.
> 
> This is on a development / play machine so it's not that big a deal, but my system 
>admin says that I have to run it as user=mysql.
> 
> I've tried changing the mysql.server script, the my.cnf file, etc.  I cant figure it 
>out  - how to make it start up and run as user=mysql!?!
> 
> Anywho - any help would be appreciated.
> 
> Thanks,
> 
> Sean.

-
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: Mysqld running as root.

2001-04-19 Thread Lu, Ping

The biggest help is from INSTALL-SOURCE in the source tarball.
==
The basic commands you must execute to install and use a *MySQL* binary
distribution are:

 shell> groupadd mysql
 shell> useradd -g mysql mysql
 shell> cd /usr/local
 shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
 shell> ln -s mysql-VERSION-OS mysql
 shell> cd mysql
 shell> scripts/mysql_install_db
 shell> chown -R root  /usr/local/mysql
 shell> chown -R mysql /usr/local/mysql/var
 shell> chgrp -R mysql /usr/local/mysql
 shell> chown -R root /usr/local/mysql/bin/
 shell> bin/safe_mysqld --user=mysql &
==

Ping Lu
Cable & Wireless Global
Network Tools and Analysis Group, USA
W: +1-703-292-2359
E: [EMAIL PROTECTED]


> -Original Message-
> From: Sean Strycker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 7:20 PM
> To: MySQL
> Subject: Mysqld running as root.
> 
> 
> 
> Hello,
> 
> I'm a newbe to Linux and MySQL, but I'm finding it very interesting.
> 
> I'll cut right to the chase - I've followed the directions in 
> the manual for the binary install on Linux.  but every time I 
> start up the mysql daemon and do a pstree -laup, it's running as root.
>  
> This is on a development / play machine so it's not that big 
> a deal, but my system admin says that I have to run it as user=mysql.
> 
> I've tried changing the mysql.server script, the my.cnf file, 
> etc.  I cant figure it out  - how to make it start up and run 
> as user=mysql!?!
> 
> Anywho - any help would be appreciated.
> 
> Thanks, 
> 
> Sean.
> 

-
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