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 gel
y 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: Gran
MAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant permissions problems - help
+--
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 per
13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant permissions problems - help
+---
--+
| Grants for [EMAIL PROTECTED
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 PRO
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. F
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor'@'%' I
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 rea
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
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
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
If mysql owns them, 0770 should be fine.
System Administrator a.k.a. The Root of the Problem wrote:
>USually all the databases sets up fine BUT recently, I have
>had to adjust databases to 0777 in order to get them to
>work and change the ownership.
>
>I prefer the more secure model of mysql.
>
USually all the databases sets up fine BUT recently, I have
had to adjust databases to 0777 in order to get them to
work and change the ownership.
I prefer the more secure model of mysql.
How can I fix this?
--
contact:
Dave Yadallee NetKnow The Internet Knowledge Company
[EMAIL PROTECTED]
On Tue, 14 Aug 2001, Gerald Clark wrote:
>You are connecting TO host www.4cdg.com, but the permission table entry
>list the hosts you connect FROM.
>
Actually, it is just one host...I am running on FreeBSD and I have
to specify the hostname on the command line.
>You need to grant privileges to
You are connecting TO host www.4cdg.com, but the permission table entry
list the hosts you connect FROM.
You need to grant privileges to the user and machine you connect FROM.
Butch Evans wrote:
> Can anyone explain why this is happening?
>
>
> root@www:/# mysql -u dgadmin -h www.4cdg.com -p
Hi,
> Can anyone explain why this is happening?
>
>
> root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
> (Using password: YES)
remove the space between -p and the password.
Rgds,
Indrek
--
For technical
OTECTED]]
> Sent: 14. august 2001 07:48
> To: Mysql List
> Subject: Permissions Problems
>
>
> Can anyone explain why this is happening?
>
>
> root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
> Enter password:
> ERROR 1045: Access denied for user: '
Can anyone explain why this is happening?
root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Here is the permissions table:
mysql> select host,db,user from db where db like "cdgcatalog";
+---
19 matches
Mail list logo