Home mysql-user-management
Post
Cancel

mysql-user-management

Create User

 CREATE USER 'example_user@host' IDENTIFIED BY 'example_passwd';

Alter User

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

Grant

Privilege Levels

  • USAGE
  • ALL PRIVILEGES
  • GRANT OPTION
GRANT USAGE ON *.* TO 'user123'@'%' IDENTIFIED VIA PAM using 'mariadb' require ssl ;
GRANT ALL ON webdata.* to 'webuser' identified by 'password';

Drop User

DROP USER IF EXISTS bob;
This post is licensed under CC BY 4.0 by the author.