Thursday, 7 February 2019

Display(Permission) one table/view to a new user in MySQL

For the one table permission to view data, follow the below process: 

1) Create the MySQL User 

CREATE USER 'USERNAME'@'USER_IP/HOST_NAME';

2) Execute the permission query to view only single table/view data

GRANT SELECT ON database.table / view to 'username'@'USER_IP/HOST_NAME' identified by 'password';