<?php
print "<html><body>";
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'nicole1983';
if(isset($_POST['database_name']) && ($database_name = $_POST['database_name'] <> "" ))
{
print "About to create database..";
$database_name = $_POST['database_name'];
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
#echo 'Connected successfully';
$sql = 'CREATE Database '.$database_name;
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not create database: ' . mysql_error());
}
print "Database ".$database_name." created successfully\n";
if(isset($_POST['database_user']) && ($database_user = $_POST['database_user'] <> "" ))
{
$database_user = $_POST['database_user'];
$sql = "CREATE USER '".$database_user."'@'localhost' IDENTIFIED BY 'secret';";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not create database: ' . mysql_error());
}
print "User ".$database_user." created successfully\n";
$sql = "GRANT ALL ON ".$database_name.".* TO '".$database_user."'@'localhost';";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not grant privileges to user: ' . mysql_error());
}
print "Granted privieleges successfully...\n";
}
mysql_close($conn);
}
else
{
print "<p>You didnt specify a database to create. Nothing will be done</p>";
print '<p><a href="./createtable.html">Try again</a></p>';
}
print "</body></html>";
?>
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
He is a full stack developer, whose favorite languages are currently Python and Vue.js. He is also fluent in Javascript, Flutter/Dart, Perl, PHP, SQL, C and bash shell scripting. He loves Linux, and can often be found tinkering with linux kernel code, and source code for GNU applications. He used to be an active developer on XDA forums, and his tinkered ROMS used to be very popular in the early 2000s.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.