Saturday, 27 August 2016

Create a new user in MYSQL and set the PRIVILEGES to Database

Description :-

In below i explain about create new user in MySQL database and give the permission/privileges to access the database.

Script :-

create a new user to use following code


 Then grant the privileges to particular user as follows.
In above script grant all privileges to all databases in MySQL databases.if you want give the privilege to particular database then use following script.

No comments:

Post a Comment