MySQL Configuration
Download and install MySQL 4.1/5.0 from http://dev.mysql.com/downloads/mysql To verify that MySQL is running, type mysql in a Command Prompt or Terminal. You should see something like this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 303 to server version: 5.0.27-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
If the command is not recognized, MySQL's bin directory is not in the path. To add MYSQL to the path, edit the System Variables and include $MYSQL_HOME/bin to the existing path. In addition, MySQL can also be run from $MYSQL_HOME/bin where $MYSQL_HOME is the folder where MySQL is installed.
If you are using Windows, open the MySQL my.ini file located in the MySQL program folder (eg C:\Program Files\MySQL\MySQL Server 5.0) and add the following code under the [mysqld] section:
max_allowed_packet=16M
key_buffer=16M
If you are using Linux/*nix/OS X, you will need to create this file from one of the default configuration files bundled with MySQL. These files are described at http://dev.mysql.com/doc/refman/5.0/en/option-files.html. Open the my.cnf file located in the /etc directory and add the following code under the *[mysqld]* section:
max_allowed_packet=16M
key_buffer=16M
Restart MySQL server for these changes to take effect (the changes will allow files up to 16MB in size to be uploaded to the CMS).
In Windows, open a Windows Command Prompt, or in Linux/*nix/OS X, open a Terminal.
At the prompt, type:
mysqladmin -u root -p create cascade
Please enter the following commands:
mysql -u root -p
ALTER DATABASE `cascade` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
exit
This will create a new database called "cascade".
Download and unzip the appropriate default MySQL database:
Cascade Server 5.x: http://www.hannonhill.com/downloads/cascade/mysql5x.zip
Cascade Server 4.x: http://www.hannonhill.com/downloads/cascade/mysql4x.zip
To populate the database, enter the following into the Command Prompt (Windows):
mysql -- default-character-set=utf8 -u root -p cascade < {PATH_TO_FILE}\cascade.sql
or Terminal (Linux/*nix/OS X):
mysql -- default-character-set=utf8 -u root -p cascade < {PATH_TO_FILE}\cascade.sql
where PATH_TO_FILE is the location to which you saved the cascade.sql file.
The database is now configured. Continue on to the Running Cascade Server section.