CREATE DATABASE wp_manager; GRANT ALL PRIVILEGES ON wp_manager.* TO 'wpweb'@'localhost' IDENTIFIED BY 'Password-123' WITH GRANT OPTION; FLUSH PRIVILEGES;
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>
Edit the following lines:
<property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property> <property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>
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.