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.
FLUSH PRIVILEGES;

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.
Details:
 Filename:
\\?\C:\Windows\system32\inetsrv\config\applicationHost.config
Error:
To fix this issue try this.
  1. Create the Framework64 directory for 1.1
    md \windows\microsoft.net\framework64\v1.1.4322\config\
  2. Copy the 32bit config to 64bit config location created in step 1.
    copy \windows\microsoft.net\framework\v1.1.4322\config\machine.config \windows\microsoft.net\framework64\v1.1.4322\config\