Fejl i forbindelse med MySQL og PHP

Hej i gruppen.



Koden underst skal lave x antal databaser til Joomla! udvikling. Undskylder de forsvundne indrykninger



Jeg kører følgende kode der skal sætte Bruger og Kodeord på en database, efter databasen er blevet skabt:



$sql= "CREATE USER " . "'" . $LocalUsername . "'@'" . $servername . "'" . " IDENTIFIED BY " . "'" . $LocalPassword . "'";



if ($conn->query($sql) === TRUE) {

echo "\n\n USER and PASSWORD created successfully \n\n";

} else {

die ("\n\n Error creating USER and PASSWORD: " . $conn->error . "\n\n");



Jeg får følgende fejl:



Error creating USER and PASSWORD: Operation CREATE USER failed for 'prefix0'@'localhost'





Hvor ligger fejlen? og hvordan udbedrer man den?



Har inspiration fra:

http://dev.mysql.com/doc/refman/5.5/en/create-user.html



bruger MySQL 5.5



Bruger Ubuntu Server 14.04.2



Mvh,

Thomas





Her Følger hele koden, som jeg kører med:

"sudo php -f generate_databases_in_php.php"











Database creation in PHP









<?php



$servername = "localhost";

$username = "MySQL root";

$password = "Indsaet MySQL root password her";

$startDB= 0;

$endDB= 2;

$PrefixDB="prefix";

$spreadsheetCSV="databases.csv";



// Open speadsheet for append.



$csvFile = fopen($spreadsheetCSV, "a");



// Create connection



$conn = new mysqli($servername, $username, $password);

// Check connection

if ($conn->connect_error) {

die("\n Connection open failed: \n" . $conn->connect_error);

}



for($LocalDB = $startDB; $LocalDB <= $endDB; $LocalDB++)

{





//$LocalDB=system("mkpasswd 'date +%N' ");



$DatabaseName= $PrefixDB . $LocalDB;



// Create DATABASE



$sql= "CREATE DATABASE " . $DatabaseName ;



if ($conn->query($sql) === TRUE) {

echo "\n\n DATABASE created successfully \n\n";

} else {

die ("\n\n Error creating DATABASE: " . $conn->error . "\n\n");

}



//$LocalUsername = substr(system("mkpasswd 'date +%N'"), 0);



$LocalUsername = $DatabaseName;



$LocalPassword = substr(system("mkpasswd 'date +%N'"), 0);



echo "\n\n Local Password is " . $LocalPassword . "\n\n" ;





// Create USER and PASSWORD

// HER GÅR DET GALT!



$sql= "CREATE USER " . "'" . $LocalUsername . "'@'" . $servername . "'" . " IDENTIFIED BY " . "'" . $LocalPassword . "'";



if ($conn->query($sql) === TRUE) {

echo "\n\n USER and PASSWORD created successfully \n\n";

} else {

die ("\n\n Error creating USER and PASSWORD: " . $conn->error . "\n\n");

}



// GRANT ALL ON LocalDB.* TO USERNAME



$sql = "GRANT ALL ON " . $DatabaseName . ".*" . " TO " . $LocalUsername . "@" . $servername ;



echo "\n\n" . $sql . "\n\n";



if ($conn->query($sql) === TRUE) {

echo "\n\n Granting created successfully \n\n";

} else {

die ("\n\n Error creating GRANTING: " . $conn->error . "\n\n");

}





fputcsv($csvFile, array((string)$LocalDB, $DatabaseName, $LocalUsername, $LocalPassword));







};



// Close database connection



$conn->close();



// Close csv spreadsheet file



fclose($csvFile);



?>









Mvh,

Thomas