MYSQL under IIS

Configuration of MYSQL under IIS:

If you want to use asp .net along with MYSQL, you need to first configure it with IIS server. So, this tutorial will teach you how to configure MYSQL under IIS server.

Step1:

1.      You need to have MYSQL 5.0 or any (size: ~ 40 MB)

2.      You need to have MYSQL GUI tools (size:~ 20MB)

3.      You need to have MYSQL work bench as optional (size:~10MB)

Step2:

Install the MYSQL 5.0 (No difficulty here)

Install the MYSQL GUI Tools (No difficulty here)

Now, MYSQL server Instance config wizard will open.

Select the default (checked) values itself.

Ensure port is 3306.

If so, go to control panel—windows firewall—exceptions tab—Add Port—Port Number—type3306. Name: 3306. Click OK

Come back to wizard –

Root password:                                                                                                                                            Confirm password:

Type: root as password.

Now, your sever is Local host; username: root; password: root

Execute –Go to “C:\Prm Files\Mysql\Server\my.ini” and copy and paste the “my.ini” to C:\Windows.

If in any case you get any error like: Error 1045.

Follow this step. Initially you will get this error if you are installing new or first on your system. So, follow the below steps to solve that problem. By this method I am sure that problem will be solved.

Now, uninstall MYSQL. Delete MYSQL folders under program files also and then restart your system.

Now if you install back your MYSQL you won’t get that error for sure.

check configuring PHP under IIS in here:  php under iis