MySQL Tutorial
Introduction Installation of MySQL Getting MySQL server information RDBMS Concepts Data Definition Language Data types Managing Databases Managing Tables Managing Views Inserting records in a table Updating records in a table Deleting records from a table Retrieving Records Data Control Language Variables in MySQL Procedures in MySQL Built-In functions in MySQL User Defined functions in MySQL Triggers in MySQL Cursors in MySQL Transaction control Event scheduler Tuning MySQL Server Performance Managing users Importing and Exporting data Database Testing Workbench PHPMyAdminManaging 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’;
Web development and Automation testing
solutions delivered!!