create a new user sql in shell code example
Example 1: create user mysql
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
Example 2: how to create new database user
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
Example 3: create user sql
-- Creates the login AbolrousHazem with password '340$Uuxwp7Mcxo7Khy'.
CREATE LOGIN username
WITH PASSWORD = 'password';
GO
-- Creates a database user for the login created above.
CREATE USER AbolrousHazem FOR LOGIN AbolrousHazem;
GO