hi. i want to create mysql databse and assign user to it with previlegies.

i can create databse. but cannot assign user to it. can anyone help me?

this is my code.

PHP Code:

<?php
$link = mysql_connect("localhost", "root", "")or die("Could not connect: " . mysql_error());
print ("Connected successfully");

$result = mysql_query("CREATE DATABASE `palsitet_testuchun` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci",$link)or die("Invalid query: " . mysql_error());

/*and user creation and here*/

mysql_close($link);
?>

Please help.

i founded it by myself. thank you very much.

<?php
$link = mysql_connect("localhost", "root", "")or die("Could not connect: " . mysql_error());
print ("Connected successfully");

$result = mysql_query("CREATE DATABASE `palsitet_testuchun` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci",$link)or die("Invalid query: " . mysql_error());
$result = mysql_query("CREATE USER 'palsitet'@'localhost' IDENTIFIED BY 'aaa';",$link)or die("Invalid query: " . mysql_error());
$result = mysql_query("GRANT SELECT,INSERT,UPDATE,DELETE ON palsitet_testuchun.* TO 'palsitet'@'localhost';",$link)or die("Invalid query: " . mysql_error());


mysql_close($link);
?>