Managing users in MySQL

Creating new Users

CREATE USER ‘adam’@’localhost’
IDENTIFIED BY ‘passwd’

User Roles

You can assign the role to user using MySQL workbench UI. There is no sql statement to assign specific role to the user.

Deleting users in MySQL

To remove the user, you can use below syntax.
DROP USER ‘adam1’@’localhost’;

You may also like...