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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Grant permissions problems - help
+---------------------------------------------------------------------------
--+
| 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]
