From: Nestor Florez (Nflorezguhsd.net)
Date: Thu Nov 13 2003 - 12:17:37 CST

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

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

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