Hi folks,


I issued following command;

CREATE DATABASE mail;
GRANT all privileges on mail.* TO user-1@localhost IDENTIFIED BY 'pass1' ;
GRANT all privileges on mail.* TO user-1@127.0.0.1 IDENTIFIED BY 'pass1' ;


Now I need to revoke user-1's prvileges assigning it to user-2. How can I make it?

TIA


B.R.
satimis

http://dev.mysql.com/doc/refman/5.0/en/revoke.html

Originally Posted by chrishirst

http://dev.mysql.com/doc/refman/5.0/en/revoke.html

Hi chrishirst,


Thanks for your URL.


Is there any way to change user-1 to user-2 (allowing user-2 retaining all privileges) and pass-1 to pass-2 at the same time? TIA


B.R.
satimis