Forum d'entraide PHPFrance

<?PHP
$mysqli = mysqli_init();
$resultat = $mysqli->real_connect('localhost', 'root', '', 'kaligraphe');
print "ligne 3";
if ($mysqli->connect_error) {
    die('Erreur de connexion (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
print "ok";
$requete = "grant all on kaligraphe.* to 'mouchette' identified by 'muche'";
$resultat =$mysqli->query($requete);
 var_dump($resultat);
$requete = "show grants for mouchette";
$resultat =  $mysqli->query($requete);
while ($obj = $resultat->fetch_object())
{
print_r($obj);	
} 
var_dump($resultat);
 
 $mysqli->close();

$mysqli = mysqli_init();
$resultat = $mysqli->real_connect('localhost', 'mouchette', 'muche', 'kaligraphe');
//$resultat = $mysqli->real_connect("localhost", "admin", $passe);
if ($mysqli->connect_error) {
    die('Erreur de connexion (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
print "jok";
?>

ligne 3ok
bool(true)
stdClass Object ( [Grants for mouchette@%] => GRANT USAGE ON *.* TO 'mouchette'@'%' IDENTIFIED BY PASSWORD '*D2CD171C3105C13ECFA4ED97DB8FE75B1BE3DA7E' ) stdClass Object ( [Grants for mouchette@%] => GRANT ALL PRIVILEGES ON `kaligraphe`.* TO 'mouchette'@'%' )
object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(2) ["type"]=> int(0) }
Erreur de connexion (1045) Access denied for user 'mouchette'@'localhost' (using password: YES)

create user 'mouchette'@'localhost' identified by 'muche';
-- suivis de 
GRANT SELECT, EXECUTE, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `kaligraphe`.* TO 'mouchette'@'localhost';
-- plus
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'mouchette'@'localhost'  IDENTIFIED BY 'muche' WITH GRANT OPTION;