how to deny users to login to other databases on the same mysql server

[Richard Jones]

We have a lot of mysql databases, I created a user to be able to use only one one table, however, when he logs into phpmyadmin, he can see ALL the different tables, select them and everything.
So how can I make it where he can only see data from that ONE table, and not all the others?

I thought that if I granted him permissions on those databases with NOTHING in them he would not be able to view the data, but when I login as him, he still can see everything. I'm afraid he may accidentally dump everything, and this could kill our business.

So can anyone please let me know how I can find out how to do this?
Thank you much,
Richard