Re: Permissions problems

2002-07-17 Thread Gerald Clark
If mysql owns them, 0770 should be fine. System Administrator a.k.a. The Root of the Problem wrote: >USually all the databases sets up fine BUT recently, I have >had to adjust databases to 0777 in order to get them to >work and change the ownership. > >I prefer the more secure model of mysql. >

Re: Permissions Problems

2001-08-14 Thread Butch Evans
On Tue, 14 Aug 2001, Gerald Clark wrote: >You are connecting TO host www.4cdg.com, but the permission table entry >list the hosts you connect FROM. > Actually, it is just one host...I am running on FreeBSD and I have to specify the hostname on the command line. >You need to grant privileges to

Re: Permissions Problems

2001-08-14 Thread Gerald Clark
You are connecting TO host www.4cdg.com, but the permission table entry list the hosts you connect FROM. You need to grant privileges to the user and machine you connect FROM. Butch Evans wrote: > Can anyone explain why this is happening? > > > root@www:/# mysql -u dgadmin -h www.4cdg.com -p

Re: Permissions Problems

2001-08-13 Thread indrek siitan
Hi, > Can anyone explain why this is happening? > > > root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog > Enter password: > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' > (Using password: YES) remove the space between -p and the password. Rgds, Indrek -- For technical

RE: Permissions Problems

2001-08-13 Thread Carsten H. Pedersen
Do not put a space between "-p" and "cdgcatalog", i.e. use "-pcdgcatalog". / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq > -Original Message- > From: Butch Evans [mailto:[EMAIL PROTECTED]] > Sent: 14. august 2001 07:48