Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Hiding Db

forums › forums › SQLyog › Using SQLyog › Hiding Db

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • August 3, 2005 at 7:12 am #9144
      danielfranklin
      Member

      If I have a user “xyz”, What should I do to hide the Database “mysql”(the main D:cool: from xyz??

      Plz help me out.

    • August 3, 2005 at 7:17 am #18840
      peterlaursen
      Participant

      disable ALL (including SELECT) global privileges (from user management .. edit user) for that user to MySQL-DB in SQLyog user management

      Use the “manage permission” and not “edit user” to give specific privileges to specific databases (or tables or columns) only.

    • August 3, 2005 at 8:18 am #18841
      Ritesh
      Member

      It also depends upon the version of MySQL you are using. Older version of MySQL will display all the database names even though you dont have any permission on it.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.