RE: [PHP] creating MySQL Users

2002-03-29 Thread Joel Caturia
PROTECTED] Subject: [PHP] creating MySQL Users 29/03/2002 10:26:41 PM Hi, I've been trying to work this out, but I can't. Myabe I need more sleep, I'm sure it's something really stupid. Could someone have a look over this code for me please? It's meant to add MySQL use

RE: [PHP] creating MySQL Users

2002-03-29 Thread Joel Caturia
, if not, that's probably your answer! - Joel -Original Message- From: Liam [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 2:27 PM To: [EMAIL PROTECTED] Subject: [PHP] creating MySQL Users 29/03/2002 10:26:41 PM Hi, I've been trying to work this out, but I can't

Re: [PHP] creating MySQL Users

2002-03-29 Thread Rafael Perazzo
Try this query : $query = "GRANT SELECT,INSERT,UPDATE,DELETE,ALTER "; $query .= "ON $username "; $query .= "TO $username@localhost "; $query .= "IDENTIFIED BY '$password';"; Make sure that you put a blank space after each string, except the last one. I hope this work! Rafael Peraz

RE: [PHP] creating MySQL Users

2002-03-29 Thread Rick Emery
> $query .= "ON $username"; The ON clause should identify the database name, not the user. It should appear as "*.*. -Original Message- From: Liam [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: [PHP] creating M

[PHP] creating MySQL Users

2002-03-29 Thread Liam
29/03/2002 10:26:41 PM Hi, I've been trying to work this out, but I can't. Myabe I need more sleep, I'm sure it's something really stupid. Could someone have a look over this code for me please? It's meant to add MySQL users. "> User Password Thanks, Liam -- PHP General Mailing List