I'm trying to create a new users using HeidiSQL GUI for it. I created a test database with two tables and I created a new user. This new user only have permissions to select and insert into ONLY ONE of the tables, HeidiSQL creates the user ok but when logging in with that new user, the user sees everything (other database and others tables) and can modify the table you shouldn't even be able to see.
Does anyone know what this error an if it could be solve? I have tested on several computers and I´ve reproduced the error in some yes and in others no.
Thaks in advance. Blanca