create-dba-user.md

CREATING MYSQL USERS/ACCOUNTS

GET HELP

mysql>help create user

CREATE DBA USER

mysql>CREATE USER IF NOT EXISTS bob IDENTIFIED BY 'xxxxx' PASSWORD EXPIRE NEVER ACCOUNT UNLOCK;

GRANT PERMISSIONS

mysql>GRANT ALL PRIVILEGES ON *.* TO bob WITH GRANT OPTION;

FLUSH PRIVILEGES

mysql>FLUSH PRIVILEGES;

CREATE USER WITH EXPIRED PASSWORD

mysql> CREATE USER john IDENTIFIED BY 'P@ssw0rd' PASSWORD EXPIRE;