how to open and create new user in mysql

 open terminal : ctrl + alt + t

type mysql -u <username> -p eg: mysql -u root -p 

create user :  CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';

eg : CREATE USER 'banking'@'localhost' IDENTIFIED BY 'banking'; 

 grant privileges to user

GRANT ALL PRIVILEGES ON your_database.* TO 'username'@'localhost';
 

eg : GRAND ALL PRIVILEGES ON dbname.* TO 'banking'@'localhost';

 

FLUSH PRIVILEGES;  

 

how to list the user in mysql ?

SELECT user, host FROM mysql.user;

DROP USER 'username'@'localhost';