creating MySQL Users
| From: | Liam | Date: | Fri, 29 Mar 2002 22:26:40 +0000 |
| Subject: | creating MySQL Users | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-90661@lists.php.net to get a copy of this message | ||
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