I am using this code to create database on runtime. But it is not working. Getting error:
No user created.
<?php
mysql_connect('localhost','root','root');
mysql_query("CREATE USER 'xyz'@'localhost' IDENTIFIED BY '1234';");
mysql_query("GRANT ALL ON db1.* TO 'xyz'@'localhost'");
mysql_query("CREATE DATABASE locus_ag_1234");
mysql_close();
?>