Create database in MySQL for PHP website

Windows 7 system with IIS 7.5

Go to start- all program-mysql- mysql server5.1–command line client

In the command line window.

mysql> mysql> create database databasename;

Query OK, 1 row affected (0.00 sec)

mysql>> GRANT ALL ON databasename.* TO ‘username’@’localhost’ identified by ‘yourpassword’;
Query OK, 1 row affected (0.00 sec)

Now go to the website’s installation folder, finish the installation there.

Change password
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘MyNewPass’);