Results 1 to 2 of 2

Thread: Show Grants

  1. #1
    Join Date
    Feb 2004

    Unanswered: Show Grants


    Plz see the below statements

    mysql> show databases;
    | Database |
    | abcd |
    | mysql |
    | test |
    3 rows in set (0.00 sec)

    mysql> use abcd;
    Database changed
    mysql> show grants for root@localhost;
    +-------------------------------------------------------------------------| Grants for root@localhost |
    +-------------------------------------------------------------------------| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
    | GRANT ALL PRIVILEGES ON `x`.* TO 'root'@'localhost' WITH GRANT OPTION
    +-------------------------------------------------------------------------2 rows in set (0.01 sec)

    Here i wanated to know why to grant have displayed, what is this 'x'??
    is it a user? Im working in an existing sytem.In my knowldge there is supposed to have only the first line. Can anybody tell me whats this 'x'?


  2. #2
    Join Date
    Dec 2004
    `x` is, or was, a database. You can grant privileges on nonexistent databases, and when you remove a database it does not remove associated privileges.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts