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
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
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
Hi Nestor. What does the mysql_error() report as the exact error
message? This could help you identify what kind of access control
issue it is.
Alternatively, you could try running the same query from the command
line (using the mysql client) and see if you get the same error.
Also, I'm not
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor'@'%'
I just realized that if I login to mysql as the user I can insert
records.
It must be somehting with my code
I will try the trace_on
It is just amazing that the same code works in my W2K machine
and when I ftp it to the Mac OS X only adding to th eschools fails.
Thanks,
Nestor :-)
Nestor A.
OK guys this is beyond me.
I just found out that I can NOT insert into my SCHOOL table
when I login into mysql as user nestor on my Mac OS X.
The table is autoincremented. how do I find out what is the next
number to be incremented?
Nestor :-)
Nestor A. Florez
Nestor Florez [EMAIL
13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant permissions problems - help
+---
--+
| Grants for [EMAIL PROTECTED
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
.
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
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
Thanks for the help to ALL
I got it to work.
I do not know how but I think that they might have been hidden
characters in the program doing insert
in the actuall insert statements. I retyped the insert code in the
program and things started to
work. Probably when I ftp the code somethin
I duplicated the mysql database from another machine by copying over the
table files. But now I find myself unable to access the tables.
I restarted the mysql server using the --skip-grant-tables option. Then
I could access the tables, but the grant command wasn't recognized so I
couldn't just
Check the file ownership, and make sure that its the same as the mysql user.
Barry Gold wrote:
I duplicated the mysql database from another machine by copying over the
table files. But now I find myself unable to access the tables.
I restarted the mysql server using the --skip-grant-tables
Hello.
I want to create a user in mysql that can create and "grant" other users
with permissions to a specific table.
I created user with permitions of "grants", and permissions of "insert" and
"grant" to "mysql" database, and I cant add users with that user.
I want that this user could add
I'm confused, and wondering if anyone can help me.
I'm running 2 virtual servers, let's say server1.domain.com and
server2.domain.com. These virtual servers sit on servers named host1.isp.com
and host2.isp.com respectively (I hope I haven't lost anyone yet).
I have a perl script, that lists the
16 matches
Mail list logo