1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
$log = $_POST['login'];
$pas = $_POST['pass'];
$bas = $_POST['bd'];
echo '<form action="#" method="post">
<p>
<select name="bd" style="width:150px;">
<option></option>';
$sql = 'SHOW DATABASES WHERE `database`<>"information_schema" AND `database`<>"mysql" AND `database`<>"sys" AND `database`<>"performance_schema"';
$result = mysqli_query($conn,$sql)
or die(mysqli_error());
while($row = mysqli_fetch_row($result))
{
$d = $row[0];
echo '<option value='.$d.'>'.$d.'</option>';
}
echo '</select><br>';
echo '<input name="login"><br>
<input name="pass"><br>
<input type="submit" value="Valider">
</p></form>';
$add_user = "CREATE USER '$log'@'localhost' IDENTIFIED BY '$pas' ";
$query = mysqli_query($conn,$add_user);
$quer = "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP ON $bas.*TO'$log'@'localhost' WITH GRANT OPTION ";
$querz = mysqli_query($conn,$quer);
$ques = "FLUSH PRIVILEGES";
$querx = mysqli_query($conn,$ques);
$lino = mysqli_connect('localhost', 'root', '','mysql');
$dru = "DELETE FROM user WHERE User='' ";
$queru = mysqli_query($lino,$dru); |
Partager