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

Grant Privileges

forums › forums › SQLyog › Using SQLyog › Grant Privileges

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 26, 2006 at 7:09 am #9911
      toma
      Member

      my user use aplication c# and according dll work with data in server.

      user 'basis' work wth data 'test' , user want to create new database,get all privileges on new data.

      with connection string basis/basis@test i connected to server .

      first action create new database( newtest) i did without problems.

      after action create new database i did action- use basis -to do basis working

      third action – grant all on newtest.* to basis identified by 'basis' – get error 1044

      why?

      what privileges user basis must have?

      (i must get privileges administrator to 'basis'?)

      what difference between

      (grant all on newtest.* to basis@”%” identified by 'basis'

      grant all on newtest.* to basis@”localhost” identified by 'basis' )

    • September 26, 2006 at 8:06 am #22534
      peterlaursen
      Participant

      correct syntax for GRANT is

      GRANT ALL on newtest.* to 'basis'@'somehost' …

      (note how to use quotes).

      with 'basis'@'localhost' the client program runs on the same computer as the server.

      '%' is a wildcard and means 'any host'.

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