Nestor Florez wrote:
> I actually took a look at the mysql.user table and user nestor has a
> password in both entries to the table.
> One entry is for localhost and the other is for '%';
>
> I try inserting from the command line and I get:
> mysql> insert into School (school_desc) values ('Nestor');
> Query OK, 1 row affected (0.00 sec)
OK, mysql says it inserted this row with no errors.
>
> Even when I do it as the main root for mysql the record is not
> inserted.
Why do you think the row is not inserted?
>
> Do you know how to reset the auto_increment
Depends on what you mean. What exactly do you want to happen to the
auto_increment column?
>
> Nestor :-)
>
> Nestor A. Florez
>
>
>
>>>>Victor Pendleton <VPendleton@stripped> 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:Nflorez@stripped]
> Sent: Thursday, November 13, 2003 1:04 PM
> To: VPendleton@stripped; mysql@stripped
> 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 <VPendleton@stripped> 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 nestor@localhost
> 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 nestor@localhost 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
>
>
>
