Wednesday, May 29, 2013

MYSQL Create new user and Grant privileges

To Create a new user in mysql
CREATE USER 'UserName'@'localhost' IDENTIFIED BY 'Password';

To Grant user access to the Database
GRANT ALL PRIVILEGES ON DatabaseName . * TO 'UserName'@'localhost';

After that Flush the privileges so the changes will take affect.

Friday, May 3, 2013

Error on IIS 7 or IIS 7.5 running .Net 1.1: \\?\C:\Windows\system32\inetsrv\config\applicationHost.config

If you try to change any property of an application that was build with dot net 1.1 on IIS 7 or IIS 7.5 get an error \\?\C:\Windows\system32\inetsrv\config\applicationHost.config. To fix this issue follow the instruction in this article

This is an error you will get.

There was an error while performing this operation.
To fix this issue try this.
  1. Create the Framework64 directory for 1.1
    md \windows\\framework64\v1.1.4322\config\
  2. Copy the 32bit config to 64bit config location created in step 1.
    copy \windows\\framework\v1.1.4322\config\machine.config \windows\\framework64\v1.1.4322\config\