Server : Apache System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64 User : apache ( 48) PHP Version : 8.0.28 Disable Function : NONE Directory :  /var/www/html/mmishra/mm/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
$mdb = mysql_connect("localhost","root","imac");
mysql_select_db("mysql", $mdb);
//if exists throws error
//CREATE DATABASE WITH USERid   
if (mysql_query("CREATE DATABASE icdp", $mdb)) {
	print("Database icdp created.\n<br>");

         //CREATE USER WITH localhost
         if (mysql_query("CREATE USER 'icdp'@'localhost' IDENTIFIED BY 'icdp'", $mdb)) {
         	print("Local account icdp created.\n<br>");
         }
         //CREATE USER for any hosts
         if (mysql_query("CREATE USER 'icdp'@'%' IDENTIFIED BY 'icdp'", $mdb)) {
         	print("Network account icdp created.\n<br>");
         }
         //GRANT ALL permissions to userid@localhost ON userid DATABASE
         if (mysql_query("GRANT ALL PRIVILEGES ON `icdp`.* TO 'icdp'@'localhost' WITH GRANT OPTION", $mdb)) {
         	if (mysql_query("GRANT ALL PRIVILEGES ON `icdp`.* TO 'icdp'@'%' WITH GRANT OPTION", $mdb))
                	print("Access permission set\n<br>");
                else
                	print("Error in access permission.\n<br>");
         }
         mysql_query("SET PASSWORD FOR 'icdp'@'localhost' = PASSWORD('icdp')", $mdb);
         mysql_query("SET PASSWORD FOR 'icdp'@'%' = PASSWORD('icdp')", $mdb);
         mysql_query("FLUSH PRIVILEGES");
}
mysql_close($mdb);
?>