Privileges Of User

[toma]

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' )

[peterlaursen]

@toma

Please only ask the same question once!

[Author]

Posts