From: Nestor Florez (Nflorezguhsd.net)
Date: Thu Nov 13 2003 - 14:56:36 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Victor,

I will fixed this, but I do not think this is th eproblem.
I have the same settings on both W2K and Mac OS X and it only fails on
the Mac
Also When I log in as nestor with a password on the Mac I can not
insert a record
from the ocmmand line. I can do this on my W2K database.

Thanks I will try it,

Nestor :-)

Nestor A. Florez

>>> Victor Pendleton <VPendletonhoovers.com> 11/13/2003 11:49:51 AM
>>>
Their are two nestor users. One with a password and one without a
password.
The one with connect from anywhere is only allowed to modify the test
database. Fix your privileges and you should be okay.

-----Original Message-----
From: Nestor Florez [mailto:Nflorezguhsd.net]
Sent: Thursday, November 13, 2003 1:04 PM
To: VPendletonhoovers.com; mysqllists.mysql.com
Subject: RE: Grant permissions problems - help

+---------------------------------------------------------------------------
--+
| Grants for nestor%

                  |
+---------------------------------------------------------------------------
--+
| GRANT USAGE ON *.* TO 'nestor''%' IDENTIFIED BY PASSWORD
'93c8c803300d29b9' |
| GRANT ALL PRIVILEGES ON `test`.* TO 'nestor''%' |
+---------------------------------------------------------------------------
--+

IS the same on both my W2K and my Mac OS X

Nestor :-)

Nestor A. Florez

>>> Victor Pendleton <VPendletonhoovers.com> 11/13/2003 11:01:37 AM
>>>
execute show grants for nestor'%' and see what that user has.

-----Original Message-----

I forgot to mentioned that this same code works on the same database
on
my W2K
but I am having problems on my Mac OS X (Darwin). I sqldump the
database from my W2K
to my Mac Os X.

Nestor :-)

Nestor A. Florez

>>> Nestor Florez 11/13/2003 10:17:37 AM >>>
I have a mysql db where via a web page I access a database
I have set the permissions to
grant select, insert, update, delete on test.* to nestorlocalhost
identified by 'nestor';
flush privileges;

The database has 3 tables. I can select via PHP code all the tables,
but when I try to insert
or update 2 of the tables allow me but there is one table that does
not.
My schools table refuses to insert or update, but my courses_eng and
course_esp
allows me to select, insert, update, delete

I them gave the following command:
grant all privileges on test.* to nestorlocalhost identified by
'nestor';
grant all privileges on test.* to nestor'%' identified by 'nestor';
flush privileges;

I am still not able to insert and update to the school table, but I
can
do this on
the course_eng and course_esp tables.

Any ideas.

Thanks,

Nestor :-)

Nestor A. Florez

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=VPendletonhoovers.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]