CREATE, ALTER & DROP USER
Learn CREATE, ALTER & DROP USER (User Management & Security, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction In MySQL an account is the pair 'user'@'host' : the same name from a different host is a different account. CREATE USER makes it (with an authentication plugin, default caching_sha2_password in 8.0), ALTER USER changes password, lock state, limits and TLS rules, and DROP USER removes it with all its privileges.