MySql -Database-Permissions

How can i make that a DB-User can only access one Database on my MySql and don't have the permission to access all the Databases!

Thanx!

grant all on dbname.* to username@localhost identified by 'password';

But if i stop and restart the Mysql-Deamon i must redo this command or it would be done automatically??

It's a great day - today.

GRANT automatically updates the permission tables and flushes privileges so it takes effect immediately. These privilege tables are read when the deamon starts, so no, you don't have to redo them.

why does eveyone restart mysqld ??
i always adjust privileges and it just works immediately ?!?!
no restart needed

wouterr,

The reason is that before GRANT, you had to manipulate the privilege tables directly. You could do a FLUSH PRIVILEGES to force mysql to re-read them so the new privileges would take affect, but many people would restart the daemon instead.

GRANT does away with all that as it flushes automatically after updating the tables.

I really don't know why some people still insist on updating the tables directly themselves. GRANT is much easier to use and safer.