[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [cobalt-developers] Creating MySQL Database from PHP

<HTML>
<HEAD>
<TITLE>MySQL user</TITLE>
</HEAD>
<BODY BGCOLOR=white TEXT=black>
<font face='verdana, arial' size=1>
<?
if( $navn && $kodeord ) {

echo "$addremove user $navn with password $kodeord...<br>";
mysql_connect( "localhost", "root", "$pwdadmin" );
echo mysql_error();




if ( $addremove == "remove" ) {
mysql_query( "drop database $navn" );
echo mysql_error();
}


if ( $addremove == "add" ) {
mysql_query( "CREATE DATABASE $navn" );
echo mysql_error();
}



mysql_query( "GRANT ALL PRIVILEGES ON $navn.* TO $navn@localhost IDENTIFIED
BY '$kodeord'" );
echo mysql_error();

echo "<BR><CENTER><FONT COLOR=red>User $addremove!</FONT></CENTER><BR>";
echo "<BR></BODY></HTML>\n";
exit;
}
?>

<H3>Add/remove MySQL user</H3><BR>
<P>
<FORM ACTION="index.php" METHOD=post>
<table>
<tr><td><font face='Trebuchet MS, Tahoma, Verdana' size=3>PWD
ADMIN!:</td><td><input type=text size=20 name=pwdadmin></td></tr>
<tr><td><font face='Trebuchet MS, Tahoma, Verdana'
size=2>Username:</td><td><input type=text size=20 name=navn></td></tr>
<tr><td><font face='Trebuchet MS, Tahoma, Verdana'
size=2>Password:</td><td><input type=text size=20 name=kodeord></td></tr>
</table>
<input type="radio" value="add" name="addremove">add<br>
<input type="radio" value="remove" name="addremove" checked>remove<p>
<input type=submit name="Opret" value="Go!"><br>
</p>
</form>
<p>
<font size=-1>
<i>Username is both being used as database name and as MySQL username. The
new user is granted local and remote access to his database. (select,
insert, update, delete) - but not options for create and drop and no
administrative rights (reload, shutdown, status, etc.). </i>
<br>

this is what i use



Steffan