Question - How to add users in MySQL?
Answer -
To simply put, the user can be added by using the CREATE command and specifying the necessary credentials. First, log in to the MySQL account and then apply the syntax. Something like this:
CREATE USER ‘testuser’ IDENTIFIED BY ‘sample password’;
Users can be granted permissions, by the following commands:
GRANT SELECT ON * . * TO ‘testuser’;