Mysql User Access | Grant Access to User in MySQL

How to give GRANT access to existing MYSQL Users ?

1) SELECT access

GRANT select on <> to <>@%

DBName > Database Name
User Name > MYSQL User Access Name

Movers in Dubai

Example :-

GRANT select on ‘MASTER.*’ to ‘GuestUser@%’


2) UPDATE, INSERT, DELETE Access

GRANT INSERT, UPDATE, DELETE on <> to <>@<>

Advertisements