dropping a mysql user

[graziano]

Hello,

anyone may tell me what's wrong here ?
(I am trying to delete mysql user user_one)

$dbh=mysql_connect ("localhost", "root", "mypass") or die ('Error' . mysql_error());
$sqlinterr = "DELETE user user_one";
$res = mysql($sqlinterr,$dbh);
mysql_close ();

Thank you
GraZ

[narch31]

You need to delete the user record from the USER table

DELETE FROM user WHERE User = "user_name";
FLUSH PRIVILEGES;

The FLUSH PRIVILEGES statement reloads the grant tables.