MySQL

NEWS & TIPS

  • Site Access Keys
  • Top: Alt+t
    Previous: Alt+,
    Next: Alt+.
    Up: Alt+;
    (Note: use Ctrl on the Mac)

MySQL Configuration

MySQL Configuration for Windows

  1. 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.


  2. 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

  3. 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).

  4. 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".

  5. 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



  6. 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.

    Last modified on Tue, 15 Jan 2008 16:02:47 -0500

    Comments

    Top / Next / Up / Table of Contents