Good afternoon,
I am configuring MySQL on a server by directAdmin. My problem is that I create a user and I want him to see only 5 tables of N that the database has.
If someone could give me a serious solution, it would be very helpful.
Thank you very much
Greetings.
After you create the user give him the following privileges (assuming the user is created for localhost and for 192.168.x.x)
GRANT SELECT ON basededatos.tabla TO usuario@localhost IDENTIFIED BY 'clave';
GRANT SELECT ON basededatos.tabla TO [email protected] IDENTIFIED BY 'clave';