Mysql new user addition

login as root

add new user:

mysql> CREATE USER 'some_user'@'localhost' IDENTIFIED BY 'my_password';


grant all the permissions to the new user:

mysql> GRANT ALL PRIVILEGES ON *.* TO ’some_user’@’localhost’;

grant only usage permissions to the newly crated user:
mysql> GRANT USAGE ON *.* TO 'some_user'@'localhost' IDENTIFIED BY 'my_password';