list users

    0

    1

    lucycodes42

    SQL public snippets

    The SELECT statement retrieves all of the data from the mysql.user table. The user variable will contain the name of the user, the host variable will contain the name of the server on which the user account was created, and the password variable will contain the user's password.

    Shortcut: user.list

    SELECT `user`, `host`, `password` FROM `mysql`.`user`;
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.