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

Managing Permissions – New Host Feature

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Managing Permissions – New Host Feature

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 6, 2007 at 8:53 pm #10172
      zhuston
      Member

      It would be very nice when managing permissions for a user to have the ability to set the “Host” field in the “mysql.db” table. Currently the Host value just gets some sort of default from the mysql.user table but the user table could have multiple entries for the same “User”. Basically their does not seem to be a way to make use of the “mysql.host” table and give custom permissions for a host or give multiple hosts permission to the database by leaving the host field blank in the db table. Right now I have to modify the tables myself to make any permission changes, since we give multiple hosts access through the host table.

      See the following link to the mysql manual about how the permissions work.

      Mysql Manual permissions

    • February 7, 2007 at 6:58 am #23382
      peterlaursen
      Participant

      I am sorry, but I really do not understand!

      You can enter any valaue for 'host' and it is inserted to the `mysql`.`user`.`host` column.

      Please explain more in detail if I missed something?

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.