MySQL Configuration
MySQL Configuration for Windows
-
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. 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.
mysql>
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.