new user with access to only one database

[sjoerd]

you can add a new user with access to only one database.

How do i do that ?

[Wiedmann]

Code: Select all

GRANT ALL PRIVILEGES ON `db_name`.* TO 'user_name'@'localhost' IDENTIFIED BY 'user_password'

[sjoerd]

Where do i have to typ that ? Sorry i am a n00b
And do i first have to make a user somewhere ?