Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › grant to Users?
grant all on databasename.* to user@host identified by 'password'
Obligatory link to the manual page that should be consulted before asking questions that have already been answered in the manual.
HTH,
=C=
Why do people confuse SQLyog with Webyog?
Webyog is the company name and SQLyog the product…..
Anyway, great to know that people are using SQLyog 😀
well have to do someone's else job as the main person is away so you can think of a newbie here. 😛
What i was concerned about the grant all….
Instead of grant all what specific grants we can give for normal users?
Thanks in advance.
You can provide specific permissions like Select, Update, Insert, Delete, Create, Drop, Grant, References, Index, Alter for a DB to a user 😀
HTH