Table of Contents

Configure MySQL

Script for Creating the Database

 CREATE DATABASE wp_manager;
 GRANT ALL PRIVILEGES ON wp_manager.* TO 'wpweb'@'localhost' IDENTIFIED BY 'Password-123' WITH GRANT OPTION; 
 FLUSH PRIVILEGES;

The Hibernate.cfg.xml File

The database configuration file is located in “C:\inetpub\wwwroot\XcaliburW\bin”. Open this file with a text editor and edit the following lines: 

 <?xml version="1.0" encoding="utf-8"?>
 <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
   <!-- an ISessionFactory instance -->
   <session-factory xmlns="urn:nhibernate-configuration-2.2">
     ...here...
   </session-factory>
 </hibernate-configuration>

Configure MySQL Usage

Edit the following lines: 

    <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
    <property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>

Connection String

Edit the following line: 

 <property name="connection.connection_string">Server=127.0.0.1;Database=wp_manager;User=wpweb;Pwd=password;</property>

The value “password” corresponds to the password you chose during the creation of the wpweb account.