dropping mysql users

[graziano]

Hello,

sorry newsbie question ; is it possible to drop a mysql user using
php (it doesn't seem possible ; it seems possible on to drop databases http://www.php.net/manual/en/function.mysql-drop-db.php) .

Does exist any way to do that ?

Thank you

[packland]

hi there

The manual is the best place for what your looking for:

4.2.5 How the Privilege System Works

user info is just a record in a table and so are the users privileges so you use
DELETE, UPDATE, SELECT etc to manipulate user access. This is definitely time to read the manual, trust me!

[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 ();

[packland]

are the users user in your own tables or does this follow on from the previous question and you are trying to revoke user access. the answer to the second is in the manual eg:

4.3.1 GRANT and REVOKE Syntax

GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | | . | db_name.}
TO user_name [IDENTIFIED BY 'password']
[, user_name [IDENTIFIED BY 'password'] ...]
[WITH GRANT OPTION]

REVOKE priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | | . | db_name.}
FROM user_name [, user_name ...]

i hope that deleting user_one doesn't remove your access rights to the database!

if you want to delete the user altogether then
write a delete query with these tables

mysql> INSERT INTO user (Host,User,Password)
VALUES('%','jeffrey',PASSWORD('biscuit'));

You must also use the PASSWORD() function when you use SET PASSWORD statements:

mysql> SET PASSWORD FOR jeffrey@"%" = PASSWORD('biscuit');

If you set passwords using the GRANT ... IDENTIFIED BY statement or the mysqladmin password command, the PASSWORD() function is unnecessary. They both take care of encrypting the password for you, so you would specify a password of 'biscuit' like this:

mysql> GRANT USAGE ON . TO jeffrey@"%" IDENTIFIED BY 'biscuit';

ie DELETE from user where user = 'user_one';

I hope you know what you are doing?