Answers for "sql creating a user with . in name"

sql create user

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
# Some PHP versions may have issues with the above statement
# use the older mysql_native_password plugin instead:
CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
# Give access to all databases with all privileges like root user
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
# Give access to SPECIFIC database with all privileges
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
# when done, flush privileges.
FLUSH PRIVILEGES;

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