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

Creating Users With Sqlyog

forums › forums › SQLyog › Using SQLyog › Creating Users With Sqlyog

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 6, 2007 at 4:47 pm #10531
      malik
      Member

      Hi

      When creating users with sqlyog is there a way to select which databses they have access to?. When i create a user they have access to all databases.

    • September 6, 2007 at 8:49 pm #24890
      peterlaursen
      Participant

      yes …

      if you grant privileges from EDIT/ADD USERS they will be GLOBAL privileges.

      To grant privileges for specific databases, tables etc use the menu 'manage permissions'

      So from EDIT/ADD USERS do not check anything, next go to 'manage permissions'.

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