RE: [PHP] creating MySQL Users

2002-03-29 Thread Joel Caturia
DAMMIT.. It's too early, I knew I was gonna make that mistake.. GET/PUT/POST, what's the difference right? Sorry, post would be the right method to use.. agh.. - Joel -Original Message- From: Liam [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 2:27 PM To: [EMAIL PROTECTED] Su

RE: [PHP] creating MySQL Users

2002-03-29 Thread Joel Caturia
I think you'll find this works better if you use "PUT" as your method, as opposed to POST, which is for File Uploads. (http://www.php.net/manual/en/features.file-upload.php#features.file-upl oad.post-method) Is your code ever actually getting into the 'if' construct, if not, that's probably you

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 MySQL Users 29/03/2002