MANUAL TO RESTRICT A USER TO A SPECIFIC DATABASE

MANUAL TO RESTRICT A USER TO A SPECIFIC DATABASE
*************************************************************
1) First login to phpmyadmin
2) After login click on privileges
3) Then select add new user example: user : user1 Host : local host
passwd: ########
4) Then select go
5) exit
6) Please login with user1
7) you will see only default database
8) Then log off
9) Once again login to root account
10) Then click privileges
11) check the box user1 and click edit privileges
12) After that select add privileges on the following data base
13) Then from the drop down menu select the specific database
14) On selecting the data base pop the new window
15) Then check all , and give the password and select Go
16) Now exit the button .
Please see the below screen short