Hi,
I have created a new user and grant only for one database

grant all privileges on A.* to a@localhost identified by 'a'

but after some time when i login with this user

and do show databases;

it show all databases on this server

when i do flush privileges commad now this user work fine show only one particular database

but after while when I login from this user all databases shows

how can counter this problem ??

grant privilieges on the required databases
MySQL :: MySQL 5.1 Reference Manual :: 12.5.1.3 GRANT Syntax

eg
grant all privileges on *.mydatabasename to auser@anipaddressOrhostname identified by 'apassword'

however I've alwasy found the grant procedure to be a bit of a pain, so tend to do it these days using MySQL Administrator GUI tool, available fromt eh MySQL website as part of the GUI Tools

I have done the grant only for one database

grant all privileges on A.* to a@localhost identified by 'a'

where A is database

but still after some time with user "a" you can access all databases
untill you do flush privileges command

the same process repeats

Problem is solved I start mysql in safe mode once