ARTICLE

Set Privileges in MySQL

Posted by Sharad Gupta Articles | PHP December 13, 2012
In this article I am going to explain how to set privileges in MySQL of WampServer.
Reader Level:

Set MySQL user id and password in WampServer

If you want to create a new WampServer database in MySQL then you should have the user id and password. If you do not have the uid and password and try to create a database then an error will occur.

For example

<?php

$con=mysql_connect("localhost","","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

if (mysql_query("CREATEDATABASEC_sharp_emp",$con))

  {

  echo "Databasecreated";

  }

else

  {

  echo "Errorcreatingdatabase:" . mysql_error();

  }

 

mysql_close($con);
?>


The following error will be generated.

Output

php-admin-output1-in-php.jpg

To solve this problem or if you want to create a user id and password, you can use the following steps.


Step 1

Click on the WampServer icon, a pop up window is opened. Then click on phpMyAdmin.

php-admin1-in-php.jpg

Step 2

A new phpadmin window is opened as given below.

php-admin2-in-php.jpg

Step 3

After step 2, click on MySQL option which is at the right side of phpadmin window.

php-admin3-in-php.jpg

Step 4

After performing Step 3, again a new window is opened. In it you can click on the Privileges menu, which is at the upper-left side of this window.

php-admin4-in-php.jpg

Step 5

After completing Step 5, again a new window is opened, in it you can click on the Add user icon or Add user text.

php-admin5-in-php.jpg

Step 6

After doing step 5, again a new pop up window is opened. In it provide all necessary information according to your requirements and then click on the Add user button.

php-admin6-in-php.jpg

Step 7

After completing all the preceding steps you have added a new user.

php-admin7-in-php.jpg

After performing all the preceding steps you have a user id and password. You can easily create a database in MySQL and can perform operations on it.

<?php

$con=mysql_connect("localhost","sharad","gupta");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

if (mysql_query("CREATEDATABASEC_sharp_data",$con))

  {

  echo "Databasecreated";

  }

else

  {

  echo "Errorcreatingdatabase:" . mysql_error();

  }

 

mysql_close($con);

?>

Output

php-admin-output2-in-php.jpg

COMMENT USING