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

Sqlyog and database permissions

forums › forums › SQLyog › Using SQLyog › Sqlyog and database permissions

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • May 15, 2003 at 8:52 am #14285
      alistair
      Member

      OK, I'm stupid! PHPMyAdmin HIDES all the databases apart from your own. sqlyog doesn't! You can see ALL the databases on the server but you can only access your own. It's still a security hole though. Can it be set up to ignore/hide all databases that you don't have rights on?

      Alistair

    • May 15, 2003 at 10:49 am #14286
      Shadow
      Member

      I use SQLyog v3.11 and it does not display all the databases, just the ones the user has access to. Try checking the global rights!

    • May 15, 2003 at 11:24 am #14287
      alistair
      Member

      I downloaded 3.11 and it still displays all the databases! When you say Global rights – do you mean on the mysql server or is it a setting in sqlyog?

      Thanks for your help,

      Alistair

    • May 15, 2003 at 12:44 pm #14288
      CalEvans
      Member

      This is an issue with MySQL. myPHPAdmin works around it but traditionally, clients have not had to work around it as the servers have dealt properly with it.

      I'm hoping that this will be resolved in the 4.x brance of MySQL but it's really not the client's (SQLyog) issue to resolve.

      =C=

    • May 15, 2003 at 12:59 pm #14289
      alistair
      Member

      OK, thanks for that Cal 🙂

    • May 15, 2003 at 3:49 pm #14290
      Shadow
      Member

      It seems, it is already done in MySql 4.1, because I don't get all the databases listed and I use 4.1-alpha…

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