rugbymauri

MySQL user management cheatsheet

• List all users
• List connected users
• Create user
  • With mysql_native_password identity
  • With auth_socket identity
• Grant user specific permissions to database
• Grant root-like permissions
• List grants for user
• Reference