workbench to see only one users tables

[Søren Døygaard]

Hello there.

I am systemadministrator making mysql servers available for students at computer sciense. I have a shell script (OS = UNIX) that makes both the account in /home/xx
and the user in the mysql server.

If I use phpmyadmin to login in at the server I can only see my table and no others. This is what I want in mysqlworkbench.

How can I when using workbench only see the present users tables and not all the others ?

the grant I use is the following (it probably need to be modified - please help)

grant ALL privileges on xx.* to xx@localhost identified by yy;