Re: database permissions

2003-05-30 Thread Jon Haugsand
* [EMAIL PROTECTED] Thanks, I get: [localhost:~] ted% ps ax |grep mysql 180 ?? S 0:00.04 sh /usr/bin/safe_mysqld 197 ?? S 0:00.21 /usr/libexec/mysqld 2054 std R+ 0:00.00 grep mysql does this look good? safe? Try: ps aux | grep -E 'USER|mysql' -- Jon

Re: database permissions

2003-05-30 Thread Jon Haugsand
* [EMAIL PROTECTED] On Friday, May 30, 2003, at 03:23 AM, Jon Haugsand wrote: ps aux | grep -E 'USER|mysql' Do you mind telling me what these mean, I'd appreciate it greatly: I know what PID and CPU and MEM are... ps aux | grep -E 'USER|mysql' USERPID %CPU %MEM VSZRSS TT

Re: database permissions

2003-05-29 Thread trogers
On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote: * [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my system the mysqld deamon runs as mysql and files are owned by

Re: database permissions

2003-05-29 Thread trogers
Thanks, I get: [localhost:~] ted% ps ax |grep mysql 180 ?? S 0:00.04 sh /usr/bin/safe_mysqld 197 ?? S 0:00.21 /usr/libexec/mysqld 2054 std R+ 0:00.00 grep mysql does this look good? safe? Thanks again, Ted On Wednesday, May

Re: database permissions

2003-05-29 Thread otherguy
On Wednesday, May 28, 2003, at 07:40 PM, [EMAIL PROTECTED] wrote: On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote: * [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my

Re: database permissions

2003-05-29 Thread otherguy
On Wednesday, May 28, 2003, at 08:16 PM, otherguy wrote: ps -U httpd I screwed this up. It's been a long day. Of course it should be: ps -U mysqld sorry about that -Cameron Wilhelm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: database permissions

2003-05-28 Thread trogers
oops, oh yeah. I fixed it. TR On Wednesday, May 28, 2003, at 05:56 AM, [EMAIL PROTECTED] wrote: What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list

Re: database permissions

2003-05-28 Thread Jon Haugsand
* [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my system the mysqld deamon runs as mysql and files are owned by mysql. -- Jon Haugsand, [EMAIL PROTECTED]

RE: Database Permissions

2001-02-26 Thread Trevor Harris
Jason There are 5 layers to access control in MySQL that are checked to see if a query can be executed. Starting from the most generic these layers are: User -- Db (and Host) -- Tables_priv -- Columns_priv The first layer that is found to have adequate privileges will cause the query to