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 VSZRS

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 H

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:http://lists.mysql

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

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] http://www.

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

database permissions

2003-05-28 Thread trogers
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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RES: Mysql database permissions questions

2002-08-16 Thread Ray da Costa
. Ass.: RaydaCosta -Mensagem original- De: Paras pradhan [mailto:[EMAIL PROTECTED]] Enviada em: Sexta-feira, 16 de Agosto de 2002 09:08 Para: [EMAIL PROTECTED] Assunto: Mysql database permissions questions hi all when i connect to my mysql database server using mysql -h a.b.c.d

Mysql database permissions questions

2002-08-16 Thread Paras pradhan
hi all when i connect to my mysql database server using mysql -h a.b.c.d -u xyz -pmypass It logs on and it's fine and in mysql shell when i do "use mysql" then it is allowing me to acess the mysql default "mysql" database. i dunn't want this. when i type "use mysql" then it sud say acc

RE: User/database permissions

2002-01-11 Thread Gary . Every
your output from USE mysql; DESC db; commands. -Original Message- From: Intercession Tech Support [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 3:09 PM To: [EMAIL PROTECTED] Subject: User/database permissions This is going to be a very basic question, so please excuse me. I h

User/database permissions

2002-01-11 Thread Intercession Tech Support
This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it down

RE: Database Permissions

2001-02-26 Thread Trevor Harris
nsultant 14 Oak Park Bedford, MA 01730 USA E-mail: [EMAIL PROTECTED]http://www.nusphere.com Tel 781-280-4243 Fax 781-280-4901 ~~~~~~

Database Permissions

2001-02-26 Thread Jason Frisvold
Greetings, I'm having a little trouble understanding how the permissions work within mySQL. I have 3 current databases. The first is the default mysql database, and the other 2 are ones that I have created. I want to be able to grant access to each table individually based on username.

Database Permissions

2001-02-21 Thread Ashutosh Somani
Hi- I have run into many problems with the tight security features of mysql. In particular, consider this situation: I start the mysql daemon as "root", create a database (say "test"), and "grant all" permissions on this database to another user (say "temp"). Then, when I shutdown the daemon an