RE: [PHP] creating MySQL Users

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.. <Feeling incompetent now> - Joel -----Original Message----- From: Liam [mailto:phplist@operationenigma.com] Sent: Friday, March 29, 2002 2:27 PM To: php-general@lists.php.net 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 users. <FORM METHOD=POST ACTION="<?echo "$PHP_SELF";?>"> <INPUT TYPE="text" NAME="username">User<BR> <INPUT TYPE="text" NAME="password">Password<BR> <INPUT TYPE="submit"> </FORM> <BR><BR> <? if ($REQUEST_METHOD=="POST") { $mysql_access = mysql_connect("localhost", "root", "password"); if (!$mysql_access) { echo("ERROR: " . mysql_error() . "\n"); } $query = "GRANT SELECT,INSERT,UPDATE,DELETE,ALTER"; $query .= "ON $username"; $query .= "TO $username@localhost"; $query .= "IDENTIFIED BY '$password';"; mysql_query($query, $mysql_access); print("Successfully added $username to the MySQL database!"); } ?> Thanks, Liam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php