====== Configure MySQL ======
----

===== Script for Creating the Database =====

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

===== 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:

<code xml>
 <?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>

</code>


==== Configure MySQL Usage ====

Edit the following lines:

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

</code>

==== Connection String ====

Edit the following line:

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

The value "password" corresponds to the password you chose during the creation of the **wpweb** account.