Username Password in WAMPServer MYSQL

If you have wamp installed , and if you would like to know how to create username and password in mysql.
Go to http://localhost/phpmyadmin [if port changes for WAMP server use http://localhost:8080/phpmyadmin]
and click on the Privileges tab. There is a "Add a new user" link.

You can also refer to MySQL documentation on creating new user accounts.

In short, you create a user by running a CREATE USER statement:

CREATE USER "" IDENTIFIED BY "";
Once the user is created, you give him access to do things by using the GRANT statement.

Tweet