execute show grants for nestor@'%' and see what that user has. -----Original Message----- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:21 PM To: Nestor Florez; [EMAIL PROTECTED] Subject: Re: Grant permissions problems - help
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]