MySQL Configuration
MySQL Configuration for Windows
-
Download and install MySQL 4.1/5.0. See the MySQL Reference Manual if you need help installing MySQL. To verify that MySQL is running, type mysql -u user -p in a terminal. You should see something like this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.45 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
If the command is not recognized, add the $/bin directory to your PATH environment variable ($ is the path to your MySQL directory). To do this, right-click on My Computer and select Preferences. On the Advanced tab, click Environment Variables. In the System variables area, highlight Path and click Edit. In the Variable value field, scroll to the end, add a semicolon, and type out the full path to your $/bin directory. Click OK three times out and you're done. Otherwise, navigate to the MySQL bin directory and launch MySQL programs from there. - Once installed, add the following lines to your MySQL my.ini file located in the MySQL program folder (eg C:\Program Files\MySQL\MySQL Server 5.0) under the [mysqld] section:
[mysqld]
max_allowed_packet=16M
key_buffer=16M - Restart your MySQL server for these changes to take.
-
Create a new database for Cascade Server by typing the following at a command prompt:
mysqladmin -u user -p create cascade
Note: the database created here is called 'cascade' but you can name this db whatever you like. -
Change the default character set by typing the following at a MySQL prompt:
ALTER DATABASE `cascade` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
*Note: `cascade` is encompassed in tick marks (left of the 1 key), not single quotes. -
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 -
Load the default database into the cascade database by typing the following at a command prompt:
mysql --default-character-set=utf8 -u user -p cascade < $
where $ is the path to the default database file to be imported.
Optional: If you prefer not to use root for Cascade Server, create a new user in MySQL and grant it privileges on the Cascade database. See the MySQL Reference Manual if you need help with this.