Sunday, November 16, 2014

How to Set Prividge for MYSQL using phpmyadmin

Step 1:
 Open http://localhost/phpmyadmin/

Step 2: Click on Home ICon

Step 3:  Click on Privileges Link

Step 4:  Click on Add User Link



Step 5:  Give Required User Name/ password (i.e. abc123/abc123) and select Host as 'Local' and click on 'Go' Button bottom of the page.





Step 6 :  Now select the Database where you want to apply this user credential.




Step 7 :  Click on Check all and 'Go' Button





Step 8 :  Confirm and Done.......