+-----------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+-----------------------------------------------------------------------------+
| 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 <[EMAIL PROTECTED]> 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 [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]
