Delete MySQL user To remove a MySQL user account run this command:
mysql> drop user [username];
Dropping user will not disconnect an active database session, it will take effect after the user disconnects.
Create new MySQL user account The command below will create MySQL user called 'testuser' on localhost with all privileges for database called 'testdb' and with password 'mypassword'. Connect to the server with mysql and run command:
grant all on testdb.* to testuser@localhost identified by 'mypassword';
